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