public static string FillDataTable() { try { DataSet ds = GeneralBL.FillDataSet(40, "SP_RoomType", ref strErrorMessge, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessge = exp.Message); } }
public static string LoadRawItems(string Value) { try { strErrorType = strErrorType = ""; DataSet ds = GeneralBL.FillDataSet(4, "SPR_RawItems", ref strErrorType, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string LoadItemscategory() { try { strErrorType = strErrorType = ""; DataSet ds = GeneralBL.FillDataSet(5, "SPR_ItemsCategory", ref strErrorType, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string EditCustomer(int CustomerID) { try { strErrorMessage = strErrorType = ""; DataSet ds = GeneralBL.FillDataSet(5, CustomerID, "@CustomerID", "SPR_Customers", ref strErrorMessage, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string EditSuppilers(int SuppliersID) { try { strErrorMessage = strErrorType = ""; DataSet ds = GeneralBL.FillDataSet(4, SuppliersID, "@SuppliersID", "SPR_Suppliers", ref strErrorMessage, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string LoadCustomer(string Search) { try { strErrorType = strErrorType = ""; //SqlParameter[] paramstostore = new SqlParameter[2]; //paramstostore[0] = new SqlParameter("@OpCode", SqlDbType.Int); //paramstostore[0].Value = 5; //paramstostore[1] = new SqlParameter("@Amount", SqlDbType.VarChar); //paramstostore[1].Value = Search; DataSet ds = GeneralBL.FillDataSet(8, Search, "@CustomerName", "SPR_Customers", ref strErrorType, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }