public DataTable funcPopulateProductGrid(BOProductDetails objBOProductDetails)
{
string condition;
string strSearchBy = "";
if (objBOProductDetails.searchBy == "Product ID")
{
strSearchBy = "product_id";
}
else if (objBOProductDetails.searchBy == "Product Name")
{
strSearchBy = "product_name";
}
else if (objBOProductDetails.searchBy == "Brand")
{
strSearchBy = "company";
}
else if (objBOProductDetails.searchBy == "Generic Name")
{
strSearchBy = "generic";
}
if (objBOProductDetails.searchTerm != "" && objBOProductDetails.searchBy != "")
{
condition = "WHERE ";
condition += strSearchBy;
condition += " like '";
condition += objBOProductDetails.searchTerm;
condition += "%'";
}
else
{
condition = "";
}
DataTable dt = new DataTable();
dt = objDALProductDetails.funcPopulateProductGrid(condition);
return(dt);
}
public bool funcInsertProdDetails(BOProductDetails objBOProdDetails)
{
try
{
//Initialization
objDB_Utility = new DB_Utility();
SqlConnection con = objDB_Utility.funcOpenConnection();
SqlCommand cmd = new SqlCommand("sp_insertProductMaster", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
//Code to Insert Supplier Details Data into Database using stored procedure
cmd.Parameters.AddWithValue("@product_id", 0);
cmd.Parameters.AddWithValue("@product_name", objBOProdDetails.medName);
cmd.Parameters.AddWithValue("@company", objBOProdDetails.company);
cmd.Parameters.AddWithValue("@contents", objBOProdDetails.contents);
cmd.Parameters.AddWithValue("@generic", objBOProdDetails.genericName);
cmd.Parameters.AddWithValue("@packing", objBOProdDetails.packing);
cmd.Parameters.AddWithValue("@unit", objBOProdDetails.unit);
cmd.Parameters.AddWithValue("@schedule", objBOProdDetails.schedule);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string filePath = @"..\ErrorLog.log";
using (System.IO.StreamWriter writer = new StreamWriter(filePath, true))
{
writer.WriteLine("Error Code : 00003" + Environment.NewLine + "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
writer.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
return(false);
}
finally
{
objDB_Utility.funcCloseConnection();
}
}
public bool funcInsertProductMaster(BOProductDetails objBOProdDetails)
{
bool retVal = objDALProductDetails.funcInsertProdDetails(objBOProdDetails);
return(retVal);
}
