//get suplier details
#region METHOD TO Get Suplier Details for Purchase return
public PurchaseReturnBLL GetSuplierForPurchaseReturn(int keyword)
{
PurchaseReturnBLL prBLL = new PurchaseReturnBLL();
SqlConnection conn = new SqlConnection(myconnstrng);
DataTable dt = new DataTable();
try
{
string sql = "select * from Purchase_Transactions,Supplier_Master where Purchase_Transactions.Sup_ID = Supplier_Master.SupplierID and Purchase_Transactions.Purchase_ID = " + keyword;
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
conn.Open();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//p.Item_Code = dt.Rows[0]["Item_Code"].ToString();
prBLL.Sup_Name = dt.Rows[0]["CompanyName"].ToString();
prBLL.Sup_Contact = dt.Rows[0]["Phone_No"].ToString();
prBLL.Sup_Address = dt.Rows[0]["Address"].ToString();
prBLL.Sup_Email = dt.Rows[0]["Email"].ToString();
prBLL.Transaction_Type = dt.Rows[0]["Transaction_Type"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(prBLL);
}
public bool insertPurchaseReturn(PurchaseReturnBLL br, out int Invoice_No)
{
bool isSuccess = false;
Invoice_No = -1;
SqlConnection con = new SqlConnection(myconnstrng);
try
{
String sql = "INSERT INTO Purchase_Return_Transactions(Purchase_ID,Transaction_Type,Sup_ID,Sub_Total,TDiscount,TSGST,TCGST,TIGST,Grand_Total,Reson) VALUES(@Purchase_ID,@Transaction_Type,@Sup_ID,@Sub_Total,@TDiscount,@TSGST,@TCGST,@TIGST,@Grand_Total,@Reson);select @@IDENTITY;";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@Purchase_ID", br.Purchase_ID);
cmd.Parameters.AddWithValue("@Invoice_No", br.Invoice_No);
cmd.Parameters.AddWithValue("@Transaction_Type", br.Transaction_Type);
cmd.Parameters.AddWithValue("@Sup_ID", br.Sup_ID);
cmd.Parameters.AddWithValue("@Sub_Total", br.Sub_Total);
cmd.Parameters.AddWithValue("@TDiscount", br.TDiscount);
cmd.Parameters.AddWithValue("@TSGST", br.TSGST);
cmd.Parameters.AddWithValue("@TCGST", br.TCGST);
cmd.Parameters.AddWithValue("@TIGST", br.TIGST);
cmd.Parameters.AddWithValue("@Grand_Total", br.Grand_Total);
cmd.Parameters.AddWithValue("@Reson", br.Reson);
con.Open();
object o = cmd.ExecuteScalar();
if (o != null)
{
isSuccess = true;
Invoice_No = int.Parse(o.ToString());
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(isSuccess);
}
private void comboPurchaseID_SelectedIndexChanged(object sender, EventArgs e)
{
int PurchaseID;
int.TryParse(comboPurchaseID.Text, out PurchaseID);
PurchaseReturnBLL crBLL = PurchaseReturnDAL.GetSuplierForPurchaseReturn(PurchaseID);
comboPurchaseType.Text = crBLL.Transaction_Type;
textSupplierName.Text = crBLL.Sup_Name;
textContact.Text = crBLL.Sup_Contact;
textEmail.Text = crBLL.Sup_Email;
textAddress.Text = crBLL.Sup_Address;
comboItemName.DataSource = null;
DataTable dti = PurchaseReturnDetailsDAL.SelectItemName(PurchaseID);
comboItemName.DisplayMember = "Product_Name";
comboItemName.Items.Add("Select Product Name");
comboItemName.DataSource = dti;
PClear();
}
