public List <eCustomer_VM> GetData(eCustomer_VM Model)
{
var query = new List <eCustomer_VM>();
try
{
using (var db = new DBConnection())
{
var ds = new DataSet();
var par = new SqlParameter[] {
new SqlParameter("@p_CustomerID", GetDBNULL(Model.CustomerID, true)),
new SqlParameter("@p_CustomerName", GetDBNULL(Model.CustomerName, true)),
new SqlParameter("@p_CustomerAddress", GetDBNULLString(Model.CustomerAddress)),
new SqlParameter("@p_ContactNumber", GetDBNULLString(Model.ContactNumber)),
new SqlParameter("@p_DOB", GetDBNULL(Model.DOB)),
new SqlParameter("@p_AnniversaryDate", GetDBNULL(Model.AnniversaryDate)),
new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID, true)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID, true)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID, true)),
new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint))
};
ds = db.ExecuteDataSet("GeteCustomer", par);
query = ConvertToList <eCustomer_VM>(ds.Tables[0]);
}
}
catch (Exception ex)
{
logger.Error("InvoiceRepository_GetData Error: ", ex);
throw;
}
return(query);
}
public int Delete(eCustomer_VM Model)
{
int result = 0;
try
{
using (var db = new DBConnection())
{
var par = new SqlParameter[] {
new SqlParameter("@p_CustomerID", GetDBNULL(Model.CustomerID, true)),
new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)),
new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint)),
};
result = db.ExecuteNonQueryRollBack("DeleteeCustomer", par);
}
}
catch (Exception ex)
{
logger.Error("eCustomerRepository_Delete: ", ex);
throw;
}
return(result);
}
public int Update(eCustomer_VM Model)
{
int result = 0;
try
{
using (var db = new DBConnection())
{
var par = new SqlParameter[] {
new SqlParameter("@p_CustomerID", GetDBNULL(Model.CustomerID, true)),
new SqlParameter("@p_CustomerName", GetDBNULLString(Model.CustomerName)),
new SqlParameter("@p_CustomerAddress", GetDBNULLString(Model.CustomerAddress)),
new SqlParameter("@p_ContactNumber", GetDBNULLString(Model.ContactNumber)),
new SqlParameter("@p_DOB", GetDBNULL(Model.DOB)),
new SqlParameter("@p_AnniversaryDate", GetDBNULL(Model.AnniversaryDate)),
new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)),
new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint))
};
result = db.ExecuteNonQueryRollBack("UpdateeCustomer", par);
}
}
catch (Exception ex)
{
logger.Error("eCustomerRepository_Update: ", ex);
throw;
}
return(result);
}
public int Add(eCustomer_VM Model)
{
int result = 0;
try
{
using (var db = new DBConnection())
{
var output = new SqlParameter("@p_CustomerID", 0)
{
Direction = ParameterDirection.Output
};
var par = new SqlParameter[] {
new SqlParameter("@p_CustomerName", GetDBNULLString(Model.CustomerName)),
new SqlParameter("@p_CustomerAddress", GetDBNULLString(Model.CustomerAddress)),
new SqlParameter("@p_ContactNumber", GetDBNULLString(Model.ContactNumber)),
new SqlParameter("@p_DOB", GetDBNULL(Model.DOB)),
new SqlParameter("@p_AnniversaryDate", GetDBNULL(Model.AnniversaryDate)),
new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)),
new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint)),
output
};
result = db.ExecuteNonQueryRollBack("AddeCustomer", par);
result = Convert.ToInt32(output.Value);
}
}
catch (Exception ex)
{
logger.Error("eCustomerRepository_Add: ", ex);
throw;
}
return(result);
}
public List <eCustomer_VM> GeteCustomerDDL(eCustomer_VM Model)
{
var query = new List <eCustomer_VM>();
try
{
using (var db = new DBConnection())
{
var ds = new DataSet();
var par = new SqlParameter[] { new SqlParameter("@p_Search", GetDBNULLString(Model.GlobalID)) };
ds = db.ExecuteDataSet("GeteCustomerDDL", par);
query = ConvertToList <eCustomer_VM>(ds.Tables[0]);
}
}
catch (Exception ex)
{
logger.Error("InvoiceRepository_GeteCustomerDDL Error: ", ex);
throw;
}
return(query);
}