public JsonResult UpdateActivite(CRA_ActiviteDetailMODEL p_craAD)
{
var truc = ((CustomPrincipal)User);
p_craAD.ModificationBY = truc.FirstName + "_" + truc.LastName;
return(Json(g_cradb.UpdateActivite(p_craAD), JsonRequestBehavior.AllowGet));
}
//Method for Adding an new CRA or updating a new one
public int AddActivite(CRA_ActiviteDetailMODEL p_craAD)
{
int i;
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand com = new SqlCommand("sp_CRA_ActiviteDetail__InsertUpdate", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@CRAActiviteId", p_craAD.CRAActiviteId);
com.Parameters.AddWithValue("@DateBegin", p_craAD.DateBegin);
com.Parameters.AddWithValue("@DateEnd", p_craAD.DateEnd);
com.Parameters.AddWithValue("@CRAlibeleColId", p_craAD.CRAlibeleColId);
com.Parameters.AddWithValue("@Quantity", p_craAD.Quantity);
com.Parameters.AddWithValue("@CreationBY", p_craAD.CreationBY);
com.Parameters.AddWithValue("@ModificationBY", p_craAD.ModificationBY);
com.Parameters.AddWithValue("@Action", "insert");
i = com.ExecuteNonQuery();
}
return(i);
}
