public DataTable GetErrorCodeDescription(string errorCode)
{
DataTable errorMessageInfo = new DataTable();
try
{
using (var context = new labo_salesEntities())
{
var errorMessage = context.sp_GetErrorMessage(errorCode);
errorMessageInfo = DataTransformer.CreateDataTable(errorMessage.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
return(errorMessageInfo);
}
public DataTable GetSalesRecordsData()
{
DataTable salesRecords = new DataTable();
try
{
using (var context = new labo_salesEntities())
{
var salesData = context.sp_GetSalesReportDetails();
salesRecords = DataTransformer.CreateDataTable(salesData.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
return(salesRecords);
}
public DataTable GetUserDetails(UserEnt userDetail)
{
DataTable userList = new DataTable();
try
{
using (var context = new labo_salesEntities())
{
var userResult = context.sp_GetUserDetails(userDetail.username, userDetail.password);
userList = DataTransformer.CreateDataTable(userResult.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
return(userList);
}
public string InsertLoadedDatatoDB(DataTable uplrecords)
{
string result = "OK";
try
{
using (var DB = new labo_salesEntities())
{
SqlParameter Parameter = new SqlParameter("@param1", uplrecords);
Parameter.TypeName = "salesDetailType";
DB.Database.ExecuteSqlCommand("exec sp_InsertSalesDetails @param1", Parameter);
}
}
catch (Exception ex)
{
result = ex.Message;
}
return(result);
}
public DataTable gisplayProftDetailsGrid(string selectFromDate, string selectToDate)
{
DataTable profitDetails = new DataTable();
try
{
using (var context = new labo_salesEntities())
{
DateTime formatedFromDate = DateTime.ParseExact(selectFromDate, "yyyy/MM/dd", CultureInfo.InvariantCulture, DateTimeStyles.None);
DateTime formatedToDate = DateTime.ParseExact(selectToDate, "yyyy/MM/dd", CultureInfo.InvariantCulture, DateTimeStyles.None);
var profitdata = context.sp_GetSalesReportDetailsByDate(formatedFromDate, formatedToDate);
profitDetails = DataTransformer.CreateDataTable(profitdata.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
return(profitDetails);
}