public ActionResult Second(string Mode, string Code, string ANNEE, string SOCIETE, string TRIMESTRE) { int ID = int.Parse(SOCIETE); string SelectedSociete = BD.DECLARATIONS.Find(ID).SOCIETE; CLIENTS Client = new CLIENTS(); ViewBag.TRIMESTRE = TRIMESTRE; ViewBag.ANNEE = ANNEE; ViewBag.SOCIETE = SelectedSociete; ViewBag.Mode = Mode; ViewBag.Code = Code; LIGNES_DECLARATIONS_FACS Ligne = new LIGNES_DECLARATIONS_FACS(); Ligne.DATE_AUTORISATION = DateTime.Today; Ligne.DATE_FACTURE = DateTime.Today; if (Mode == "Edit") { List <LIGNES_DECLARATIONS_FACS> Liste = new List <LIGNES_DECLARATIONS_FACS>(); if (Session["LignesFacture_FAC"] != null) { Liste = (List <LIGNES_DECLARATIONS_FACS>)Session["LignesFacture_FAC"]; if (Liste.Count > 0) { int SelectedRow = int.Parse(Code); Ligne = Liste.Where(Element => Element.NUMERO_ORDRE == SelectedRow).FirstOrDefault(); } } } return(View(Ligne)); }
public ActionResult SecondEdit(int Code, int ParamPassed) { DECLARATIONS_FACS DeclarationFAC = BD.DECLARATIONS_FACS.Find(Code); LIGNES_DECLARATIONS_FACS LigneDeclarationFAC = new LIGNES_DECLARATIONS_FACS(); LigneDeclarationFAC.DATE_AUTORISATION = DateTime.Today; LigneDeclarationFAC.DATE_FACTURE = DateTime.Today; if (ParamPassed > 0) { LigneDeclarationFAC = BD.LIGNES_DECLARATIONS_FACS.Find(ParamPassed); } ViewBag.TRIMESTRE = DeclarationFAC.TRIMESTRE; ViewBag.ANNEE = DeclarationFAC.ANNEE; ViewBag.SOCIETE = DeclarationFAC.DECLARATIONS.SOCIETE; ViewBag.Code = Code; ViewBag.ParamPassed = ParamPassed; return(View(LigneDeclarationFAC)); }
public ActionResult SendSecondEditForm(int Code, int ParamPassed) { 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; #region DELETE if (ACTION == "DELETE") { LIGNES_DECLARATIONS_FACS Ligne = new LIGNES_DECLARATIONS_FACS(); Ligne = BD.LIGNES_DECLARATIONS_FACS.Where(Element => Element.ID == ParamPassed).FirstOrDefault(); BD.LIGNES_DECLARATIONS_FACS.Remove(Ligne); BD.SaveChanges(); for (int i = 0; i < BD.LIGNES_DECLARATIONS_FACS.ToList().Count; i++) { BD.LIGNES_DECLARATIONS_FACS.ToList().ElementAt(i).NUMERO_ORDRE = i + 1; BD.SaveChanges(); } } #endregion #region ADD if (ACTION == "ADD") { LIGNES_DECLARATIONS_FACS Ligne = new LIGNES_DECLARATIONS_FACS(); if (ParamPassed <= 0) { Ligne.NUMERO_ORDRE = BD.LIGNES_DECLARATIONS_FACS.Where(Element => Element.DECLARATIONS_FACS.ID == Code).ToList().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); Ligne.DECLARATIONS_FACS = BD.DECLARATIONS_FACS.Find(Code); Ligne.DECLARATION_FAC = Code; BD.LIGNES_DECLARATIONS_FACS.Add(Ligne); BD.SaveChanges(); } if (ParamPassed > 0) { Ligne = BD.LIGNES_DECLARATIONS_FACS.Where(Element => Element.DECLARATIONS_FACS.ID == Code).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); BD.SaveChanges(); } } #endregion if (ACTION == "VALIDATE") { #region SaveFile DECLARATIONS_FACS NouvelleDeclaration = BD.DECLARATIONS_FACS.Find(Code); FileInfo info = new FileInfo("Fichier vide.TXT"); string nom = "FAC_T" + NouvelleDeclaration.TRIMESTRE + "_" + NouvelleDeclaration.ANNEE.ToString().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 = info.CreateText()) using (StreamWriter writer = new StreamWriter(Server.MapPath(@"~/Images/" + nom), false, Encoding.ASCII)) { string EF01 = NouvelleDeclaration.DECLARATIONS.MATRICULE; string EF05 = NouvelleDeclaration.ANNEE.ToString(); string EF06 = "T" + NouvelleDeclaration.TRIMESTRE.ToString(); string EF07 = NouvelleDeclaration.DECLARATIONS.SOCIETE != null ? NouvelleDeclaration.DECLARATIONS.SOCIETE : string.Empty;; string EF08 = NouvelleDeclaration.DECLARATIONS.ACTIVITE != null ? NouvelleDeclaration.DECLARATIONS.ACTIVITE : string.Empty; string EF09 = NouvelleDeclaration.DECLARATIONS.VILLE != null ? NouvelleDeclaration.DECLARATIONS.VILLE : string.Empty; string EF10 = NouvelleDeclaration.DECLARATIONS.RUE != null ? NouvelleDeclaration.DECLARATIONS.RUE : string.Empty; string EF11 = NouvelleDeclaration.DECLARATIONS.NUMERO != null ? NouvelleDeclaration.DECLARATIONS.NUMERO : string.Empty; string EF12 = NouvelleDeclaration.DECLARATIONS.CODE_POSTAL != null ? NouvelleDeclaration.DECLARATIONS.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")); } return(RedirectToAction("SecondEdit", "DeclarationFAC", new { ParamPassed = -1, @Code = Code })); }