internal DataSet getMaterials(object[] data)
{
string materialId = "", searchKey = "";
try
{
materialId = Convert.ToString(data[0]);
}
catch { materialId = ""; }
try
{
searchKey = Convert.ToString(data[1]);
}
catch { }
parameters = new SqlParameter[]
{
new SqlParameter("@pMaterialId", materialId),
new SqlParameter("@pSearchKey", searchKey)
};
DataSet table = new DataSet();
try
{
table = SqlDBHelper.ExecuteParamerizeSelectCommand("app_GetMaterials", CommandType.StoredProcedure, parameters);
}
catch (Exception ex) { }
return(table);
}
internal DataSet GetProductsForChallan(object[] data)
{
string action = "", materialId = "";
try
{
action = Convert.ToString(data[0]);
}
catch { }
try
{
materialId = Convert.ToString(data[1]);
}
catch { materialId = "0"; }
parameters = new SqlParameter[]
{
new SqlParameter("@pAction", action),
new SqlParameter("@pMaterialId", materialId)
};
DataSet table = new DataSet();
try
{
table = SqlDBHelper.ExecuteParamerizeSelectCommand("app_GetMaterialsForDdl", CommandType.StoredProcedure, parameters);
}
catch (Exception ex) { }
return(table);
}
internal DataSet getInvoiceById(int OrderId)
{
string orderid = "";
try
{
orderid = Convert.ToString(OrderId);
}
catch { }
parameters = new SqlParameter[]
{
new SqlParameter("@pOrderId", orderid)
};
DataSet table = new DataSet();
try
{
table = SqlDBHelper.ExecuteParamerizeSelectCommand("app_GetInvoiceById", CommandType.StoredProcedure, parameters);
}
catch (Exception ex) { }
return(table);
}
