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