private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (Validate())
{
BLSaleTransaction obj_Sale = new BLSaleTransaction();
if (temp == 1)
{
int SaleTransactionID = 0;
int MedicalShopID = Convert.ToInt32(cbMedical.SelectedValue);
MedID = MedicalShopID;
int UpdatedByUserID = 2;
//DateTime dt = Convert.ToDateTime(dtpDate.Text);
string SaleDate = dtpDate.Text;
string SaleTransactionNo = txtSaleTranNo.Text;
double DiscountAmount = 0;//Convert.ToDouble(txtDiscount.Text);
double BalanceAmount = 0;//Total - DiscountAmount;
string Result = obj_SaleTransaction.SaveSaleTransaction(SaleTransactionID, SaleTransactionNo, MedicalShopID, SaleDate, UpdatedByUserID, DiscountAmount, BalanceAmount);// WarehouseID,
if (Convert.ToInt32(Result) > 0)
{
rst = Convert.ToInt32(Result);
btnSave.Enabled = true;
//cbWarehouse.Enabled = false;
dtpDate.Enabled = false;
cbMedical.Enabled = false;
temp = 2;
}
else
{
MessageBox.Show("Record Not Added");
}
}
int WarehouseID = Convert.ToInt32(cbWarehouse.SelectedValue);
int ProductID = Convert.ToInt32(cbProduct.SelectedValue.ToString());
double SellingPrice = Convert.ToDouble(txtSellingPrice.Text);
double Quantity = Convert.ToDouble(txtQuantity.Text);
double Discount = 0;// Convert.ToDouble(txtDiscount.Text);
string result = obj_SaleTransaction.SaveSaleRecord(ProductID, Quantity, SellingPrice, Discount, rst, WarehouseID);
//Total = Total + (Quantity * SellingPrice);
//txtTotal.Text = Total.ToString();
Usp_BindSellTransactionGrid(rst);
DataTable dt2= obj_SaleTransaction.GetTempTotal(rst);
txtTotal.Text = dt2.Rows[0]["Total"].ToString();
Total = Convert.ToDouble(txtTotal.Text);
DataTable dtQty = obj_SaleTransaction.GetQtySumForManagerSaleTrans(rst, ProductID,WarehouseID);
if (dtQty.Rows.Count > 0)
{
TotQty = Convert.ToInt32(dtQty.Rows[0][0]);
}
clearFields();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void Usp_BindSellTransactionGrid(int SaleTransactionID)
{
DataTable dt = new DataTable();
BLSaleTransaction objBL = new BLSaleTransaction();
dt = objBL.BindFullGrid(SaleTransactionID);
if (dt.Rows.Count > 0)
{
dgvSellTransaction.DataSource = dt;
dgvSellTransaction.Refresh();
dgvSellTransaction.Show();
dgvSellTransaction.Columns["ProductID"].Visible = false;
dgvSellTransaction.Columns["Discount"].Visible = false;
dgvSellTransaction.AllowUserToAddRows = false;
dgvSellTransaction.AllowUserToDeleteRows = false;
}
}
public void getSellTransactionID()
{
BLSaleTransaction objSellTransactionDetails = new BLSaleTransaction();
DataTable dt = objSellTransactionDetails.getSellTransactionID();
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (string.IsNullOrEmpty(dt.Rows[i][j].ToString()))
{
}
else
{
}
}
}
}
private void Usp_BindSellTransactionGrid()
{
DataTable dt = null;
BLSaleTransaction objBL = new BLSaleTransaction();
dt = objBL.BindFullGrid();
if (dt.Rows.Count > 0)
{
dgvSellTransaction.DataSource = dt;
dgvSellTransaction.Refresh();
dgvSellTransaction.Show();
}
}
private void dgvSellTransaction_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvSellTransaction.SelectedRows.Count > 0)
{
cmbMedical.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[0].Value);
cmbDoctor.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[1].Value);
cmbProduct.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[2].Value);
int Medical = Convert.ToInt32(cmbMedical.SelectedValue);
int doctor = Convert.ToInt32(cmbDoctor.SelectedValue);
int product = Convert.ToInt32(cmbProduct.SelectedValue);
string Product = cmbProduct.Text;
BLSaleTransaction objSellTransaction = new BLSaleTransaction();
DataTable dt = objSellTransaction.GetSaleTransactionID(Medical,doctor,product);
if (dt.Rows.Count != 0)
{
lblSellTranid.Text = dt.Rows[0]["SalesTransactionID"].ToString();
}
txtSellingPrice.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[3].Value);
dtpDate.Text =Convert.ToString( dgvSellTransaction.SelectedRows[0].Cells[4].Value);
txtPreviousStock.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[5].Value);
txtUpdateStock.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[6].Value);
cbCountry.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[7].Value);
cbState.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[8].Value);
cbCity.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[9].Value);
txtArea.Text = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[10].Value);
string IsActive = Convert.ToString(dgvSellTransaction.SelectedRows[0].Cells[11].Value);
if (IsActive == "Yes")
{
chkActive.Checked = true;
}
else
{
chkActive.Checked = false;
}
btnSave.Text = "Update";
}
}
private void Usp_BindSellTransactionGrid(int SaleTransactionID)
{
DataTable dt = new DataTable();
BLSaleTransaction objBL = new BLSaleTransaction();
dt = objBL.BindFullGrid(SaleTransactionID);
if (dt.Rows.Count > 0)
{
dgvSellTransaction.DataSource = dt;
//dgvSellTransaction.Columns[0].HeaderCell.Value = "Medical Name";
////dgvSellTransaction.Columns[1].HeaderCell.Value = "Doctor Name";
//dgvSellTransaction.Columns[2].HeaderCell.Value = "Product Name";
//dgvSellTransaction.Columns[3].HeaderCell.Value = "Selling Price";
//dgvSellTransaction.Columns[4].HeaderCell.Value = "Date";
//dgvSellTransaction.Columns[5].HeaderCell.Value = "Quantity";
//dgvSellTransaction.Columns[6].HeaderCell.Value = "Warehouse";
////dgvSellTransaction.Columns[7].HeaderCell.Value = "Country";
////dgvSellTransaction.Columns[8].HeaderCell.Value = "State";
////dgvSellTransaction.Columns[7].HeaderCell.Value = "City";
////dgvSellTransaction.Columns[8].HeaderCell.Value = "Area";
dgvSellTransaction.Refresh();
dgvSellTransaction.Show();
dgvSellTransaction.Columns["ProductID"].Visible = false;
dgvSellTransaction.Columns["WarehouseID"].Visible = false;
dgvSellTransaction.Columns["Discount"].Visible = false;
dgvSellTransaction.AllowUserToAddRows = false;
dgvSellTransaction.AllowUserToDeleteRows = false;
}
else
{
dgvSellTransaction.DataSource = null;
dgvSellTransaction.Refresh();
dgvSellTransaction.Show();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (Validate())
{
BLSaleTransaction obj_Sale = new BLSaleTransaction();
if (temp == 1)
{
int SaleTransactionID = 0;
int MedicalShopID = Convert.ToInt32(cbMedical.SelectedValue);
MedID = MedicalShopID;
int UpdatedByUserID = 1;
//DateTime dt = Convert.ToDateTime(dtpDate.Text);
string SaleDate = dtpDate.Text;
string SaleTransactionNo = txtSaleTranNo.Text;
double DiscountAmount = 0;//Convert.ToDouble(txtDiscount.Text);
double BalanceAmount = 0;//Total - DiscountAmount;
string Result = obj_SaleTransaction.SaveSaleTransaction(SaleTransactionID, SaleTransactionNo, MedicalShopID, SaleDate, UpdatedByUserID, DiscountAmount, BalanceAmount);// WarehouseID,
if (Convert.ToInt32(Result) > 0)
{
rst = Convert.ToInt32(Result);
btnSave.Enabled = true;
// cbWarehouse.Enabled = false;
dtpDate.Enabled = false;
cbMedical.Enabled = false;
temp = 2;
}
else
{
MessageBox.Show("Record Not Added");
}
}
int WarehouseID = Convert.ToInt32(cbWarehouse.SelectedValue);
int ProductID = Convert.ToInt32(cbProduct.SelectedValue.ToString());
double SellingPrice = Convert.ToDouble(txtSellingPrice.Text);
double Quantity = Convert.ToDouble(txtQuantity.Text);
double Discount = 0;// Convert.ToDouble(txtDiscount.Text);
//string IsActive = "Yes";
//string IsDelete = "No";
string result = obj_SaleTransaction.SaveSaleRecord(ProductID, Quantity, SellingPrice, Discount, rst, WarehouseID);
//if (result == "1")
//{
// MessageBox.Show("Transactions Saved Successfully...");
Total = Total + (Quantity * SellingPrice);
txtTotal.Text = Total.ToString();
Usp_BindSellTransactionGrid(rst);
DataTable dtQty = obj_SaleTransaction.GetQtySumForManagerSaleTrans(rst, ProductID,WarehouseID);
if (dtQty.Rows.Count > 0)
{
TotQty = Convert.ToInt32(dtQty.Rows[0][0]);
}
clearFields();
//}
//else
//{
// //MessageBox.Show("This Product Name is Already Exits");
//}
//clearFields();
//}
//else
//{
// int SalesTransactionID = Convert.ToInt32(lblSaleTranID.Text);
// int ProductID = Convert.ToInt32(cbProduct.SelectedValue.ToString());
// double SellingPrice = Convert.ToDouble(txtSellingPrice.Text);
// double Quantity = Convert.ToDouble(txtQuantity.Text);
// string IsActive = "Yes";
// string IsDelete = "No";
// string result = obj_SaleTransaction.saveSaleTransaction(SalesTransactionID, ProductID, SellingPrice, Quantity, IsActive, IsDelete);
// if (result == "1")
// {
// MessageBox.Show("Record Updated successfully...");
// Usp_BindSellTransactionGrid();
// clearFields();
// lblSaleTranID.Text = "";
// }
// btnAdd.Text = "Save";
//}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
