Tag: date

Action Method:

PayTns std = new PayTns();
std.C_Group = fc(“C_Group”);
std.Date = Convert.ToDateTime(fc(“Date”));
std.C_Name = fc(“C_Name”);
std.D_Group = fc(“D_Group”);
std.D_Name = fc(“D_Name”);
std.Amount = Convert.ToInt32(fc(“Amount”));
std.Remark = fc(“Remark”);
if (D_flag == “true”)
{
std.D_Flag = true;
}
else
{
std.D_Flag = false;
}
std.T_No = Convert.ToInt32(fc(“T_No”));
Dblayer.Add_Pay(std);
TempData(“msg”) = “Data Inserted”;
ModelState.Clear();

Data Connection:

SqlCommand com = new SqlCommand(“Master_PayTns_Add”, con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue(“@Date”, ie.Date);
//com.Parameters.AddWithValue(“@A_GRef”, ie.A_GRef );
com.Parameters.AddWithValue(“@C_Group”, ie.C_Group);
com.Parameters.AddWithValue(“@C_Name”, ie.C_Name);
com.Parameters.AddWithValue(“@D_Group”, ie.D_Group);
com.Parameters.AddWithValue(“@D_Name”, ie.C_Name);
com.Parameters.AddWithValue(“@Amount”, ie.Amount);
com.Parameters.AddWithValue(“@Remarks”, ie.Remark);
com.Parameters.AddWithValue(“@D_FLag”, Convert.ToBoolean(ie.D_Flag));
com.Parameters.AddWithValue(“@T_No”, ie.T_No);

        con.Open();
        com.ExecuteNonQuery();
        con.Close();