public List <TravelHistory_Model> GetEntity_List(string Action, TravelHistory_Model MyModel) { List <TravelHistory_Model> MyModelList = new List <TravelHistory_Model>(); try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString)) { DynamicParameters MyDynamicParameters = new DynamicParameters(); MyDynamicParameters.Add("@Action", Action); MyDynamicParameters.Add("@iTravelID", MyModel.iTravelID); MyModelList = con.Query <TravelHistory_Model>("ProcGetTravelHistory", MyDynamicParameters, commandType: CommandType.StoredProcedure).ToList(); } } 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(MyModelList); }
public bool InsertTravelAmount(TravelHistory_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("@mPerKMChangres", MyModel.mPerKMChangres); MyDynamicParameters.Add("@mPerDayChangres", MyModel.mPerDayChangres); MyDynamicParameters.Add("@mNightChangres", MyModel.mNightChangres); MyDynamicParameters.Add("@mTollTaxAndParking", MyModel.mTollTaxAndParking); MyDynamicParameters.Add("@mTotalAmountBeforeTax", MyModel.mTotalAmountBeforeTax); MyDynamicParameters.Add("@mDiscountAmount", MyModel.mDiscountAmount); MyDynamicParameters.Add("@vDiscountRemarks", MyModel.vDiscountRemarks); MyDynamicParameters.Add("@mTotalTaxAmount", MyModel.mTotalTaxAmount); MyResult = con.Execute("ProcInsertTravelAmount", 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 Details() { TravelHistory_Model MyModel = new TravelHistory_Model(); MyModel.TravelHistory = MyTravel_Repository.GetEntity_List("Get", new TravelHistory_Model() { iTravelID = 0 }); return(View(MyModel)); }
public ActionResult PrintInvoice(int id) { TravelHistory_Model MyModel = new TravelHistory_Model(); MyModel.iTravelID = id; MyModel = MyTravel_Repository.GetEntity_List("GetPrintInvoice", MyModel).FirstOrDefault(); MyModel.TaxList = MyTravel_Repository.GetTravelTax_List(id).ToList(); return(View(MyModel)); }
public ActionResult Index() { TravelHistory_Model MyModel = new TravelHistory_Model(); MyModel.Todaydate = new DateTime().ToString("dd/MM/YYYY"); MyModel.VehicleType = Global_Component.FillDropdownList(MyMaster_Repository.GetMasterData("VehicleType", "", "").Where(var => var.vType == "VehicleType").Select(var => new SelectListItem { Text = var.vName, Value = var.ID }).ToList(), "--Vehicle Type--"); MyModel.TravelTaxList = MyMaster_Repository.GetMasterData("Tax", "", "").Where(var => var.vType == "Tax").ToList(); return(View(MyModel)); }
public int InsertTravelHistory(TravelHistory_Model MyModel) { int MyResult = 0; try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString)) { DynamicParameters MyDynamicParameters = new DynamicParameters(); MyDynamicParameters.Add("@vUserName", MyModel.vUserName); MyDynamicParameters.Add("@vUserPhoneNo", MyModel.vUserPhoneNo); MyDynamicParameters.Add("@vAddress", MyModel.vAddress); MyDynamicParameters.Add("@vPartyGSTIN", MyModel.vPartyGSTIN); MyDynamicParameters.Add("@vDriverName", MyModel.vDriverName); MyDynamicParameters.Add("@vDriverPhoneNo", MyModel.vDriverPhoneNo); MyDynamicParameters.Add("@vFromToPlace", MyModel.vFromToPlace); MyDynamicParameters.Add("@vVehicleNo", MyModel.vVehicleNo); MyDynamicParameters.Add("@iVehicleType", MyModel.iVehicleType); MyDynamicParameters.Add("@dStartingDate", MyModel.dStartingDate); MyDynamicParameters.Add("@dClosingDate", MyModel.dClosingDate); MyDynamicParameters.Add("@iHoliday", MyModel.iHoliday); MyDynamicParameters.Add("@iTotalDays", MyModel.iTotalDays); MyDynamicParameters.Add("@iStartingKM", MyModel.iStartingKM); MyDynamicParameters.Add("@iClosingKM", MyModel.iClosingKM); MyDynamicParameters.Add("@iTotalKM", MyModel.iTotalKM); MyDynamicParameters.Add("@iTravelID", dbType: DbType.String, direction: ParameterDirection.Output, size: 10); con.Execute("ProcInsertTravelHistory", MyDynamicParameters, commandType: CommandType.StoredProcedure); MyResult = Convert.ToInt32(MyDynamicParameters.Get <string>("@iTravelID")); } } 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 })); }