public bool InsertTravelTax(TravelTax_Model MyModel) { bool MyResult = false; try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString)) { DynamicParameters MyDynamicParameters = new DynamicParameters(); MyDynamicParameters.Add("@iTravelID", MyModel.iTravelID); MyDynamicParameters.Add("@iTaxID", MyModel.iTaxID); MyDynamicParameters.Add("@mTax", MyModel.mTax); MyDynamicParameters.Add("@mTaxAmount", MyModel.mTaxAmount); MyResult = con.Execute("ProcInsertTravelTax", MyDynamicParameters, commandType: CommandType.StoredProcedure) > 0 ? true : false; } } catch (Exception Exc) { Error_Component.ManageError(new Error_DTO { vAction_Type = "Repository", vController = "Client_Repository", vAction = "GetEntity_List", vError_Message = Exc.Message, vError_Line = "", vInput_Values = "", vRemarks = "" }); } return(MyResult); }
public ActionResult Index(TravelHistory_Model MyModel) { //06/01/2021 - 06/05/2021 if (!string.IsNullOrEmpty(MyModel.dStartingDate)) { MyModel.dClosingDate = (MyModel.dStartingDate.Split('-')[1]).TrimStart(); MyModel.dStartingDate = (MyModel.dStartingDate.Split('-')[0]).TrimEnd(); } MyModel.iTravelID = MyTravel_Repository.InsertTravelHistory(MyModel); if (MyModel.iTravelID > 0) { MyTravel_Repository.InsertTravelAmount(MyModel); //,1:147.75,3:295.5 if (!string.IsNullOrEmpty(MyModel.Taxitemlist)) { string[] TaxItems = MyModel.Taxitemlist.Split(','); foreach (string Item in TaxItems) { if (Item.Split(':').Count() > 1) { TravelTax_Model MyObject = new TravelTax_Model(); MyObject.iTaxID = Item.Split(':')[0]; MyObject.mTaxAmount = Item.Split(':')[1]; MyObject.iTravelID = MyModel.iTravelID.ToString(); MyTravel_Repository.InsertTravelTax(MyObject); } } } } return(RedirectToAction("PrintInvoice", new { id = MyModel.iTravelID })); }