public ChallanReturnBLL GetCustomerForChallanReturn(int keyword)
{
ChallanReturnBLL crBLL = new ChallanReturnBLL();
SqlConnection conn = new SqlConnection(myconnstrng);
DataTable dt = new DataTable();
try
{
string sql = "select * from Challan_Transactions,Cust_Master where Challan_Transactions.Cust_ID = Cust_Master.Cust_Id and Challan_Transactions.Invoice_No = " + 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();
crBLL.Cust_Name = dt.Rows[0]["Cust_Name"].ToString();
crBLL.Cust_Contact = dt.Rows[0]["Cust_Contact"].ToString();
crBLL.Cust_Address = dt.Rows[0]["Cust_Address"].ToString();
crBLL.Cust_Email = dt.Rows[0]["Cust_Email"].ToString();
crBLL.Transaction_Type = dt.Rows[0]["Transaction_Type"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(crBLL);
}
public bool insertSalesReturn(ChallanReturnBLL cr, out int Invoice_No)
{
bool isSuccess = false;
Invoice_No = -1;
SqlConnection con = new SqlConnection(myconnstrng);
try
{
String sql = "INSERT INTO SalesReturn_Transactions(SalesID,Transaction_Type,Cust_ID,Sub_Total,TDiscount,TSGST,TCGST,TIGST,Grand_Total,Reson) VALUES(@SalesID,@Transaction_Type,@Cust_ID,@Sub_Total,@TDiscount,@TSGST,@TCGST,@TIGST,@Grand_Total,@Reson);select @@IDENTITY;";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@SalesID", cr.SalesID);
cmd.Parameters.AddWithValue("@Invoice_No", cr.Invoice_No);
cmd.Parameters.AddWithValue("@Transaction_Type", cr.Transaction_Type);
cmd.Parameters.AddWithValue("@Cust_ID", cr.Cust_ID);
cmd.Parameters.AddWithValue("@Sub_Total", cr.Sub_Total);
cmd.Parameters.AddWithValue("@TDiscount", cr.TDiscount);
cmd.Parameters.AddWithValue("@TSGST", cr.TSGST);
cmd.Parameters.AddWithValue("@TCGST", cr.TCGST);
cmd.Parameters.AddWithValue("@TIGST", cr.TIGST);
cmd.Parameters.AddWithValue("@Grand_Total", cr.Grand_Total);
cmd.Parameters.AddWithValue("@Reson", cr.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 comboInvoiceNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboInvoiceNo.Text != "Select Invoice No")
{
int invoceNo;
int.TryParse(comboInvoiceNo.Text, out invoceNo);
ChallanReturnBLL crBLL = ChallanReturnDAL.GetCustomerForChallanReturn(invoceNo);
comboTransactionType.Text = crBLL.Transaction_Type;
textCust_Name.Text = crBLL.Cust_Name;
textContact.Text = crBLL.Cust_Contact;
textEmail.Text = crBLL.Cust_Email;
textAddress.Text = crBLL.Cust_Address;
comboItemName.DataSource = null;
DataTable dti = ChallanReturnDetailsDAL.SelectItemName(invoceNo);
comboItemName.DisplayMember = "Product_Name";
comboItemName.Items.Add("Select Product Name");
comboItemName.DataSource = dti;
InvoiceClear();
}
}
