public ActionResult SendFormSociete(string Mode, string Code)
{
ViewBag.MODE = Mode;
string SOCIETE = Request.Params["SOCIETE"] != null ? Request.Params["SOCIETE"].ToString() : string.Empty;
string MATRICULE = Request.Params["MATRICULE"] != null ? Request.Params["MATRICULE"].ToString() : string.Empty;
string ADRESSE = string.Empty;
string MATRICULE_FISCAL = Request.Params["MATRICULE_FISCAL"] != null ? Request.Params["MATRICULE_FISCAL"].ToString() : string.Empty;
string CODE_EXPLOITATION = Request.Params["CODE_EXPLOITATION"] != null ? Request.Params["CODE_EXPLOITATION"].ToString() : string.Empty;
string BR = Request.Params["BR"] != null ? Request.Params["BR"].ToString() : string.Empty;
string VILLE = Request.Params["VILLE"] != null ? Request.Params["VILLE"].ToString() : string.Empty;
string RUE = Request.Params["RUE"] != null ? Request.Params["RUE"].ToString() : string.Empty;
string NUMERO = Request.Params["NUMERO"] != null ? Request.Params["NUMERO"].ToString() : string.Empty;
string CODE_POSTAL = Request.Params["CODE_POSTAL"] != null ? Request.Params["CODE_POSTAL"].ToString() : string.Empty;
string ACTIVITE = Request.Params["ACTIVITE"] != null ? Request.Params["ACTIVITE"].ToString() : string.Empty;
MATRICULE_FISCAL = MATRICULE_FISCAL.Replace("-", "");
ADRESSE = VILLE + " " + RUE + " " + NUMERO + " " + CODE_POSTAL;
if (Mode == "Create")
{
DECLARATIONS SOC = new DECLARATIONS();
SOC.SOCIETE = SOCIETE;
SOC.CODE = MATRICULE;
SOC.MATRICULE = MATRICULE_FISCAL;
SOC.CODE_EXPLOITATION = CODE_EXPLOITATION;
SOC.ADRESSE = ADRESSE;
SOC.BR = BR;
SOC.ACTIVITE = ACTIVITE;
SOC.VILLE = VILLE;
SOC.RUE = RUE;
SOC.NUMERO = NUMERO;
SOC.CODE_POSTAL = CODE_POSTAL;
BD.DECLARATIONS.Add(SOC);
BD.SaveChanges();
}
if (Mode == "Edit")
{
int ID = int.Parse(Code);
DECLARATIONS SOC = BD.DECLARATIONS.Where(soc => soc.ID == ID).FirstOrDefault();
SOC.SOCIETE = SOCIETE;
SOC.CODE = MATRICULE;
SOC.MATRICULE = MATRICULE_FISCAL;
SOC.CODE_EXPLOITATION = CODE_EXPLOITATION;
SOC.ADRESSE = ADRESSE;
SOC.BR = BR;
SOC.ACTIVITE = ACTIVITE;
SOC.VILLE = VILLE;
SOC.RUE = RUE;
SOC.NUMERO = NUMERO;
SOC.CODE_POSTAL = CODE_POSTAL;
BD.SaveChanges();
}
return(RedirectToAction("Societes"));
}
public ActionResult FormSociete(string Mode, string Code)
{
DECLARATIONS Societe = new DECLARATIONS();
if (Mode == "Create")
{
ViewBag.Type = "Nouvelle Société";
}
if (Mode == "Edit")
{
ViewBag.Type = "Modifier une Société";
int ID = int.Parse(Code);
Societe = BD.DECLARATIONS.Where(Soc => Soc.ID == ID).FirstOrDefault();
}
ViewBag.Code = Code;
ViewBag.Mode = Mode;
return(View(Societe));
}
public ActionResult SendForm(string Mode, string Code)
{
string TRIMESTRE = Request.Params["TRIMESTRE"] != null ? Request.Params["TRIMESTRE"].ToString() : string.Empty;
string ANNEE = Request.Params["ANNEE"] != null ? Request.Params["ANNEE"].ToString() : string.Empty;
string SOCIETE = Request.Params["SOCIETE"] != null ? Request.Params["SOCIETE"].ToString() : string.Empty;
Session["TRIMESTRE"] = TRIMESTRE;
Session["ANNEE"] = ANNEE;
Session["SOCIETE"] = SOCIETE;
int SelectedSociete = int.Parse(SOCIETE);
DECLARATIONS Soc = BD.DECLARATIONS.Find(SelectedSociete);
if (string.IsNullOrEmpty(Soc.MATRICULE))
{
ViewBag.ErrorText = "Matricule fiscale inexistante";
TempData["ErrorText"] = "Matricule fiscale inexistante";
return(RedirectToAction("Form", "DeclarationBCD", new { @Mode = Mode, @Code = Code }));
}
else
{
return(RedirectToAction("Second", "DeclarationBCD", new { @Mode = Mode, @Code = Code, @ANNEE = ANNEE, @SOCIETE = SOCIETE, @TRIMESTRE = TRIMESTRE }));
}
}
public FileResult Upload()
{
FileInfo info = new FileInfo("Fichier vide.TXT");
string trimestre = Request.Params["TRIMESTRE"] != null ? Request.Params["TRIMESTRE"].ToString() : string.Empty;
string annee = Request.Params["ANNEE"] != null ? Request.Params["ANNEE"].ToString() : string.Empty;
string societe = Request.Params["SOCIETE"] != null ? Request.Params["SOCIETE"].ToString() : string.Empty;
string WithSave = Request["WithSave"] != null ? Request["WithSave"].ToString() : "false";
if (string.IsNullOrEmpty(WithSave))
{
WithSave = "false";
}
Boolean Save = Boolean.Parse(WithSave);
int ID = int.Parse(societe);
int TRIMESTRE = int.Parse(trimestre);
int ANNEE = int.Parse(annee);
DECLARATIONS SelectedSociete = BD.DECLARATIONS.Where(Soc => Soc.ID == ID).FirstOrDefault();
societe = SelectedSociete.CODE;
var nom = "DS" + societe + "0000." + trimestre + annee + ".TXT";
GENERATIONS NouvelleGeneration = new GENERATIONS();
if (Save)
{
NouvelleGeneration.ANNEE = ANNEE;
NouvelleGeneration.CODE = "DS" + societe + "0000." + trimestre + annee;
NouvelleGeneration.DATE = DateTime.Today;
NouvelleGeneration.DECLARATIONS = SelectedSociete;
NouvelleGeneration.SOCIETE = ID;
NouvelleGeneration.TRIMESTRE = TRIMESTRE;
BD.GENERATIONS.Add(NouvelleGeneration);
BD.SaveChanges();
}
if (Request.Files.Count > 0)
{
HttpPostedFileBase fichierExcel = Request.Files["FileUploadExcel"];
var file = Request.Files[0];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
//var path = Path.Combine(Server.MapPath("~/Images/"), nom + ".TXT");
var path = Path.Combine(Server.MapPath("~/Images/"), fileName);
file.SaveAs(path);
var fileContents = System.IO.File.ReadAllText(Server.MapPath(@"~/Images/" + fileName));
string[] lignes = fileContents.Split('\n');
info = new FileInfo(Server.MapPath(@"~/Images/" + nom));
var fileStream = System.IO.File.Open(Server.MapPath(@"~/Images/" + nom), FileMode.OpenOrCreate, FileAccess.ReadWrite);
fileStream.Close();
//using (var fileStream = System.IO.File.Open(Server.MapPath(@"~/Images/" + nom), FileMode.OpenOrCreate, FileAccess.ReadWrite))
//{
using (StreamWriter writer = info.CreateText())
{
int LineNumber = 0;
int FileNumber = 1;
for (int i = 0; i < lignes.Count() - 1; i++)
{
if (LineNumber == 12)
{
LineNumber = 1;
FileNumber++;
}
else
{
LineNumber++;
}
string NumAssureSociel = lignes[i].Substring(10, 10);
string IdentiteAssuree = lignes[i].Substring(20, 60);
string Cin = lignes[i].Substring(80, 8);
string Salaire = lignes[i].Substring(lignes[i].Length - 11, 10);
Salaire = Salaire.Replace(",", "");
Salaire = Salaire.Replace(" ", "0");
while (Salaire.Length < 10)
{
Salaire = "0" + Salaire;
}
writer.WriteLine(societe + "0000" + trimestre + annee + FileNumber.ToString("000") + LineNumber.ToString("00") + NumAssureSociel + IdentiteAssuree + Cin + Salaire + "0000000000");
string SalaireMois1 = lignes[i].Substring(91, 12);
string SalaireMois2 = lignes[i].Substring(103, 12);
string SalaireMois3 = lignes[i].Substring(115, 12);
SalaireMois1 = SalaireMois1.Trim();
SalaireMois2 = SalaireMois2.Trim();
SalaireMois3 = SalaireMois3.Trim();
if (Save)
{
EMPLOYEES Employee = BD.EMPLOYEES.Where(Emp => Emp.CIN == Cin).FirstOrDefault();
if (Employee != null)
{
LIGNES_GENERATIONS NouvelleLigne = new LIGNES_GENERATIONS();
NouvelleLigne.EMPLOYEE = Employee.ID;
NouvelleLigne.EMPLOYEES = Employee;
NouvelleLigne.GENERATION = NouvelleGeneration.ID;
NouvelleLigne.GENERATIONS = NouvelleGeneration;
NouvelleLigne.SALAIRE_MOIS_1 = double.Parse(SalaireMois1);
NouvelleLigne.SALAIRE_MOIS_2 = double.Parse(SalaireMois2);
NouvelleLigne.SALAIRE_MOIS_3 = double.Parse(SalaireMois3);
BD.LIGNES_GENERATIONS.Add(NouvelleLigne);
BD.SaveChanges();
}
else
{
EMPLOYEES NouveauEmployee = new EMPLOYEES();
NouveauEmployee.FULLNAME = IdentiteAssuree.TrimEnd();
NouveauEmployee.CIN = Cin;
NouveauEmployee.ACTIF = true;
NumAssureSociel = NumAssureSociel.Insert(8, "-");
NouveauEmployee.NUM_ASS_SOC = NumAssureSociel;
NouveauEmployee.SOCIETE = ID;
NouveauEmployee.SOCIETES = SelectedSociete;
BD.EMPLOYEES.Add(NouveauEmployee);
BD.SaveChanges();
LIGNES_GENERATIONS NouvelleLigne = new LIGNES_GENERATIONS();
NouvelleLigne.EMPLOYEE = NouveauEmployee.ID;
NouvelleLigne.EMPLOYEES = NouveauEmployee;
NouvelleLigne.GENERATION = NouvelleGeneration.ID;
NouvelleLigne.GENERATIONS = NouvelleGeneration;
NouvelleLigne.SALAIRE_MOIS_1 = double.Parse(SalaireMois1);
NouvelleLigne.SALAIRE_MOIS_2 = double.Parse(SalaireMois2);
NouvelleLigne.SALAIRE_MOIS_3 = double.Parse(SalaireMois3);
BD.LIGNES_GENERATIONS.Add(NouvelleLigne);
BD.SaveChanges();
}
}
}
}
// }
}
if (fichierExcel != null && fichierExcel.ContentLength > 0)
{
string path = Path.Combine(Server.MapPath("~/Images/"), fichierExcel.FileName);
fichierExcel.SaveAs(path);
info = new FileInfo(Server.MapPath(@"~/Images/" + nom));
Uploadfile(fichierExcel.InputStream, path, societe, trimestre, annee);
var fileStream = System.IO.File.Open(Server.MapPath(@"~/Images/" + nom), FileMode.OpenOrCreate, FileAccess.ReadWrite);
fileStream.Close();
//using (var fileStream = System.IO.File.Open(Server.MapPath(@"~/Images/" + nom), FileMode.OpenOrCreate, FileAccess.ReadWrite))
//{
using (StreamWriter writer = info.CreateText())
{
foreach (CnssInfo cnss in Liste)
{
writer.WriteLine(societe + "0000" + trimestre + annee + cnss.page.ToString("000") + cnss.Line.ToString("00") + cnss.NumSoc + cnss.FullName + cnss.Cin + cnss.Salaire + "0000000000");
}
}
//}
}
if (file.ContentLength <= 0 && fichierExcel.ContentLength <= 0)
{
var fileStream = System.IO.File.Open(Server.MapPath(@"~/Images/" + nom), FileMode.OpenOrCreate, FileAccess.ReadWrite);
fileStream.Close();
info = new FileInfo(Server.MapPath(@"~/Images/" + nom));
List <EMPLOYEES> Liste = BD.EMPLOYEES.Where(Emp => Emp.SOCIETES.ID == ID && Emp.ACTIF == true).ToList();
using (StreamWriter writer = info.CreateText())
{
int LineNumber = 0;
int FileNumber = 1;
foreach (EMPLOYEES Employee in Liste)
{
double SalaireMois1 = 0;
double SalaireMois2 = 0;
double SalaireMois3 = 0;
List <SAISIES> ListeSaisie = BD.SAISIES.Where(Saisie => Saisie.EMPLOYEES.ID == Employee.ID && Saisie.ANNEE == ANNEE && Saisie.TRIMESTRE == TRIMESTRE).ToList();
if (ListeSaisie.Count == 1)
{
SalaireMois1 = (double)ListeSaisie.ElementAt(0).SALAIRE;
}
if (ListeSaisie.Count == 2)
{
SalaireMois1 = (double)ListeSaisie.ElementAt(0).SALAIRE;
SalaireMois2 = (double)ListeSaisie.ElementAt(1).SALAIRE;
}
if (ListeSaisie.Count == 3)
{
SalaireMois1 = (double)ListeSaisie.ElementAt(0).SALAIRE;
SalaireMois2 = (double)ListeSaisie.ElementAt(1).SALAIRE;
SalaireMois3 = (double)ListeSaisie.ElementAt(2).SALAIRE;
}
double Salaire = 0;
foreach (SAISIES UneSaisie in ListeSaisie)
{
Salaire += (double)UneSaisie.SALAIRE;
}
if (LineNumber == 12)
{
LineNumber = 1;
FileNumber++;
}
else
{
LineNumber++;
}
string fullname = Employee.FULLNAME;
while (fullname.Length < 60)
{
fullname += " ";
}
string SalaireString = Salaire.ToString("F3");
SalaireString = SalaireString.Replace(",", "");
SalaireString = SalaireString.Replace(" ", "0");
while (SalaireString.Length < 10)
{
SalaireString = "0" + SalaireString;
}
writer.WriteLine(societe + "0000" + trimestre + annee + FileNumber.ToString("000") + LineNumber.ToString("00") + Employee.NUM_ASS_SOC.Replace("-", "") + fullname + Employee.CIN + SalaireString + "0000000000");
if (Save)
{
EMPLOYEES Employeee = BD.EMPLOYEES.Where(Emp => Emp.CIN == Employee.CIN).FirstOrDefault();
if (Employeee != null)
{
LIGNES_GENERATIONS NouvelleLigne = new LIGNES_GENERATIONS();
NouvelleLigne.EMPLOYEE = Employeee.ID;
NouvelleLigne.EMPLOYEES = Employeee;
NouvelleLigne.GENERATION = NouvelleGeneration.ID;
NouvelleLigne.GENERATIONS = NouvelleGeneration;
NouvelleLigne.SALAIRE_MOIS_1 = (double)SalaireMois1;
NouvelleLigne.SALAIRE_MOIS_2 = (double)SalaireMois2;
NouvelleLigne.SALAIRE_MOIS_3 = (double)SalaireMois3;
BD.LIGNES_GENERATIONS.Add(NouvelleLigne);
BD.SaveChanges();
}
}
}
}
}
}
byte[] fileBytes = System.IO.File.ReadAllBytes(Server.MapPath(@"~/Images/" + nom));
NouvelleGeneration.DATA = fileBytes;
BD.SaveChanges();
return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, nom));
}
public ActionResult SendFormEmployee(string Mode, string Code, string Filter)
{
string CIN = Request.Params["CIN"] != null ? Request.Params["CIN"].ToString() : string.Empty;
string FULLNAME = Request.Params["FULLNAME"] != null ? Request.Params["FULLNAME"].ToString() : string.Empty;
string NUM_ASS_SOC = Request.Params["NUM_ASS_SOC"] != null ? Request.Params["NUM_ASS_SOC"].ToString() : string.Empty;
string ACTIF = Request.Params["ACTIF"] != null ? "true" : "false";
string QUALIFICATION = Request.Params["QUALIFICATION"] != null ? Request.Params["QUALIFICATION"].ToString() : string.Empty;
string NUMERO = Request.Params["NUMERO"] != null ? Request.Params["NUMERO"].ToString() : string.Empty;
string DATE = Request.Params["DATE"] != null ? Request.Params["DATE"].ToString() : string.Empty;
string SALAIRE = Request.Params["SALAIRE"] != null ? Request.Params["SALAIRE"].ToString() : string.Empty;
string CIVILITE = Request.Params["CIVILITE"] != null ? Request.Params["CIVILITE"].ToString() : string.Empty;
Boolean Etat = Boolean.Parse(ACTIF);
if (Mode == "Create")
{
EMPLOYEES Employee = new EMPLOYEES();
Employee.CIN = CIN.Trim();
Employee.FULLNAME = FULLNAME;
Employee.NUM_ASS_SOC = NUM_ASS_SOC;
Employee.SOCIETE = int.Parse(Filter);
int ID = int.Parse(Filter);
DECLARATIONS SOCIETE = BD.DECLARATIONS.Where(Soc => Soc.ID == ID).FirstOrDefault();
Employee.SOCIETES = SOCIETE;
Employee.ACTIF = Etat;
Employee.NUMERO = NUMERO;
Employee.QUALIFICATION = QUALIFICATION;
Employee.DEMARRAGE = DateTime.Parse(DATE);
Employee.CIVILITE = CIVILITE;
Employee.SALAIRE = 0;
decimal value;
if (decimal.TryParse(SALAIRE, NumberStyles.Any, CultureInfo.InvariantCulture, out value))
{
Employee.SALAIRE = decimal.Parse(SALAIRE, CultureInfo.InvariantCulture);
}
BD.EMPLOYEES.Add(Employee);
BD.SaveChanges();
}
if (Mode == "Edit")
{
int ID = int.Parse(Code);
EMPLOYEES Employee = BD.EMPLOYEES.Where(Emp => Emp.ID == ID).FirstOrDefault();
Employee.CIN = CIN.Trim();
Employee.FULLNAME = FULLNAME;
Employee.NUM_ASS_SOC = NUM_ASS_SOC;
Employee.ACTIF = Etat;
Employee.NUMERO = NUMERO;
Employee.QUALIFICATION = QUALIFICATION;
Employee.DEMARRAGE = DateTime.Parse(DATE);
Employee.CIVILITE = CIVILITE;
Employee.SALAIRE = 0;
decimal value;
if (decimal.TryParse(SALAIRE, NumberStyles.Any, CultureInfo.InvariantCulture, out value))
{
Employee.SALAIRE = decimal.Parse(SALAIRE, CultureInfo.InvariantCulture);
}
BD.SaveChanges();
}
return(RedirectToAction("Employee", "CNSS", new { @Code = Filter }));
}
private void InsertIntoList(Stream fStream, DataTable listTable, string Filter)
{
try
{
for (int iRow = 0; iRow < listTable.Rows.Count; iRow++)
{
string MATRICULE = listTable.Rows[iRow][0] != null?Convert.ToString(listTable.Rows[iRow][0]) : "";
string SALAIRE = listTable.Rows[iRow][2] != null?Convert.ToString(listTable.Rows[iRow][2]) : "";
string NOM = listTable.Rows[iRow][3] != null?Convert.ToString(listTable.Rows[iRow][3]) : "";
string PRENOM = listTable.Rows[iRow][4] != null?Convert.ToString(listTable.Rows[iRow][4]) : "";
string CIN = listTable.Rows[iRow][5] != null?Convert.ToString(listTable.Rows[iRow][5]) : "";
string QUALIFICATION = listTable.Rows[iRow][6] != null?Convert.ToString(listTable.Rows[iRow][6]) : "";
string DATE = listTable.Rows[iRow][7] != null?Convert.ToString(listTable.Rows[iRow][7]) : "";
EMPLOYEES SelectedEmploye = BD.EMPLOYEES.Where(Element => Element.NUMERO == MATRICULE).FirstOrDefault();
DateTime date;
while (CIN.Length < 8)
{
CIN = "0" + CIN;
}
if (SelectedEmploye == null)
{
SelectedEmploye = new EMPLOYEES();
SelectedEmploye.NUMERO = MATRICULE;
SelectedEmploye.FULLNAME = PRENOM + " " + NOM;
SelectedEmploye.CIN = CIN;
SelectedEmploye.QUALIFICATION = QUALIFICATION;
SelectedEmploye.SALAIRE = 0;
decimal value;
if (decimal.TryParse(SALAIRE, NumberStyles.Any, CultureInfo.InvariantCulture, out value))
{
SelectedEmploye.SALAIRE = decimal.Parse(SALAIRE);
}
SelectedEmploye.SOCIETE = int.Parse(Filter);
int ID = int.Parse(Filter);
DECLARATIONS SOCIETE = BD.DECLARATIONS.Where(Soc => Soc.ID == ID).FirstOrDefault();
SelectedEmploye.SOCIETES = SOCIETE;
SelectedEmploye.ACTIF = true;
if (DateTime.TryParse(DATE, out date))
{
SelectedEmploye.DEMARRAGE = DateTime.Parse(DATE);
}
BD.EMPLOYEES.Add(SelectedEmploye);
BD.SaveChanges();
}
else
{
SelectedEmploye.NUMERO = MATRICULE;
SelectedEmploye.FULLNAME = PRENOM + " " + NOM;
SelectedEmploye.CIN = CIN;
SelectedEmploye.QUALIFICATION = QUALIFICATION;
SelectedEmploye.SALAIRE = 0;
decimal value;
if (decimal.TryParse(SALAIRE, NumberStyles.Any, CultureInfo.InvariantCulture, out value))
{
SelectedEmploye.SALAIRE = decimal.Parse(SALAIRE);
}
SelectedEmploye.SOCIETE = int.Parse(Filter);
int ID = int.Parse(Filter);
DECLARATIONS SOCIETE = BD.DECLARATIONS.Where(Soc => Soc.ID == ID).FirstOrDefault();
SelectedEmploye.SOCIETES = SOCIETE;
SelectedEmploye.ACTIF = true;
if (DateTime.TryParse(DATE, out date))
{
SelectedEmploye.DEMARRAGE = DateTime.Parse(DATE);
}
BD.SaveChanges();
}
}
}
catch (Exception)
{
}
finally
{
};
}
public ActionResult SendSecondForm(string Mode, string Code)
{
string ANNEE = Session["ANNEE"] != null ? Session["ANNEE"].ToString() : string.Empty;
string SOCIETE = Session["SOCIETE"] != null ? Session["SOCIETE"].ToString() : string.Empty;
string TRIMESTRE = Session["TRIMESTRE"] != null ? Session["TRIMESTRE"].ToString() : string.Empty;
List <LIGNES_DECLARATIONS_FACTURES> Liste = new List <LIGNES_DECLARATIONS_FACTURES>();
if (Session["LignesFacture"] != null)
{
Liste = (List <LIGNES_DECLARATIONS_FACTURES>)Session["LignesFacture"];
}
string NUMERO_BC = Request.Params["NUMERO_BC"] != null ? Request.Params["NUMERO_BC"].ToString() : string.Empty;
string DATE_BC = Request.Params["DATE_BC"] != null ? Request.Params["DATE_BC"].ToString() : string.Empty;
string MATRICULE = Request.Params["MATRICULE"] != null ? Request.Params["MATRICULE"].ToString() : string.Empty;
string fournisseur = Request.Params["fournisseur"] != null ? Request.Params["fournisseur"].ToString() : string.Empty;
string NUMERO_FACTURE = Request.Params["NUMERO_FACTURE"] != null ? Request.Params["NUMERO_FACTURE"].ToString() : string.Empty;
string DATE_FACTURE = Request.Params["DATE_FACTURE"] != null ? Request.Params["DATE_FACTURE"].ToString() : string.Empty;
string PRIX_HT = Request.Params["PRIX_HT"] != null ? Request.Params["PRIX_HT"].ToString() : string.Empty;
string TVA = Request.Params["TVA"] != null ? Request.Params["TVA"].ToString() : string.Empty;
string OBJET = Request.Params["OBJET"] != null ? Request.Params["OBJET"].ToString() : string.Empty;
string NUMERO_AUTORISATION = Request.Params["NUMERO_AUTORISATION"] != null ? Request.Params["NUMERO_AUTORISATION"].ToString() : string.Empty;
string ACTION = Request.Params["ACTION"] != null ? Request.Params["ACTION"].ToString() : string.Empty;
if (ACTION == "BACK")
{
return(RedirectToAction("Form", "DeclarationBCD", new { @Mode = "Edit", @Code = -1 }));
}
if (ACTION == "PRINT")
{
}
if (ACTION == "VALIDATE")
{
DECLARATIONS_FACTURES NouvelleDeclaration = new DECLARATIONS_FACTURES();
GestionCommercialeEntity BD_A = new GestionCommercialeEntity();
GestionCommercialeEntity BD_B = new GestionCommercialeEntity();
int IdSociete = int.Parse(SOCIETE);
DECLARATIONS SelectedSociete = BD.DECLARATIONS.Find(IdSociete);
NouvelleDeclaration.ANNEE = int.Parse(ANNEE);
NouvelleDeclaration.CODE = "BCD_T" + TRIMESTRE + "_" + ANNEE.Substring(2);
NouvelleDeclaration.DATE = DateTime.Today;
NouvelleDeclaration.TRIMESTRE = int.Parse(TRIMESTRE);
NouvelleDeclaration.DECLARATIONS = SelectedSociete;
NouvelleDeclaration.SOCIETE = IdSociete;
NouvelleDeclaration.VALIDE = true;
BD.DECLARATIONS_FACTURES.Add(NouvelleDeclaration);
BD.SaveChanges();
foreach (LIGNES_DECLARATIONS_FACTURES Ligne in Liste)
{
LIGNES_DECLARATIONS_FACTURES NouvelleLigne = new LIGNES_DECLARATIONS_FACTURES();
NouvelleLigne.DATE_BC = Ligne.DATE_BC;
NouvelleLigne.DATE_FACTURE = Ligne.DATE_FACTURE;
NouvelleLigne.DECLARATION_FACTURE = NouvelleDeclaration.ID;
NouvelleLigne.DECLARATIONS_FACTURES = NouvelleDeclaration;
NouvelleLigne.MONTANT_TVA = Ligne.MONTANT_TVA;
NouvelleLigne.NUMERO_AUTORISATION = Ligne.NUMERO_AUTORISATION;
NouvelleLigne.NUMERO_BC = Ligne.NUMERO_BC;
NouvelleLigne.NUMERO_FACTURE = Ligne.NUMERO_FACTURE;
NouvelleLigne.NUMERO_ORDRE = Ligne.NUMERO_ORDRE;
NouvelleLigne.OBJET = Ligne.OBJET;
NouvelleLigne.PRIX_HT = Ligne.PRIX_HT;
NouvelleLigne.TVA = Ligne.TVA;
FOURNISSEURS Four = Ligne.FOURNISSEURS;
NouvelleLigne.FOURNISSEUR = Four.ID;
//NouvelleLigne.FOURNISSEURS = Four;
BD.LIGNES_DECLARATIONS_FACTURES.Add(NouvelleLigne);
BD.SaveChanges();
}
#region SaveFile
FileInfo info = new FileInfo("Fichier vide.TXT");
string nom = "BCD_T" + TRIMESTRE + "_" + ANNEE.Substring(2);
var fileStream = System.IO.File.Open(Server.MapPath(@"~/Images/" + nom), FileMode.OpenOrCreate, FileAccess.ReadWrite);
fileStream.Close();
info = new FileInfo(Server.MapPath(@"~/Images/" + nom));
using (StreamWriter writer = info.CreateText())
{
string EF01 = SelectedSociete.MATRICULE;
string EF05 = ANNEE;
string EF06 = "T" + TRIMESTRE;
string EF07 = SelectedSociete.SOCIETE != null ? SelectedSociete.SOCIETE : string.Empty;;
string EF08 = SelectedSociete.ACTIVITE != null ? SelectedSociete.ACTIVITE : string.Empty;
string EF09 = SelectedSociete.VILLE != null ? SelectedSociete.VILLE : string.Empty;
string EF10 = SelectedSociete.RUE != null ? SelectedSociete.RUE : string.Empty;
string EF11 = SelectedSociete.NUMERO != null ? SelectedSociete.NUMERO : string.Empty;
string EF12 = SelectedSociete.CODE_POSTAL != null ? SelectedSociete.CODE_POSTAL : string.Empty;
while (EF07.Length < 40)
{
EF07 = EF07 + " ";
}
while (EF08.Length < 40)
{
EF08 = EF08 + " ";
}
while (EF09.Length < 40)
{
EF09 = EF09 + " ";
}
while (EF10.Length < 72)
{
EF10 = EF10 + " ";
}
while (EF11.Length < 4)
{
EF11 = EF11 + " ";
}
while (EF12.Length < 4)
{
EF12 = EF12 + " ";
}
string FirstLine = "EF" + EF01 + EF05 + EF06 + EF07 + EF08 + EF09 + EF10 + EF11 + EF12;
writer.WriteLine(FirstLine);
List <LIGNES_DECLARATIONS_FACTURES> NouvelleListe = BD.LIGNES_DECLARATIONS_FACTURES.Where(Element => Element.DECLARATIONS_FACTURES.ID == NouvelleDeclaration.ID).ToList();
decimal SumTotal = 0;
decimal SumTva = 0;
int NumeroOrdre = 1;
foreach (LIGNES_DECLARATIONS_FACTURES Ligne in NouvelleListe)
{
FOURNISSEURS SelectedFournisseur = BD.FOURNISSEURS.Find(Ligne.FOURNISSEUR);
string DF07 = NumeroOrdre.ToString("000000"); //6
string DF08 = Ligne.NUMERO_AUTORISATION; //30
string DF09 = Ligne.NUMERO_BC; //13
string DF10 = Ligne.DATE_BC.ToShortDateString().Replace("/", ""); //8
string DF11 = SelectedFournisseur.ID_FISCAL != null ? SelectedFournisseur.ID_FISCAL : string.Empty; //13
string DF12 = SelectedFournisseur.NOM != null ? SelectedFournisseur.NOM : string.Empty; //40
string DF13 = Ligne.NUMERO_FACTURE; //30
string DF14 = Ligne.DATE_FACTURE.ToShortDateString().Replace("/", "");
SumTotal += Ligne.PRIX_HT;
string DF15 = Ligne.PRIX_HT.ToString("F3").Replace(",", "");
SumTva += Ligne.MONTANT_TVA;
string DF16 = Ligne.MONTANT_TVA.ToString("F3").Replace(",", "");
string DF18 = Ligne.OBJET;
while (DF08.Length < 30)
{
DF08 = DF08 + " ";
}
while (DF09.Length < 13)
{
DF09 = "0" + DF09;
}
while (DF11.Length < 13)
{
DF11 = DF11 + " ";
}
while (DF12.Length < 40)
{
DF12 = DF12 + " ";
}
while (DF13.Length < 30)
{
DF13 = DF13 + " ";
}
while (DF15.Length < 15)
{
DF15 = "0" + DF15;
}
while (DF16.Length < 15)
{
DF16 = "0" + DF16;
}
while (DF18.Length < 320)
{
DF18 = DF18 + " ";
}
string SubLine = "DF" + EF01 + EF05 + EF06 + DF07 + DF08 + DF09 + DF10 + DF11 + DF12 + DF13 + DF14 + DF15 + DF16 + "<" + DF18 + "/>";
writer.WriteLine(SubLine);
NumeroOrdre++;
}
string TF007 = NouvelleListe.Count.ToString("000000");
string TF08 = string.Empty;
while (TF08.Length < 142)
{
TF08 = TF08 + " ";
}
string TF09 = SumTotal.ToString("F3").Replace(",", "");
string TF10 = SumTva.ToString("F3").Replace(",", "");
while (TF09.Length < 15)
{
TF09 = "0" + TF09;
}
while (TF10.Length < 15)
{
TF10 = "0" + TF10;
}
string LastLine = "TF" + EF01 + EF05 + EF06 + TF007 + TF08 + TF09 + TF10;
writer.WriteLine(LastLine);
}
byte[] fileBytes = System.IO.File.ReadAllBytes(Server.MapPath(@"~/Images/" + nom));
NouvelleDeclaration.DATA = fileBytes;
BD.SaveChanges();
#endregion
Session.Clear();
return(RedirectToAction("Index"));
}
if (ACTION == "ADD")
{
LIGNES_DECLARATIONS_FACTURES Ligne = new LIGNES_DECLARATIONS_FACTURES();
if (Mode == "Create")
{
Ligne.NUMERO_ORDRE = Liste.Count + 1;
Ligne.NUMERO_BC = NUMERO_BC;
Ligne.DATE_BC = DateTime.Parse(DATE_BC);
int ID_FOURNISSEUR = int.Parse(fournisseur);
FOURNISSEURS SelectedFournisseur = BD.FOURNISSEURS.Find(ID_FOURNISSEUR);
Ligne.FOURNISSEUR = ID_FOURNISSEUR;
Ligne.FOURNISSEURS = SelectedFournisseur;
Ligne.DATE_FACTURE = DateTime.Parse(DATE_FACTURE);
Ligne.NUMERO_FACTURE = NUMERO_FACTURE;
if (PRIX_HT.Contains(','))
{
Ligne.PRIX_HT = decimal.Parse(PRIX_HT);
}
else
{
Ligne.PRIX_HT = decimal.Parse(PRIX_HT, CultureInfo.InvariantCulture);
}
Ligne.TVA = int.Parse(TVA);
Ligne.MONTANT_TVA = (Ligne.PRIX_HT * int.Parse(TVA)) / 100;
Ligne.NUMERO_AUTORISATION = NUMERO_AUTORISATION;
Ligne.OBJET = OBJET;
Liste.Add(Ligne);
}
if (Mode == "Edit")
{
int SelectedRow = int.Parse(Code);
Ligne = Liste.Where(Element => Element.NUMERO_ORDRE == SelectedRow).FirstOrDefault();
//Ligne.NUMERO_ORDRE = Liste.Count + 1;
Ligne.NUMERO_BC = NUMERO_BC;
Ligne.DATE_BC = DateTime.Parse(DATE_BC);
int ID_FOURNISSEUR = int.Parse(fournisseur);
FOURNISSEURS SelectedFournisseur = BD.FOURNISSEURS.Find(ID_FOURNISSEUR);
Ligne.FOURNISSEUR = ID_FOURNISSEUR;
Ligne.FOURNISSEURS = SelectedFournisseur;
Ligne.DATE_FACTURE = DateTime.Parse(DATE_FACTURE);
Ligne.NUMERO_FACTURE = NUMERO_FACTURE;
if (PRIX_HT.Contains(','))
{
Ligne.PRIX_HT = decimal.Parse(PRIX_HT);
}
else
{
Ligne.PRIX_HT = decimal.Parse(PRIX_HT, CultureInfo.InvariantCulture);
}
Ligne.TVA = int.Parse(TVA);
Ligne.MONTANT_TVA = (Ligne.PRIX_HT * int.Parse(TVA)) / 100;
Ligne.NUMERO_AUTORISATION = NUMERO_AUTORISATION;
Ligne.OBJET = OBJET;
}
}
if (ACTION == "DELETE")
{
LIGNES_DECLARATIONS_FACTURES Ligne = new LIGNES_DECLARATIONS_FACTURES();
int SelectedRow = int.Parse(Code);
Ligne = Liste.Where(Element => Element.NUMERO_ORDRE == SelectedRow).FirstOrDefault();
Liste.Remove(Ligne);
for (int i = 0; i < Liste.Count; i++)
{
Liste.ElementAt(i).NUMERO_ORDRE = i + 1;
}
}
Session["LignesFacture"] = Liste;
return(RedirectToAction("Second", "DeclarationBCD", new { @Mode = "Create", @Code = "-1", @ANNEE = ANNEE, @SOCIETE = SOCIETE, @TRIMESTRE = TRIMESTRE }));
}
public ActionResult SendSecondForm(string Mode, string Code)
{
string ANNEE = Session["ANNEE_FAC"] != null ? Session["ANNEE_FAC"].ToString() : string.Empty;
string SOCIETE = Session["SOCIETE_FAC"] != null ? Session["SOCIETE_FAC"].ToString() : string.Empty;
string TRIMESTRE = Session["TRIMESTRE_FAC"] != null ? Session["TRIMESTRE_FAC"].ToString() : string.Empty;
List <LIGNES_DECLARATIONS_FACS> Liste = new List <LIGNES_DECLARATIONS_FACS>();
if (Session["LignesFacture_FAC"] != null)
{
Liste = (List <LIGNES_DECLARATIONS_FACS>)Session["LignesFacture_FAC"];
}
string NUMERO_FACTURE = Request.Params["NUMERO_FACTURE"] != null ? Request.Params["NUMERO_FACTURE"].ToString() : string.Empty;
string DATE_FACTURE = Request.Params["DATE_FACTURE"] != null ? Request.Params["DATE_FACTURE"].ToString() : string.Empty;
string MATRICULE = Request.Params["MATRICULE"] != null ? Request.Params["MATRICULE"].ToString() : string.Empty;
string client = Request.Params["client"] != null ? Request.Params["client"].ToString() : string.Empty;
string TYPE_CLIENT = Request.Params["TYPE_CLIENT"] != null ? Request.Params["TYPE_CLIENT"].ToString() : string.Empty;
string PRIX_HT = Request.Params["PRIX_HT"] != null ? Request.Params["PRIX_HT"].ToString() : string.Empty;
string TVA = Request.Params["TVA"] != null ? Request.Params["TVA"].ToString() : string.Empty;
string FODEC = Request.Params["FODEC"] != null ? Request.Params["FODEC"].ToString() : string.Empty;
string DROIT_CONSOMMATION = Request.Params["DROIT_CONSOMMATION"] != null ? Request.Params["DROIT_CONSOMMATION"].ToString() : string.Empty;
string NUMERO_AUTORISATION = Request.Params["NUMERO_AUTORISATION"] != null ? Request.Params["NUMERO_AUTORISATION"].ToString() : string.Empty;
string DATE_AUTORISATION = Request.Params["DATE_AUTORISATION"] != null ? Request.Params["DATE_AUTORISATION"].ToString() : string.Empty;
string ACTION = Request.Params["ACTION"] != null ? Request.Params["ACTION"].ToString() : string.Empty;
if (ACTION == "BACK")
{
return(RedirectToAction("Form", "DeclarationFAC", new { @Mode = "Edit", @Code = -1 }));
}
if (ACTION == "PRINT")
{
}
if (ACTION == "VALIDATE")
{
DECLARATIONS_FACS NouvelleDeclaration = new DECLARATIONS_FACS();
GestionCommercialeEntity BD_A = new GestionCommercialeEntity();
GestionCommercialeEntity BD_B = new GestionCommercialeEntity();
int IdSociete = int.Parse(SOCIETE);
DECLARATIONS SelectedSociete = BD.DECLARATIONS.Find(IdSociete);
NouvelleDeclaration.ANNEE = int.Parse(ANNEE);
NouvelleDeclaration.CODE = "FAC_T" + TRIMESTRE + "_" + ANNEE.Substring(2);
NouvelleDeclaration.DATE = DateTime.Today;
NouvelleDeclaration.TRIMESTRE = int.Parse(TRIMESTRE);
NouvelleDeclaration.DECLARATIONS = SelectedSociete;
NouvelleDeclaration.SOCIETE = IdSociete;
NouvelleDeclaration.VALIDE = true;
BD.DECLARATIONS_FACS.Add(NouvelleDeclaration);
BD.SaveChanges();
foreach (LIGNES_DECLARATIONS_FACS Ligne in Liste)
{
LIGNES_DECLARATIONS_FACS NouvelleLigne = new LIGNES_DECLARATIONS_FACS();
NouvelleLigne.NUMERO_FACTURE = Ligne.NUMERO_FACTURE;
NouvelleLigne.DATE_FACTURE = Ligne.DATE_FACTURE;
NouvelleLigne.DECLARATION_FAC = NouvelleDeclaration.ID;
NouvelleLigne.DECLARATIONS_FACS = NouvelleDeclaration;
NouvelleLigne.MONTANT_TVA = Ligne.MONTANT_TVA;
NouvelleLigne.FODEC = Ligne.FODEC;
NouvelleLigne.DROIT_CONSOMMATION = Ligne.DROIT_CONSOMMATION;
NouvelleLigne.PRIX_HT = Ligne.PRIX_HT;
NouvelleLigne.TVA = Ligne.TVA;
NouvelleLigne.DATE_AUTORISATION = Ligne.DATE_AUTORISATION;
NouvelleLigne.NUMERO_AUTORISATION = Ligne.NUMERO_AUTORISATION;
NouvelleLigne.NUMERO_ORDRE = Ligne.NUMERO_ORDRE;
CLIENTS Cli = Ligne.CLIENTS;
NouvelleLigne.CLIENT = Cli.ID;
NouvelleLigne.TYPE_CLIENT = Ligne.TYPE_CLIENT;
BD.LIGNES_DECLARATIONS_FACS.Add(NouvelleLigne);
BD.SaveChanges();
}
#region SaveFile
FileInfo info = new FileInfo("Fichier vide.TXT");
string nom = "FAC_T" + TRIMESTRE + "_" + ANNEE.Substring(2);
var fileStream = System.IO.File.Open(Server.MapPath(@"~/Images/" + nom), FileMode.OpenOrCreate, FileAccess.ReadWrite);
fileStream.Close();
info = new FileInfo(Server.MapPath(@"~/Images/" + nom));
//"c:\\Variables.txt", true, Encoding.ASCII
using (StreamWriter writer = new StreamWriter(Server.MapPath(@"~/Images/" + nom), true, Encoding.ASCII))
{
string EF01 = SelectedSociete.MATRICULE;
string EF05 = ANNEE;
string EF06 = "T" + TRIMESTRE;
string EF07 = SelectedSociete.SOCIETE != null ? SelectedSociete.SOCIETE : string.Empty;;
string EF08 = SelectedSociete.ACTIVITE != null ? SelectedSociete.ACTIVITE : string.Empty;
string EF09 = SelectedSociete.VILLE != null ? SelectedSociete.VILLE : string.Empty;
string EF10 = SelectedSociete.RUE != null ? SelectedSociete.RUE : string.Empty;
string EF11 = SelectedSociete.NUMERO != null ? SelectedSociete.NUMERO : string.Empty;
string EF12 = SelectedSociete.CODE_POSTAL != null ? SelectedSociete.CODE_POSTAL : string.Empty;
string EF13 = string.Empty;
while (EF07.Length < 40)
{
EF07 = EF07 + " ";
}
while (EF08.Length < 40)
{
EF08 = EF08 + " ";
}
while (EF09.Length < 40)
{
EF09 = EF09 + " ";
}
while (EF10.Length < 72)
{
EF10 = EF10 + " ";
}
while (EF11.Length < 4)
{
EF11 = EF11 + " ";
}
while (EF12.Length < 4)
{
EF12 = EF12 + " ";
}
while (EF13.Length < 111)
{
EF13 = EF13 + " ";
}
string FirstLine = "EF" + EF01 + EF05 + EF06 + EF07 + EF08 + EF09 + EF10 + EF11 + EF12 + EF13;
writer.WriteLine(FirstLine);
List <LIGNES_DECLARATIONS_FACS> NouvelleListe = BD.LIGNES_DECLARATIONS_FACS.Where(Element => Element.DECLARATIONS_FACS.ID == NouvelleDeclaration.ID).ToList();
decimal SumTotal = 0;
decimal SumTva = 0;
decimal SumFodec = 0;
decimal SumDroitConsommation = 0;
int NumeroOrdre = 1;
foreach (LIGNES_DECLARATIONS_FACS Ligne in NouvelleListe)
{
CLIENTS SelectedClient = BD.CLIENTS.Find(Ligne.CLIENT);
string DF07 = NumeroOrdre.ToString("000000"); //6
string DF08 = Ligne.NUMERO_FACTURE; //20
string DF09 = Ligne.DATE_FACTURE.ToShortDateString().Replace("/", ""); //8
string DF10 = Ligne.TYPE_CLIENT.ToString(); //1
string DF11 = SelectedClient.ID_FISCAL != null ? SelectedClient.ID_FISCAL : string.Empty; //13
string DF12 = SelectedClient.NOM != null ? SelectedClient.NOM : string.Empty; //40
string DF13 = SelectedClient.ADRESSE != null ? SelectedClient.ADRESSE : string.Empty; //120
string DF14 = Ligne.NUMERO_AUTORISATION; //20
string DF15 = Ligne.DATE_AUTORISATION.ToShortDateString().Replace("/", ""); //8
SumTotal += Ligne.PRIX_HT;
string DF16 = Ligne.PRIX_HT.ToString("F3").Replace(",", ""); //15
SumFodec += Ligne.MONTANT_FODEC;
string DF17 = Ligne.FODEC.ToString("00000"); //5
string DF18 = Ligne.MONTANT_FODEC.ToString("F3").Replace(",", ""); //15
SumDroitConsommation += Ligne.MONTANT_DROIT_CONSOMMATION;
string DF19 = Ligne.DROIT_CONSOMMATION.ToString("00000"); //5
string DF20 = Ligne.MONTANT_DROIT_CONSOMMATION.ToString("F3").Replace(",", ""); //15
SumTva += Ligne.MONTANT_TVA;
string DF21 = Ligne.TVA.ToString("00000"); //5
string DF22 = Ligne.MONTANT_TVA.ToString("F3").Replace(",", ""); //15
while (DF08.Length < 20)
{
DF08 = DF08 + " ";
}
while (DF11.Length < 13)
{
DF11 = DF11 + " ";
}
while (DF12.Length < 40)
{
DF12 = DF12 + " ";
}
while (DF13.Length < 120)
{
DF13 = DF13 + " ";
}
if (DF13.Length > 120)
{
DF13 = DF13.Substring(0, 120);
}
while (DF14.Length < 20)
{
DF14 = DF14 + " ";
}
while (DF16.Length < 15)
{
DF16 = "0" + DF16;
}
while (DF18.Length < 15)
{
DF18 = "0" + DF18;
}
while (DF20.Length < 15)
{
DF20 = "0" + DF20;
}
while (DF22.Length < 15)
{
DF22 = "0" + DF22;
}
string SubLine = "DF" + EF01 + EF05 + EF06 + DF07 + DF08 + DF09 + DF10 + DF11 + DF12 + DF13 + DF14 + DF15 + DF16 + DF17 + DF18 + DF19 + DF20 + DF21 + DF22;
writer.WriteLine(SubLine);
NumeroOrdre++;
}
string TF007 = NouvelleListe.Count.ToString("000000"); //6
string TF08 = string.Empty; //230
while (TF08.Length < 230)
{
TF08 = TF08 + " ";
}
string TF09 = SumTotal.ToString("F3").Replace(",", ""); //15
string TF10 = "00000"; //50
string TF11 = SumFodec.ToString("F3").Replace(",", ""); //15
string TF12 = "00000"; //5
string TF13 = SumDroitConsommation.ToString("F3").Replace(",", ""); //15
string TF14 = "00000";
string TF15 = SumTva.ToString("F3").Replace(",", ""); //15
while (TF09.Length < 15)
{
TF09 = "0" + TF09;
}
while (TF11.Length < 15)
{
TF11 = "0" + TF11;
}
while (TF13.Length < 15)
{
TF13 = "0" + TF13;
}
while (TF15.Length < 15)
{
TF15 = "0" + TF15;
}
string LastLine = "TF" + EF01 + EF05 + EF06 + TF007 + TF08 + TF09 + TF10 + TF11 + TF12 + TF13 + TF14 + TF15;
writer.WriteLine(LastLine);
}
byte[] fileBytes = System.IO.File.ReadAllBytes(Server.MapPath(@"~/Images/" + nom));
NouvelleDeclaration.DATA = fileBytes;
BD.SaveChanges();
#endregion
Session.Clear();
return(RedirectToAction("Index"));
}
if (ACTION == "ADD")
{
LIGNES_DECLARATIONS_FACS Ligne = new LIGNES_DECLARATIONS_FACS();
if (Mode == "Create")
{
Ligne.NUMERO_ORDRE = Liste.Count + 1;
Ligne.NUMERO_FACTURE = NUMERO_FACTURE;
Ligne.DATE_FACTURE = DateTime.Parse(DATE_FACTURE);
int ID_CLIENT = int.Parse(client);
CLIENTS SelectedClient = BD.CLIENTS.Find(ID_CLIENT);
Ligne.CLIENT = ID_CLIENT;
Ligne.CLIENTS = SelectedClient;
Ligne.TYPE_CLIENT = int.Parse(TYPE_CLIENT);
if (PRIX_HT.Contains(','))
{
Ligne.PRIX_HT = decimal.Parse(PRIX_HT);
}
else
{
Ligne.PRIX_HT = decimal.Parse(PRIX_HT, CultureInfo.InvariantCulture);
}
int fodec = int.Parse(FODEC);
int droit_consommation = int.Parse(DROIT_CONSOMMATION);
decimal MONTANT_FODEC = (decimal)((Ligne.PRIX_HT * fodec) / 100);
decimal MONTANT_DROIT_CONSOMMATION = (decimal)((Ligne.PRIX_HT * droit_consommation) / 100);
Ligne.FODEC = fodec;
Ligne.MONTANT_FODEC = MONTANT_FODEC;
Ligne.DROIT_CONSOMMATION = droit_consommation;
Ligne.MONTANT_DROIT_CONSOMMATION = MONTANT_DROIT_CONSOMMATION;
Ligne.TVA = int.Parse(TVA);
//Ligne.PRIX_HT = totale_ht;
Ligne.MONTANT_TVA = ((Ligne.PRIX_HT + MONTANT_FODEC + MONTANT_DROIT_CONSOMMATION) * int.Parse(TVA)) / 100;
Ligne.NUMERO_AUTORISATION = NUMERO_AUTORISATION;
Ligne.DATE_AUTORISATION = DateTime.Parse(DATE_AUTORISATION);
Liste.Add(Ligne);
}
if (Mode == "Edit")
{
int SelectedRow = int.Parse(Code);
Ligne = Liste.Where(Element => Element.NUMERO_ORDRE == SelectedRow).FirstOrDefault();
//Ligne.NUMERO_ORDRE = Liste.Count + 1;
Ligne.NUMERO_FACTURE = NUMERO_FACTURE;
Ligne.DATE_FACTURE = DateTime.Parse(DATE_FACTURE);
int ID_CLIENT = int.Parse(client);
CLIENTS SelectedClient = BD.CLIENTS.Find(ID_CLIENT);
Ligne.CLIENT = ID_CLIENT;
Ligne.CLIENTS = SelectedClient;
Ligne.TYPE_CLIENT = int.Parse(TYPE_CLIENT);
if (PRIX_HT.Contains(','))
{
Ligne.PRIX_HT = decimal.Parse(PRIX_HT);
}
else
{
Ligne.PRIX_HT = decimal.Parse(PRIX_HT, CultureInfo.InvariantCulture);
}
int fodec = int.Parse(FODEC);
int droit_consommation = int.Parse(DROIT_CONSOMMATION);
decimal MONTANT_FODEC = (decimal)((Ligne.PRIX_HT * fodec) / 100);
decimal MONTANT_DROIT_CONSOMMATION = (decimal)((Ligne.PRIX_HT * droit_consommation) / 100);
Ligne.FODEC = fodec;
Ligne.MONTANT_FODEC = MONTANT_FODEC;
Ligne.DROIT_CONSOMMATION = droit_consommation;
Ligne.MONTANT_DROIT_CONSOMMATION = MONTANT_DROIT_CONSOMMATION;
Ligne.TVA = int.Parse(TVA);
//Ligne.PRIX_HT = totale_ht;
Ligne.MONTANT_TVA = ((Ligne.PRIX_HT + MONTANT_FODEC + MONTANT_DROIT_CONSOMMATION) * int.Parse(TVA)) / 100;
Ligne.NUMERO_AUTORISATION = NUMERO_AUTORISATION;
Ligne.DATE_AUTORISATION = DateTime.Parse(DATE_AUTORISATION);
}
}
if (ACTION == "DELETE")
{
LIGNES_DECLARATIONS_FACS Ligne = new LIGNES_DECLARATIONS_FACS();
int SelectedRow = int.Parse(Code);
Ligne = Liste.Where(Element => Element.NUMERO_ORDRE == SelectedRow).FirstOrDefault();
Liste.Remove(Ligne);
for (int i = 0; i < Liste.Count; i++)
{
Liste.ElementAt(i).NUMERO_ORDRE = i + 1;
}
}
Session["LignesFacture_FAC"] = Liste;
return(RedirectToAction("Second", "DeclarationFAC", new { @Mode = "Create", @Code = "-1", @ANNEE = ANNEE, @SOCIETE = SOCIETE, @TRIMESTRE = TRIMESTRE }));
}
