public ActionResult detailPrest(string prestOTID, string mode, string prestDetailID = "") { mj = new MAJ(); var prestModel = new PrestationModel(); var prestType = ""; var prestEtat = ""; var IsPrestGroupe = false; var prestProduit = ""; var prestPrix = ""; var prestRefCmdClient = ""; var prestNbrPeriode = "0"; if (mode == "Ajouter") { prestEtat = "00"; DataTable dtN = Configs._query.executeProc("prestGetPrestationNbr", "OTID@int@" + prestOTID); if (Tools.verifyDataTable(dtN)) { //if (dtN.Rows[0][1].ToString() == "0")fix it prestRefCmdClient = dtN.Rows[0][0].ToString(); } } else if (mode == "Modifier") { DataTable dtPrest = Configs._query.executeProc("prestGetDetailPrest", "otid@int@" + prestOTID + "#type@string@0" + "#detailID@int@" + prestDetailID, true); if (dtPrest != null) { prestProduit = dtPrest.Rows[0]["Produit"].ToString(); prestPrix = dtPrest.Rows[0]["Prix"].ToString(); prestEtat = dtPrest.Rows[0]["Etat"].ToString(); prestType = dtPrest.Rows[0]["type"].ToString(); prestRefCmdClient = dtPrest.Rows[0]["RefCmdClient"].ToString(); prestNbrPeriode = dtPrest.Rows[0]["ProduitPeriodes"].ToString(); IsPrestGroupe = dtPrest.Rows[0]["PDG"] != DBNull.Value; } } ViewData["prestListPrestation"] = prestModel.listDTPrestation(prestType, prestOTID, prestProduit); if (!string.IsNullOrEmpty(prestDetailID) && prestDetailID != "-1") { ViewData["prestListPrestation"] = Configs._query.executeProc("prestGetpresMemeFamille", "id@int@" + prestDetailID); } ViewData["presStatus"] = Configs._query.executeProc("prestGetPropStatusPack", "etat@int@" + prestEtat); ViewData["RefCmdClient"] = prestRefCmdClient; ViewData["Etat"] = prestEtat; ViewData["Type"] = prestType; ViewData["Produit"] = prestProduit; ViewData["Prix"] = prestPrix; ViewData["mode"] = mode; ViewData["OTID"] = prestOTID; ViewData["prestDetailID"] = prestDetailID; ViewData["prestNbrPeriode"] = prestNbrPeriode; ViewData["IsPrestGroupe"] = IsPrestGroupe; return(View()); }
public string operationPrestation(string prestOtID, string prestMode, string prestPrix, string prestRefClient, string prestValList , string prestValStatut, string prestEtat, string prestID, string prestOldServ = "", string prestHeur = "", string prestMin = "") { string res = ""; PrestationModel prestModele = new PrestationModel(); int nbrPeriode = 0; int h, m; if (Int32.TryParse(prestHeur, out h) && Int32.TryParse(prestMin, out m)) { nbrPeriode = (h * 2) + (m / 30); } if (prestMode == "Ajouter") { res = prestModele.addPrestation(prestOtID, prestValList, prestPrix, prestRefClient, prestValStatut, nbrPeriode.ToString()); if (res != "") { res = "Prestation ajoutée"; } else { res = ""; } } else if (prestMode == "Modifier") { //string otid, string prestation, string prix, string oldPrestation, string refClient, string status, string idServ string user = Session["login"].ToString(); string CurrentAgenceID = Session["agenceID"] != null ? Session["agenceID"].ToString() : null; prestModele.updatePrestation(prestOtID, prestValList, prestPrix, prestOldServ, prestRefClient, prestValStatut, prestID, nbrPeriode.ToString(), user, CurrentAgenceID); res = "Prestation modifiée"; } else if (prestMode == "Supprimer") { //string otid, string prestation res = prestModele.deletePrestation(prestID, prestValList); if (res == "1") { res = "Prestation supprimée"; } else { res = ""; } } else if (prestMode == "Annuler") { // string otid, string prestation, string etat, string code, string planID prestModele.annulerPrestation(prestOtID, prestValList, "30", " update OT set codestock = '' where OTID = 0 ", "-1"); res = "Prestation annulée"; } else if (prestMode == "Activer") { prestModele.annulerPrestation(prestOtID, prestValList, "00", " update OT set codestock = '' where OTID = 0 ", "-1"); res = "Prestation activée"; } return(res); }