public ActionResult Delete(int Code) { MOUVEMENTS_COMPTABLES Selected = BD.MOUVEMENTS_COMPTABLES.Find(Code); BD.MOUVEMENTS_COMPTABLES.Remove(Selected); BD.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult SendForm(string Mode, string Code) { string MATRICULE = Request.Params["MATRICULE"] != null ? Request.Params["MATRICULE"].ToString() : string.Empty; string employee = Request.Params["employee"] != null ? Request.Params["employee"].ToString() : string.Empty; string DATE = Request.Params["DATE"] != null ? Request.Params["DATE"].ToString() : string.Empty; string JOURNALE = Request.Params["JOURNALE"] != null ? Request.Params["JOURNALE"].ToString() : string.Empty; string NUM_PIECE = Request.Params["NUM_PIECE"] != null ? Request.Params["NUM_PIECE"].ToString() : string.Empty; string LIBELLE = Request.Params["LIBELLE"] != null ? Request.Params["LIBELLE"].ToString() : string.Empty; string MONTANT = Request.Params["MONTANT"] != null ? Request.Params["MONTANT"].ToString() : "0"; DateTime SelectedDate = DateTime.Parse(DATE); int ID = int.Parse(employee); EMPLOYEES SelectedEmployee = BD.EMPLOYEES.Find(ID); if (Mode == "Create") { MOUVEMENTS_COMPTABLES NewElement = new MOUVEMENTS_COMPTABLES(); NewElement.EMPLOYEE = ID; NewElement.EMPLOYEES = SelectedEmployee; NewElement.DATE = SelectedDate; NewElement.JOURNAL = JOURNALE; NewElement.NUM_PIECE = JOURNALE; NewElement.LIBELLE = LIBELLE; NewElement.MONTANT = decimal.Parse(MONTANT, NumberStyles.Any, CultureInfo.InvariantCulture); if (NewElement.MONTANT >= 0) { NewElement.ACTION = "DEBIT"; } if (NewElement.MONTANT < 0) { NewElement.ACTION = "CREDIT"; } BD.MOUVEMENTS_COMPTABLES.Add(NewElement); BD.SaveChanges(); } if (Mode == "Edit") { int SeletedPretID = int.Parse(Code); MOUVEMENTS_COMPTABLES NewElement = BD.MOUVEMENTS_COMPTABLES.Find(SeletedPretID); NewElement.EMPLOYEE = ID; NewElement.EMPLOYEES = SelectedEmployee; NewElement.DATE = SelectedDate; NewElement.JOURNAL = JOURNALE; NewElement.NUM_PIECE = JOURNALE; NewElement.LIBELLE = LIBELLE; NewElement.MONTANT = decimal.Parse(MONTANT, NumberStyles.Any, CultureInfo.InvariantCulture); if (NewElement.MONTANT >= 0) { NewElement.ACTION = "DEBIT"; } if (NewElement.MONTANT < 0) { NewElement.ACTION = "CREDIT"; } BD.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Form(string Mode, int Code) { MOUVEMENTS_COMPTABLES Element = new MOUVEMENTS_COMPTABLES(); if (Mode == "Create") { ViewBag.TITRE = "AJOUTER UN NOUVEAU MOUVEMENT"; Element.DATE = DateTime.Today; } if (Mode == "Edit") { Element = BD.MOUVEMENTS_COMPTABLES.Find(Code); ViewBag.TITRE = "MODIFIER UN MOUVEMENT"; } ViewBag.Mode = Mode; ViewBag.Code = Code; return(View(Element)); }
private void InsertIntoList(Stream fStream, DataTable listTable) { try { for (int iRow = 0; iRow < listTable.Rows.Count; iRow++) { string NUMERO = listTable.Rows[iRow][0] != null?Convert.ToString(listTable.Rows[iRow][0]) : ""; string SMATRICULE = listTable.Rows[iRow][1] != null?Convert.ToString(listTable.Rows[iRow][1]) : ""; string DATE = listTable.Rows[iRow][2] != null?Convert.ToString(listTable.Rows[iRow][2]) : ""; string JOURNAL = listTable.Rows[iRow][3] != null?Convert.ToString(listTable.Rows[iRow][3]) : ""; string NUM_PIECE = listTable.Rows[iRow][4] != null?Convert.ToString(listTable.Rows[iRow][4]) : ""; string LIBELLE = listTable.Rows[iRow][5] != null?Convert.ToString(listTable.Rows[iRow][5]) : ""; string DEBIT = listTable.Rows[iRow][7] != null?Convert.ToString(listTable.Rows[iRow][7]) : "0"; string CREDIT = listTable.Rows[iRow][8] != null?Convert.ToString(listTable.Rows[iRow][8]) : "0"; string MATRICULE = SMATRICULE.Substring(1); EMPLOYEES SelectedEmploye = BD.EMPLOYEES.Where(Element => Element.NUMERO == MATRICULE).FirstOrDefault(); if (SelectedEmploye == null) { SelectedEmploye = new EMPLOYEES(); SelectedEmploye.NUMERO = MATRICULE; SelectedEmploye.FULLNAME = string.Empty; if (BD.DECLARATIONS.FirstOrDefault() != null) { SelectedEmploye.SOCIETES = BD.DECLARATIONS.FirstOrDefault(); SelectedEmploye.SOCIETE = BD.DECLARATIONS.FirstOrDefault().ID; } BD.EMPLOYEES.Add(SelectedEmploye); BD.SaveChanges(); } int Num = int.Parse(NUMERO); MOUVEMENTS_COMPTABLES SelectedMouvemenet = BD.MOUVEMENTS_COMPTABLES.Where(Element => Element.NUMERO == Num).FirstOrDefault(); if (SelectedMouvemenet == null) { DateTime dateValue; if (DateTime.TryParse(DATE, out dateValue)) { decimal value; MOUVEMENTS_COMPTABLES Mouvement = new MOUVEMENTS_COMPTABLES(); Mouvement.EMPLOYEE = SelectedEmploye.ID; Mouvement.NUMERO = Num; Mouvement.EMPLOYEES = SelectedEmploye; Mouvement.DATE = DateTime.Parse(DATE); Mouvement.JOURNAL = JOURNAL; Mouvement.NUM_PIECE = NUM_PIECE; Mouvement.LIBELLE = LIBELLE; Mouvement.DATE_AFFECATION = DateTime.Parse(DATE); if (JOURNAL == "A.N") { DateTime AnneeP = DateTime.Parse(DATE).AddYears(-1); Mouvement.DATE_AFFECATION = new DateTime(AnneeP.Year, 12, 31); } if (decimal.TryParse(DEBIT, NumberStyles.Any, CultureInfo.InvariantCulture, out value)) { decimal debit = decimal.Parse(DEBIT); Mouvement.MONTANT = debit; Mouvement.ACTION = "DEBIT"; BD.SaveChanges(); } if (decimal.TryParse(CREDIT, NumberStyles.Any, CultureInfo.InvariantCulture, out value)) { decimal credit = decimal.Parse(CREDIT); Mouvement.MONTANT = -credit; Mouvement.ACTION = "CREDIT"; BD.SaveChanges(); } BD.MOUVEMENTS_COMPTABLES.Add(Mouvement); } } } } catch (Exception) { } finally { }; }