SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[InsertTaradod]
    @taradodType dbo.taradodType  READONLY
AS
BEGIN
    SET NOCOUNT ON;

    INSERT INTO dbo.taradod
        SELECT *
        FROM @taradodType a
        WHERE NOT EXISTS (SELECT 1
                          FROM dbo.taradod
                          WHERE IDp = a.IDp
                            AND (SELECT CAST(Date AS DATETIME)) = a.date)

DataTable dtreadd = new DataTable();

 dtreadd.Columns.Add("IDp");
 dtreadd.Columns.Add("date");
 dtreadd.Columns.Add("day");
 dtreadd.Columns.Add("nobatkari");
 dtreadd.Columns.Add("code");

dtreadd.Clear();

for (int i = 0; i < dtja.Rows.Count; i++)
{
    dtreadd.Rows.Add(dtja.Rows[i]["IDp"].ToString(),DateTime.Parse(dtja.Rows[i]["date"].ToString()), GetDayOfWeek(GetPerDate2(dtja.Rows[i]["date"].ToString())), "", dtja.Rows[i]["code"].ToString());
}

SqlConnection sqlconn = new SqlConnection(DBsetting.Connstring);
sqlconn.Open();

using (sqlconn)
{
    try
    {
        SqlCommand cmd = new SqlCommand("InsertTaradod", sqlconn);
        cmd.CommandType = CommandType.StoredProcedure;

        SqlParameter dtparam = cmd.Parameters.AddWithValue("@taradodType", dtreadd);
        dtparam.SqlDbType = SqlDbType.Structured;

        cmd.ExecuteNonQuery();

        MessageBox.Show("Inserted");
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}