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