public System.Data.DataTable funcPopulateCustGrid(BOBuyerDetails objBOBuyerDL)
{
string condition;
string strSearchBy = "";
if (objBOBuyerDL.searchBy == "Customer ID")
{
strSearchBy = "cust_id";
}
else if (objBOBuyerDL.searchBy == "Customer Name")
{
strSearchBy = "cust_name";
}
else if (objBOBuyerDL.searchBy == "Contact Number")
{
strSearchBy = "contact_no";
}
else if (objBOBuyerDL.searchBy == "DL Number")
{
strSearchBy = "DL_no";
}
else if (objBOBuyerDL.searchBy == "TIN Number")
{
strSearchBy = "TIN_no";
}
if (objBOBuyerDL.searchTerm != "" && objBOBuyerDL.searchBy != "")
{
condition = "WHERE ";
condition += strSearchBy;
condition += " like '";
condition += objBOBuyerDL.searchTerm;
condition += "%'";
}
else
{
condition = "";
}
System.Data.DataTable dt = new System.Data.DataTable();
dt = objDAbuyerDL.funcPopulateCustGrid(condition);
return(dt);
}
public int funcCheckDuplicateCust(BOBuyerDetails objBOBuyerDetails)
{
objDB_Utility = new DB_Utility();
try
{
SqlConnection con = objDB_Utility.funcOpenConnection();
SqlCommand cmd = new SqlCommand("SELECT count(*) FROM customer_master WHERE UPPER(cust_name)=UPPER(@cust_name)", con);
cmd.Parameters.AddWithValue("@cust_name", objBOBuyerDetails.buyerName);
int retVal = Convert.ToInt32(cmd.ExecuteScalar());
return(retVal);
}
catch (Exception ex)
{
return(-1);
}
finally
{
objDB_Utility.funcCloseConnection();
}
}
public bool funcInsertCustDetails(BOBuyerDetails objBOBuyerDetails)
{
try
{
//Initialization
objDB_Utility = new DB_Utility();
SqlConnection con = objDB_Utility.funcOpenConnection();
SqlCommand cmd = new SqlCommand("sp_insertCustDetails", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
//Code to Insert Supplier Details Data into Database using stored procedure
cmd.Parameters.AddWithValue("@cust_name", objBOBuyerDetails.buyerName);
cmd.Parameters.AddWithValue("@dl_no", objBOBuyerDetails.buyerDLNo);
cmd.Parameters.AddWithValue("@tin_no", objBOBuyerDetails.buyerTinNo);
cmd.Parameters.AddWithValue("@addr1", objBOBuyerDetails.buyerAddr1);
cmd.Parameters.AddWithValue("@addr2", objBOBuyerDetails.buyerAddr2);
cmd.Parameters.AddWithValue("@contact_no", objBOBuyerDetails.buyerContactNo);
cmd.Parameters.AddWithValue("@email_id", objBOBuyerDetails.buyerEmailId);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string filePath = @"..\ErrorLog.log";
using (System.IO.StreamWriter writer = new StreamWriter(filePath, true))
{
writer.WriteLine("Error Code : 00016" + 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 int funcCheckDuplicateCust(BOBuyerDetails objBOCustDetails)
{
int retVal = objDAbuyerDL.funcCheckDuplicateCust(objBOCustDetails);
return(retVal);
}
public bool funcInsertCustDetails(BOBuyerDetails objBOCustDetails)
{
bool retVal = objDAbuyerDL.funcInsertCustDetails(objBOCustDetails);
return(retVal);
}
