public DataTable SearchValue()
{
try
{
query = " select [Contract_month_start],[Contract_month_end],[Contract_payment_term],[Contract_Delievery_term],[Contract_loom_size],[Contract_no_of_looms],[Contract_item_name],[Contract_description],[Contract_Rate_per_Mtr],[Contract_Total_cost],[Contract_Remarks] from Contract1";
DataTable dt = new DataTable();
dt = sql.Search(query);
return(dt);
}
catch (Exception ex)
{
return(null);
}
}
public DataTable LoadItemName()
{
try
{
query = "select IGC_Brand from Item_GreyCloth";
dt = new DataTable();
dt = sql.Search(query);
return(dt);
}
catch (Exception ex)
{
return(null);
}
}
public string LoadBuyerID(string buyerName)
{
try
{
query = "select Buyer_ID from Buyer where Buyer_Name = '" + buyerName + "'";
dt = new DataTable();
dt = sql.Search(query);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][0].ToString());
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}