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); }