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 }));
}
