public int funcCheckDuplicateSup(BOSuppDetails objSupDetails)
{
objDB_Utility = new DB_Utility();
SqlConnection con = objDB_Utility.funcOpenConnection();
SqlCommand cmd = new SqlCommand("SELECT count(*) FROM supplier_master WHERE UPPER(supp_name)=UPPER(@supp_name)", con);
cmd.Parameters.AddWithValue("@supp_name", objSupDetails.suppName);
int retVal = Convert.ToInt32(cmd.ExecuteScalar());
return(retVal);
}
public DataTable funcPopulateSupplierGrid(BOSuppDetails objSupDetails)
{
string condition;
string strSearchBy = "";
if (objSupDetails.searchBy == "Supplier ID")
{
strSearchBy = "supp_id";
}
else if (objSupDetails.searchBy == "Supplier Name")
{
strSearchBy = "supp_name";
}
else if (objSupDetails.searchBy == "Contact Number")
{
strSearchBy = "contact_no";
}
else if (objSupDetails.searchBy == "DL Number")
{
strSearchBy = "DL_no";
}
else if (objSupDetails.searchBy == "TIN Number")
{
strSearchBy = "TIN_no";
}
if (objSupDetails.searchTerm != "" && objSupDetails.searchBy != "")
{
condition = "WHERE ";
condition += strSearchBy;
condition += " like '";
condition += objSupDetails.searchTerm;
condition += "%'";
}
else
{
condition = "";
}
DataTable dt = new DataTable();
dt = objDALSuppDetails.funcPopulateSupplierGrid(condition);
return(dt);
}
public bool funcInsertSupDetails(BOSuppDetails objBOSupDetails)
{
try
{
//Initialization
objDB_Utility = new DB_Utility();
SqlConnection con = objDB_Utility.funcOpenConnection();
SqlCommand cmd = new SqlCommand("sp_insertSupDetails", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
//Code to Insert Supplier Details Data into Database using stored procedure
cmd.Parameters.AddWithValue("@sup_id", 0);
cmd.Parameters.AddWithValue("@sup_name", objBOSupDetails.suppName);
cmd.Parameters.AddWithValue("@dl_no", objBOSupDetails.dlNo);
cmd.Parameters.AddWithValue("@tin_no", objBOSupDetails.tinNo);
cmd.Parameters.AddWithValue("@addr1", objBOSupDetails.addr1);
cmd.Parameters.AddWithValue("@addr2", objBOSupDetails.addr2);
cmd.Parameters.AddWithValue("@contact_no", objBOSupDetails.contactNo);
cmd.Parameters.AddWithValue("@email_id", objBOSupDetails.emailId);
cmd.Parameters.AddWithValue("@modified_date_time", System.DateTime.Today);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string filePath = @"..\ErrorLog.log";
using (System.IO.StreamWriter writer = new StreamWriter(filePath, true))
{
writer.WriteLine("Error Code : 00001" + 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 funcCheckDuplicateSup(BOSuppDetails objBOSupDetails)
{
int retVal = objDALSuppDetails.funcCheckDuplicateSup(objBOSupDetails);
return(retVal);
}
public bool funcInsertSupDetails(BOSuppDetails objBOSuppDetails)
{
bool retVal = objDALSuppDetails.funcInsertSupDetails(objBOSuppDetails);
return(retVal);
}
