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 List <MasterData_DTO> GetTaxMaster()
{
List <MasterData_DTO> MyModelList = new List <MasterData_DTO>();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
DynamicParameters MyDynamicParameters = new DynamicParameters();
MyDynamicParameters.Add("@ID", "0");
MyDynamicParameters.Add("@Action", "Get");
MyDynamicParameters.Add("@vName", "0");
MyDynamicParameters.Add("@mTax", "0");
MyModelList = con.Query <MasterData_DTO>("[dbo].[ProcManageTax]", MyDynamicParameters, commandType: CommandType.StoredProcedure).ToList();
}
}
catch (Exception Exc)
{
Error_Component.ManageError(new Error_DTO {
vAction_Type = "Repository", vController = "User_Repository", vAction = "GetEntity_List", vError_Message = Exc.Message, vError_Line = "", vInput_Values = "", vRemarks = ""
});
}
return(MyModelList);
}
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 List <SelectListItem> GetMasterDataItems(string ActionBy, string FilterBy, string FilterBy2 = "0")
{
List <SelectListItem> MyModelList = new List <SelectListItem>();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
DynamicParameters MyDynamicParameters = new DynamicParameters();
MyDynamicParameters.Add("@Action", ActionBy);
MyDynamicParameters.Add("@FilterBy", FilterBy);
MyDynamicParameters.Add("@FilterBy2", FilterBy2);
MyModelList = con.Query <SelectListItem>("ProcGetMasterData", MyDynamicParameters, commandType: CommandType.StoredProcedure).ToList();
}
}
catch (Exception Exc)
{
Error_Component.ManageError(new Error_DTO {
vAction_Type = "Repository", vController = "Master_Repository", vAction = "GetMasterData", vError_Message = Exc.Message, vError_Line = "", vInput_Values = "", vRemarks = ""
});
}
return(MyModelList);
}
public List <MasterData_DTO> GetWeekRange(string ActionBy, int UID)
{
List <MasterData_DTO> MyModelList = new List <MasterData_DTO>();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
DynamicParameters MyDynamicParameters = new DynamicParameters();
MyDynamicParameters.Add("@iWeekIDF", ActionBy);
MyDynamicParameters.Add("@iUserID", UID);
MyModelList = con.Query <MasterData_DTO>("ProcGetWeeksRangeForFilter", MyDynamicParameters, commandType: CommandType.StoredProcedure).ToList();
}
}
catch (Exception Exc)
{
Error_Component.ManageError(new Error_DTO {
vAction_Type = "Repository", vController = "Master_Repository", vAction = "GetMasterData", vError_Message = Exc.Message, vError_Line = "", vInput_Values = "", vRemarks = ""
});
}
return(MyModelList);
}
public bool ManageEntity(VehicleType_Model MyModel, string Action)
{
bool MyResult = false;
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
DynamicParameters MyDynamicParameters = new DynamicParameters();
MyDynamicParameters.Add("@ID", MyModel.ID);
MyDynamicParameters.Add("@vName", MyModel.vName);
MyDynamicParameters.Add("@Action", Action);
MyResult = con.Execute("ProcManageVehicleType", MyDynamicParameters, commandType: CommandType.StoredProcedure) > 0 ? true : false;
}
}
catch (Exception Exc)
{
Error_Component.ManageError(new Error_DTO {
vAction_Type = "Repository", vController = "User_Repository", vAction = "GetEntity_List", vError_Message = Exc.Message, vError_Line = "", vInput_Values = "", vRemarks = ""
});
}
return(MyResult);
}
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 List <MasterData_DTO> GetMasterData()
{
List <MasterData_DTO> MyModelList = new List <MasterData_DTO>();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
MyModelList = con.Query <MasterData_DTO>("ProcGetMasterData", null, commandType: CommandType.StoredProcedure).ToList();
}
}
catch (Exception Exc)
{
Error_Component.ManageError(new Error_DTO {
vAction_Type = "Repository", vController = "Master_Repository", vAction = "GetMasterData", vError_Message = Exc.Message, vError_Line = "", vInput_Values = "", vRemarks = ""
});
}
return(MyModelList);
}
public List <TravelTax_Model> GetEntity_List()
{
List <TravelTax_Model> MyModelList = new List <TravelTax_Model>();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
DynamicParameters MyDynamicParameters = new DynamicParameters();
MyDynamicParameters.Add("@Action", "Get");
MyDynamicParameters.Add("@ID", "0");
MyDynamicParameters.Add("@ActionBy", "0");
MyDynamicParameters.Add("@vName", "0");
MyDynamicParameters.Add("@iRoleID", "0");
MyDynamicParameters.Add("@vLoginID", "0");
MyDynamicParameters.Add("@iManager_Level1", "0");
MyDynamicParameters.Add("@iManager_Level2", "0");
MyDynamicParameters.Add("@iDirectorID", "0");
MyDynamicParameters.Add("@iRegionID", "0");
MyDynamicParameters.Add("@iTimeZoneID", "0");
MyDynamicParameters.Add("@bisExempt_Report", "0");
MyDynamicParameters.Add("@dExpectedStartOn", "0");
MyDynamicParameters.Add("@iCompanyID", "0");
MyModelList = con.Query <TravelTax_Model>("ProcManageUser", MyDynamicParameters, commandType: CommandType.StoredProcedure).ToList();
}
}
catch (Exception Exc)
{
Error_Component.ManageError(new Error_DTO {
vAction_Type = "Repository", vController = "User_Repository", vAction = "GetEntity_List", vError_Message = Exc.Message, vError_Line = "", vInput_Values = "", vRemarks = ""
});
}
return(MyModelList);
}
