public JsonResult Add(CRA p_cra) { var truc = ((CustomPrincipal)User); p_cra.FK_IDCONSULTANT = truc.UserId; return(Json(g_cradb.Add(p_cra), JsonRequestBehavior.AllowGet)); }
public async Task <string> DownloadCra(HttpClient client, CRA cra, KeyValuePair <int, Mission> mission) { Console.Write($"Download cra of ", Color.Gainsboro); Console.WriteLine($"{mission.Value.Client} for the {cra.Month.Month}/{cra.Month.Year}", Color.DarkKhaki); var model = new { cra.IdCol, cra.Missions.First().Value.IdClient, cra.Month.Year, cra.Month.Month }; var downloadUrl = $"http://sonet.soat.fr/PDF/CRAClient/{model.IdCol}/{model.IdClient}/{model.Year}/{model.Month}"; var filename = Path.GetTempFileName(); using (var fileStream = new FileStream(filename, FileMode.Create, FileAccess.Write, FileShare.None)) { var file = await client.GetAsync(downloadUrl); await file.Content.CopyToAsync(fileStream); } return(filename); }
//Method for Adding an new CRA or updating a new one public int Add(CRA p_cra) { int i; using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand com = new SqlCommand("sp_CRA_InsertUpdate", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@CRAId", p_cra.CRAId); com.Parameters.AddWithValue("@LIBELLE", p_cra.LIBELLE); com.Parameters.AddWithValue("@NUMCRA", p_cra.NUMCRA); com.Parameters.AddWithValue("@MOIS", p_cra.MOIS); com.Parameters.AddWithValue("@NBTOTALJOURS", p_cra.NBTOTALJOURS); com.Parameters.AddWithValue("@FK_IDCONSULTANT", p_cra.FK_IDCONSULTANT); com.Parameters.AddWithValue("@FK_IDCLIENT", p_cra.FK_IDCLIENT); com.Parameters.AddWithValue("@LIB_CLIENT", p_cra.LIB_CLIENT); com.Parameters.AddWithValue("@FK_IDRESPONSABLE", p_cra.FK_IDRESPONSABLE); com.Parameters.AddWithValue("@LIB_RESPONSABLE", p_cra.LIB_RESPONSABLE); com.Parameters.AddWithValue("@FK_IDSTATUT", p_cra.FK_IDSTATUT); com.Parameters.AddWithValue("@SIGNECONSULTANT", p_cra.SIGNECONSULTANT); com.Parameters.AddWithValue("@DTSIGNECONSULTANT", p_cra.DTSIGNECONSULTANT); com.Parameters.AddWithValue("@SIGNECLIENTFINAL", p_cra.SIGNECLIENTFINAL); com.Parameters.AddWithValue("@DTSIGNECLIENTFINAL", p_cra.DTSIGNECLIENTFINAL); com.Parameters.AddWithValue("@SIGNEAGENT", p_cra.SIGNEAGENT); com.Parameters.AddWithValue("@DTSIGNEAGENT", p_cra.DTSIGNEAGENT); com.Parameters.AddWithValue("@AddedDate", p_cra.AddedDate); com.Parameters.AddWithValue("@ModifiedDate", p_cra.ModifiedDate); com.Parameters.AddWithValue("@IPAddress", p_cra.IPAddress); com.Parameters.AddWithValue("@Action", "insert"); i = com.ExecuteNonQuery(); } return(i); }
public JsonResult Update(CRA p_cra) { return(Json(g_cradb.Update(p_cra), JsonRequestBehavior.AllowGet)); }