public void GetTableDetails()
{
BAPurchaseMaster objPurchaseMaster = new BAPurchaseMaster();
DataTable dt = new DataTable();
dt = objPurchaseMaster.BAGetTable();
}
protected void Button1_Click(object sender, EventArgs e)
{
int validate = 0;
PurchaseEntities objPurchaseDetails = new PurchaseEntities();
try
{
objPurchaseDetails.PurchaseBillNo = Convert.ToInt32(PurchaseBillNo.Text);
objPurchaseDetails.PurchaseDate = PurchaseDate.Text;
objPurchaseDetails.VendorName = VendorName.Text;
objPurchaseDetails.MobileNo = MobileNo.Text;
objPurchaseDetails.EmailId = EmailId.Text;
objPurchaseDetails.GSTNo = Convert.ToInt32(GSTNo.Text);
objPurchaseDetails.CompanyName = Convert.ToString(CompanyName.Text);
objPurchaseDetails.Product = (Product.SelectedItem.Value);
objPurchaseDetails.Price = Convert.ToInt32(Price.Text);
objPurchaseDetails.Quantity = Convert.ToInt32(Quantity.Text);
objPurchaseDetails.GSTType = Convert.ToString(ddlGSTType.Text);
objPurchaseDetails.GSTPercentage = Convert.ToInt16(GSTPercentage.Text);
objPurchaseDetails.Total = Convert.ToInt16(Total.Text);
objPurchaseDetails.Transport = Transport.Text;
objPurchaseDetails.TotalAmount = Convert.ToInt32(TotalAmount.Text);
objPurchaseDetails.Discount = Convert.ToInt32(Discount.Text);
objPurchaseDetails.RupeesInWord = Convert.ToString(RupeesInWord.Text);
objPurchaseDetails.PaymentMethod = Convert.ToString(PaymentMethod.Text);
}
catch (Exception ex)
{
ex.ToString();
}
//BAL
BAPurchaseMaster objPurchaseMasterBA = new BAPurchaseMaster();
validate = objPurchaseMasterBA.BA_ValidatePurchase(objPurchaseDetails);
if (validate > 0)
{
Response.Write("<script> alert('Data already exist!')</script>");
}
else
{
int rValue = objPurchaseMasterBA.BAaddPurchaseDetails(objPurchaseDetails);
if (rValue > 0)
{
Response.Write("<script>alert('success')</script>");
GetTableDetails();
}
else
{
Response.Write("<script>alert('Error')</script>");
}
}
}
protected void Product_SelectedIndexChanged(object sender, EventArgs e)
{
string product;
DataTable dt = new DataTable();
PurchaseEntities objPurchaseDetails = new PurchaseEntities();
objPurchaseDetails.Product = Product.SelectedItem.Value;
BAPurchaseMaster objPurchaseMasterBA = new BAPurchaseMaster();
dt = objPurchaseMasterBA.BA_GetProductDetails(objPurchaseDetails);
foreach (DataRow dr in dt.Rows)
{
Price.Text = dr["SaleRate"].ToString();
GSTPercentage.Text = dr["GST"].ToString();
}
}
protected void VendorName_TextChanged1(object sender, EventArgs e)
{
//string vendorname;
DataTable dt = new DataTable();
PurchaseEntities objPurchaseDetails = new PurchaseEntities();
objPurchaseDetails.VendorName = VendorName.Text;
BAPurchaseMaster objPurchaseMasterBA = new BAPurchaseMaster();
dt = objPurchaseMasterBA.BA_GetVendorDetails(objPurchaseDetails);
foreach (DataRow dr in dt.Rows)
{
MobileNo.Text = dr["MobileNo"].ToString();
EmailId.Text = dr["EmailId"].ToString();
GSTNo.Text = dr["VendorGSTNo"].ToString();
CompanyName.Text = dr["CompanyName"].ToString();
}
}
