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