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