public bool Delete(transactionDetailBLL c)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "DELETE FROM tbl_transaction_detail WHERE Id=@Id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Id", c.Id);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSucces);
}
public bool UpdateTransactionDetail(transactionDetailBLL td)
{
//Create a boolean value and set its default value to false
bool isSuccess = false;
//Create a database connection here
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//Sql Query to Insert Transaction detais
string sql = "UPDATE tbl_transaction_detail set product_id = " + td.product_id + ", transaction_id = " + td.transastion_id + ", rate = " + td.rate + ", qty = " + td.qty + ", discount = " + td.discount + ", total = " + td.total + ", dea_cust_id = " + td.dea_cust_id + ", added_date = '" + td.added_date.ToString("MM/dd/yyyy HH:mm:ss.fff") + "', added_by = '" + td.added_by + "' WHERE id = " + 2 + "";
//Passing the value to the SQL Query
SqlCommand cmd = new SqlCommand(sql, conn);
////Passing the values using cmd
//cmd.Parameters.AddWithValue("@product_id", );
//cmd.Parameters.AddWithValue("@transaction_id", );
//cmd.Parameters.AddWithValue("@rate", );
//cmd.Parameters.AddWithValue("@qty", );
//cmd.Parameters.AddWithValue("@discount", );
//cmd.Parameters.AddWithValue("@total", );
//cmd.Parameters.AddWithValue("@dea_cust_id", );
//cmd.Parameters.AddWithValue("@added_date", );
//cmd.Parameters.AddWithValue("@added_by", );
//Open Database connection
conn.Open();
//declare the int variable and execute the query
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
//Query Executed Successfully
isSuccess = true;
}
else
{
//FAiled to Execute Query
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
//Close Database Connection
conn.Close();
}
return(isSuccess);
}
public bool InsertTransactionDetail(transactionDetailBLL td)
{
//create Sql connection first
SqlConnection conn = new SqlConnection(myconnstrng);
//create a boolean Value and set it default Value to false
bool isSuccess = false;
try
{
//Create SQL quary to Insert Detail of Dea_Cust table in database
string sql = "INSERT INTO tbl_transaction_detail (product_id, rate, qty, total, dea_cust_id, added_date, added_by) VALUES (@product_id, @rate, @qty, @total, @dea_cust_id, @added_date, @added_by)";
//create SQL Command to Execute the Quary
SqlCommand cmd = new SqlCommand(sql, conn);
//Passing the value using parameter
cmd.Parameters.AddWithValue("@product_id", td.product_id);
cmd.Parameters.AddWithValue("@rate", td.rate);
cmd.Parameters.AddWithValue("@qty", td.qty);
cmd.Parameters.AddWithValue("@total", td.total);
cmd.Parameters.AddWithValue("@dea_cust_id", td.dea_cust_id);
cmd.Parameters.AddWithValue("@added_date", td.added_date);
cmd.Parameters.AddWithValue("@added_by", td.added_by);
//opening datsbase connection
conn.Open();
//create Integer variable to check if the quary is executed or not
int rows = cmd.ExecuteNonQuery();
//If the quary executed Successfully the value of rows will be greater 0 else it will less than 0.
if (rows > 0)
{
//Quary is Executed Successfully
isSuccess = true;
}
else
{
//failed to execute the Quary
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool InsertTransactionDetail(transactionDetailBLL td)
{
//Creating a bool value and setting its default value to false
bool isSuccess = false;
//Create SqlConnection
SqlConnection conn = new SqlConnection(myconnstring);
try
{
//Query to insert transaction
string sql = "INSERT INTO tbl_transaction_detail (product_id,rate,qty,total,dea_cust_id,added_date,added_by) VALUES(@product_id,@rate,@qty,@total,@dea_cust_id,@added_date,@added_by,@added_by)";
//Sql command pass the value in sql query
SqlCommand cmd = new SqlCommand(sql, conn);
//Passing Values through parameterd
cmd.Parameters.AddWithValue("@product_id", td.product_id);
cmd.Parameters.AddWithValue("@rate", td.rate);
cmd.Parameters.AddWithValue("@qty", td.qty);
cmd.Parameters.AddWithValue("@total", td.total);
cmd.Parameters.AddWithValue("@dea_cust_id", td.dea_cust_id);
cmd.Parameters.AddWithValue("@added_date", td.added_date);
cmd.Parameters.AddWithValue("@added_by", td.added_by);
//Open Database Connection
conn.Open();
//Creating the int Variable to execute query
int rows = cmd.ExecuteNonQuery();
//If the query is executed successfully then its value will be greater than 0 else it will be less than 0
if (rows > 0)
{
//Query Executed Succesfully
isSuccess = true;
}
else
{
//Failed to execute
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool InsertTransactionDetail(transactionDetailBLL transactionDetail)
{
//Create a boolean value and set its default value to false
bool isSuccess = false;
//Create a sqlConnection first
SqlConnection connection = new SqlConnection(myconnectingstring);
try
{
//SQL Query to insert transactions
string sql = "INSERT INTO tbl_transaction_detail (product_id, rate, qty, total, customer_name, added_date, added_by)" +
"VALUES (@product_id, @rate, @qty, @total, @customer_name, @added_date, @added_by)";
//SQL command to pass the value in the sql query
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddWithValue("@product_id", transactionDetail.product_id);
cmd.Parameters.AddWithValue("@rate", transactionDetail.rate);
cmd.Parameters.AddWithValue("@qty", transactionDetail.qty);
cmd.Parameters.AddWithValue("@total", transactionDetail.total);
cmd.Parameters.AddWithValue("@customer_name", transactionDetail.customer_name);
cmd.Parameters.AddWithValue("@added_date", transactionDetail.added_date);
cmd.Parameters.AddWithValue("@added_by", transactionDetail.added_by);
//Open database connection
connection.Open();
//Execute the query
int rows = cmd.ExecuteNonQuery();
//If the query is executed successfully then the value will not be null else it will be null
if (rows > 0)
{
// Query executed successfully;
isSuccess = true;
}
else
{
// Failed to execute query
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
//Close the connection
connection.Close();
}
return(isSuccess);
}
public bool InsertTransactionDetail(transactionDetailBLL td)
{
//Create a boolean value and set its default value to false
bool isSuccess = false;
//Create a database connection here
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//Sql Query to Insert Transaction detais
string sql = "INSERT INTO tbl_transaction_detail (product_id, transaction_id, rate, qty, discount, total, dea_cust_id, added_date, added_by) VALUES (@product_id, @transaction_id, @rate, @qty, @discount, @total, @dea_cust_id, @added_date, @added_by)";
//Passing the value to the SQL Query
SqlCommand cmd = new SqlCommand(sql, conn);
//Passing the values using cmd
cmd.Parameters.AddWithValue("@product_id", td.product_id);
cmd.Parameters.AddWithValue("@transaction_id", td.transastion_id);
cmd.Parameters.AddWithValue("@rate", td.rate);
cmd.Parameters.AddWithValue("@qty", td.qty);
cmd.Parameters.AddWithValue("@discount", td.discount);
cmd.Parameters.AddWithValue("@total", td.total);
cmd.Parameters.AddWithValue("@dea_cust_id", td.dea_cust_id);
cmd.Parameters.AddWithValue("@added_date", td.added_date);
cmd.Parameters.AddWithValue("@added_by", td.added_by);
//Open Database connection
conn.Open();
//declare the int variable and execute the query
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
//Query Executed Successfully
isSuccess = true;
}
else
{
//FAiled to Execute Query
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
//Close Database Connection
conn.Close();
}
return(isSuccess);
}
public bool InsertTransactionDetail(transactionDetailBLL td)
{
//create a boolean value and set its default value to false
bool isSuccess = false;
//create database connection
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//sql query to insert transaction details
string sql = "INSERT INTO tbl_transaction_detail (product_id, rate, qty, total, dea_cust_id, added_by) VALUES (@product_id, @rate, @qty, @total, @dea_cust_id, @added_by)";
//passing the value to sql query
SqlCommand cmd = new SqlCommand(sql, conn);
//passing the values using cmd
cmd.Parameters.AddWithValue("@product_id", td.product_id);
cmd.Parameters.AddWithValue("@rate", td.rate);
cmd.Parameters.AddWithValue("@qty", td.qty);
cmd.Parameters.AddWithValue("@total", td.total);
cmd.Parameters.AddWithValue("@dea_cust_id", td.dea_cust_id);
cmd.Parameters.AddWithValue("@added_date", td.added_date);
cmd.Parameters.AddWithValue("@added_by", td.added_by);
//open database connection
conn.Open();
//declare the int variable and execute the query
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
//query executed successfully
isSuccess = true;
}
else
{
//fILED to execute the query
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
//close database connection
conn.Close();
}
return(isSuccess);
}
public bool Insert_TransactionDetail(transactionDetailBLL td)
{
//Create a bool and set the value to false
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "INSERT into dbo.transactionDetail(subscriptionid, price, quantity, total, dealer_cust_id, addedDate, addedBy) Values(@subscriptionid, @price, @quantity, @total, @dealer_cust_id, @addedDate, @addedBy)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@subscriptionid", td.subscriptionid);
cmd.Parameters.AddWithValue("@price", td.price);
cmd.Parameters.AddWithValue("@quantity", td.quantity);
cmd.Parameters.AddWithValue("@total", td.total);
cmd.Parameters.AddWithValue("@dealer_cust_id", td.dealer_cust_id);
cmd.Parameters.AddWithValue("@addedDate", td.addedDate);
cmd.Parameters.AddWithValue("@addedBy", td.addedBy);
//open database connection
conn.Open();
//execute the query
int rows = cmd.ExecuteNonQuery();
//id the query is execute successfully then the value will not be null, else it will be null
if (rows > 0)
{// Queryable executed successfully
isSuccess = true;
}
else
{
//failed to execute query
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool InsertTransactionDetail(transactionDetailBLL td)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "INSERT INTO tbl_transaction_detail (product_id, rate, qty, total, dea_cust_id, added_date, added_by) VALUES (@product_id, @rate, @qty, @total, @dea_cust_id, @added_date, @added_by)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@product_id", td.product_id);
cmd.Parameters.AddWithValue("@rate", td.rate);
cmd.Parameters.AddWithValue("@qty", td.qty);
cmd.Parameters.AddWithValue("@total", td.total);
cmd.Parameters.AddWithValue("@dea_cust_id", td.dea_cust_id);
cmd.Parameters.AddWithValue("@added_date", td.added_date);
cmd.Parameters.AddWithValue("@added_by", td.added_by);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
private void btnSave_Click(object sender, EventArgs e)
{
//get the values from purchaseSales form first
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
//get the id of dealer and customer here
//lets get name of dealer or customer first
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIdFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
//get the username of looged in user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
bool success = false;
//actual code to insert transaction and transaction detail
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//create boolean value and insert transaction
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
//use for loop to insert transaction details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
// get all the details of the product
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//get the product name and convert it to id
string ProductName = transactionDT.Rows[i][1].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][3].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][4].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
//here increse or decrease product qty based on purchase or sale
string transactionType = lblTop.Text;
//lets check whether we are on purchase or sale form
bool x = false;
if (transactionType == "Purchase")
{
//Increase the product
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
//Decrease the product qty
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//insert transactiondetail inside the database
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
//Transaction complete
scope.Complete();
//code to print bill
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\n\r\n GKN INVENTORY PVT.LTD.\r\n\r\n";
printer.SubTitle = "Kolkata, WestBengal \r\n Phone:+91-9765XXXXXX\r\n\r\n";
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumbers = true;
printer.PageNumberInHeader = false;
printer.PorportionalColumns = true;
printer.HeaderCellAlignment = StringAlignment.Near;
printer.Footer = "Discount: " + txtDiscount.Text + "% \r\n" + "VAT: " + txtVat.Text + "% \r\n" + "Grand Total: Rs. " + txtGrandTotal.Text + "\r\n\r\n" + "Thank you For doing business with us.";
printer.FooterSpacing = 15;
printer.PrintDataGridView(dgvAddedProducts);
MessageBox.Show("Transaction Completed Successfully.");
//clear the data grid view and clear all the textboxes
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtSearchProduct.Text = "";
txtproductid.Text = "";
txtProductName.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
txtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
//Transaction failed
MessageBox.Show("Transaction Failed.");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIdFromName(deaCustName);
transaction.dea_cust_id = dc.Id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIdFromUsername(username);
transaction.added_by = u.Id;
transaction.transactionDetails = transactionDT;
bool success = false;
using (TransactionScope scope = new TransactionScope())
{
int transactionId = -1;
bool w = tDAL.Insert_Transaction(transaction, out transactionId);
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
transactionDetailBLL transactionDetail = new transactionDetailBLL();
string productName = transactionDT.Rows[i][0].ToString();
productsBLL p = pdal.GetProductIdFromName(productName);
transactionDetail.product_id = p.Id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.Id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.Id;
string transactionType = lblTop.Text;
bool x = false;
if (transactionType == "PURCHASE")
{
x = pdal.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "SALES")
{
x = pdal.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
scope.Complete();
MassageBox mb = new MassageBox("Transaction Success", MsgType.success);
mb.Show();
//MessageBox.Show("Transaction Completed Successfully...");
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtSearchProduct.Text = "";
txtNamePro.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
txtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
MassageBox mb = new MassageBox("Transaction Failed", MsgType.retry);
mb.Show();
//MessageBox.Show("Transaction Failed...!!! Try again");
}
}
}catch (Exception)
{
MassageBox mb = new MassageBox("ERROR", MsgType.clear);
mb.BackColor = Color.Crimson;
mb.Show();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
// Get the values from Purchase and Sales form first
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
// Get the ID of Dealer or Customer here
// Get the name of Dealer or customer first
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
// get the username of the loggedin user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
// boolean variable and set it to false
bool success = false;
// insert transaction and transaction Details
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//create a boolean value and insert transaction
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
// loop to insert transaction details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
// get all the details of the product
transactionDetailBLL transactionDetail = new transactionDetailBLL();
// get product name and convert it to id
string ProductName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
// increase/decrease product Quantity based on purchase or sells
string transactionType = lblTop.Text;
// check if we are on purchase or sales page
bool x = false;
if (transactionType == "Purchase")
{
// increase the product qty
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
// decrease product quantity
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//insert transaction details in the database
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
//Transaction complete
scope.Complete();
// print the bill
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\n\r\n SOPHIE'S STORE PVT. LTD. \r\n\r\n";
printer.SubTitle = "Bellevue, Washington \r\n Phone: 425-xxx-xxxx \r\n\r\n";
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumbers = true;
printer.PageNumberInHeader = false;
printer.PorportionalColumns = true;
printer.HeaderCellAlignment = StringAlignment.Near;
//limit grand total to 2 decimal values
decimal GTTwoDecimal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
printer.Footer = "Discount: " + txtDiscount.Text + "% \r\n" + "VAT: " + txtVat.Text + "%\r\n" + "Grand Total: " + GTTwoDecimal.ToString() + "\r\n" + "Thank you for doing buisness with us!";
printer.FooterSpacing = 15;
printer.PrintDataGridView(dgvAddedProducts);
MessageBox.Show("Transaction completed Successfully.");
//clear the data grid view and text boxes
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtSearchProduct.Text = "";
txtProductName.Text = "";
txtInventory.Text = "";
txtRate.Text = "";
txtQty.Text = "";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
//Transaction Failed
MessageBox.Show("Transaction Failed.");
}
}
}
private void BtnCalcSave_Click(object sender, EventArgs e)
{
try
{
//Get the values from PurchaseSales Form
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblPurchasesAndSales.Text;
//Get the id and name of dealer or customer
string deaCustName = tbName.Text;
DeaCusBLL dc = dcDAL.GetDeaCusIdFromName(deaCustName);
transaction.deal_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(tbGrandTotal.Text), 2);
transaction.transactionDate = DateTime.Now;
transaction.tax = decimal.Parse(tbVat.Text);
transaction.discount = decimal.Parse(tbDiscount.Text);
//get the username of logged in user
string username = Login.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.addedBy = u.id;
transaction.transactionDetails = transactionDT;
//create a boolean and set value
bool success = false;
//Insert transaction in table
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//create a bool value and insert transaction
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//Get all the details of the subscription
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//convert subscription Name to id
string name = transactionDT.Rows[i][0].ToString();
subscriptionsBLL p = pDAL.GetSubscriptionIDFromName(name);
transactionDetail.subscriptionid = p.id;
transactionDetail.price = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.quantity = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dealer_cust_id = dc.id;
transactionDetail.addedDate = DateTime.Now;
transactionDetail.addedBy = u.id;
//change quantity based on sales or purchases
string transactionType = lblPurchasesAndSales.Text;
//Create a bool and check for type of transaction
bool x = false;
if (transactionType == "Purchase")
{
x = pDAL.IncreaseProduct(transactionDetail.subscriptionid, transactionDetail.quantity);
}
else if (transactionType == "Sales")
{
//Decrease the Product Quantity
x = pDAL.DecreaseProduct(transactionDetail.subscriptionid, transactionDetail.quantity);
}
//Insert transaction Details
bool y = tdDAL.Insert_TransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
scope.Complete();
//Print Bill
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\n\r\n Flava Solutions Gymn MGMT. LTD. \r\n\r\n";
printer.SubTitle = "Angels, Spanish Town \r\n Phone: 876-619-1097 - 99 \r\n\r\n";
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumbers = true;
printer.PageNumberInHeader = false;
printer.PorportionalColumns = true;
printer.HeaderCellAlignment = StringAlignment.Near;
printer.Footer = "Discount: " + tbDiscount.Text + "% \r\n" + "VAT: " + tbVat.Text + "% \r\n" + "Grand Total: " + tbGrandTotal.Text + "\r\n\r\n" + "Thank you for doing business with us.";
printer.FooterSpacing = 15;
printer.PrintDataGridView(dgvPurchases);
MessageBox.Show("Transaction Completed Successfully");
//Clear datagrid view
dgvPurchases.DataSource = null;
dgvPurchases.Rows.Clear();
Clear1();
}
else
{
//transaction Failed
MessageBox.Show("Transaction Failed");
}
}
}
finally
{
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//Get the values from form purchase Sales form First
// we will create an objetct of Transactions Class
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
// Get the ID of Dealer or Customer Here
// Lets get name of the dealer or customer first
string deaCustName = txtName.Text;
// here we have first written method in DeaCustDAL and now forwarding as
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
//Now we will refer the transaction
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
// Get the user name,for added by, get the user name
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
// we need to passthistransaction
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
//Lets create a Boolean variable and set its value to False
bool success = false;
//Actual Code to Insert Transaction and Transaction Details
using (TransactionScope scope = new TransactionScope())
{
int transactionID = 1;
//Create a Boolean value and Insert Transaction
bool w = tDAL.Insert_Transcation(transaction, out transactionID);
//Use for loop to insert transaction details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
// create all details of products
transactionDetailBLL transactionDetail = new transactionDetailBLL();
// Get the product name and convert it to ID
string productName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetproductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
// Here we will increase or decrease the quantity based on purchase or sales
// we have created Methods to Increase and decrease Qty.
// Here Increase or Decrease Product Qty based on Purchase or Sales
// we wil lspecify it is Sales or Purchase. we wil lcreate a string variable
string transactionType = lblTop.Text;
//Lets Check we are on Purchase or Sales
bool x = false;
if (transactionType == "Purchase")
{
//Increase the product
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
//Decrease the Product Qty
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//Insert Transaction Details Inside the Database
bool y = tdDAL.InsertTranscationDetail(transactionDetail);
success = w && y && x;
}
if (success == true)
{
// transaction complete
scope.Complete();
MessageBox.Show("Transaction completed Successfully");
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtSearchProduct.Text = "";
txtProductName.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
txtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
MessageBox.Show("This Transaction Has Not Been Completed and Failed");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
//get the details purchase from the for textboxes
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
//get the id of dealer or customer
//get the name of the dealer or customer
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
//get the username of logged in user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
//create a boolean variable and set its value to false
bool success = false;
//code to INSert TRansaction and Transaction details
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//create a boolean value and insert transaction
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
//use for loop to inser transaction details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//get all the details of the roduct
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//get the product name and convert it to ID
string productName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(productName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
//Increase or Decrease Product Qty based on purchase or sales
string transactionType = lblTop.Text;
//check whether its on purchase or sale
bool x = false;
if (transactionType == "Purchase")
{
//increse the product qty
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
//decrease the product qty
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//Insert Transaction details inside the database
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
//Transaction comlete
scope.Complete();
MessageBox.Show("Transaction Completed Successfully!");
//clear the data grid view and clear all he textboxes
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtAddress.Text = "";
txtContact.Text = "";
txtSearchProduct.Text = "";
txtProductName.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
txtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0"; //////////0
txtGrandTotal.Text = "0";
txtVat.Text = "0"; /////////0
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
//Transaction failed
MessageBox.Show("Transaction Failed!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIdFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
bool success = false;
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
transactionDetailBLL transactionDetail = new transactionDetailBLL();
string ProductName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
string transactionType = lblTop.Text;
bool x = false;
if (transactionType == "Purchase")
{
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
scope.Complete();
//Code to Print Bill
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\n\r\n TEAM ANTIVIRUS PVT. LTD. \r\n\r\n";
printer.SubTitle = "Dhaka, Bangladesh \r\n Phone: 017xxxxxxxx \r\n\r\n";
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumbers = true;
printer.PageNumberInHeader = false;
printer.PorportionalColumns = true;
printer.HeaderCellAlignment = StringAlignment.Near;
printer.Footer = "Discount: " + txtDiscount.Text + "% \r\n" + "VAT:" + txtVat.Text + "% \r\n" + "Grand Total:" + txtGrandTotal.Text + "\r\n\r\n" + "Thank You";
printer.FooterSpacing = 15;
printer.PrintDataGridView(pnldataGridView);
MessageBox.Show("Transaction Completed Successfully");
pnldataGridView.DataSource = null;
pnldataGridView.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtProductSearch.Text = "";
txtProductName.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
txtVat.Text = "0";
txtQty.Text = "0";
txtSubTotal.Text = "0";
txtGrandTotal.Text = "0";
txtDiscount.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
MessageBox.Show("Transaction Failed");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
bool success = false;
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
transactionDetailBLL transactionDetail = new transactionDetailBLL();
string ProductName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
string transactionType = lblTop.Text;
bool x = false;
if (transactionType == "Purchase")
{
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
scope.Complete();
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\n\r\n ANYSTORE PVT. LTD. \r\n\r\n";
printer.SubTitle = "Kathmandu, Nepal \r\n Phone: 01-045XXXX \r\n\r\n";
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumbers = true;
printer.PageNumberInHeader = false;
printer.PorportionalColumns = true;
printer.HeaderCellAlignment = StringAlignment.Near;
printer.Footer = "Discount: " + txtDiscount.Text + "% \r\n" + "VAT: " + txtVat.Text + "% \r\n" + "Grand Total: " + txtGrandTotal.Text + "\r\n\r\n" + "Thank you for doing business with us.";
printer.FooterSpacing = 15;
printer.PrintDataGridView(dgvAddedProducts);
MessageBox.Show("ทำการบันทึกข้อมูลการซือ ขาย เรียบร้อยแล้ว");
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtSearchProduct.Text = "";
txtProductName.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
TxtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
MessageBox.Show("ไม่สามารถทำการบันทึกการซื้อ ขายได้! กรุณาลองใหม่อีกครั้ง");
}
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
//validation
if (decimal.Parse("0" + txtCheque.Text) > 0 && txtChequeNo.Text.Length < 2)
{
MessageBox.Show("Please enter a cheque no.");
}
//to do cancell bills
//Get the Values from PurchaseSales Form First
transactionsBLL transaction = new transactionsBLL();
if (lblTop.Text == "Sales")
{
transaction.type = "CRN";
}
else if (lblTop.Text == "Purchase")
{
transaction.type = "RTS";
}
//Get the ID of Dealer or Customer Here
//Lets get name of the dealer or customer first
string deaCustName = cmbCustomer.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
//transaction.invoice_no = decimal.Parse(txtInvoiceNo.Text);
transaction.invoice_no = decimal.Parse(tDAL.GetNextInvoiceNo(transaction.type).ToString());
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse("0" + txtGrandTotal.Text), 2);
transaction.transaction_date = dtpBillDate.Value;
transaction.tax = decimal.Parse("0" + txtVat.Text);
transaction.discount = decimal.Parse("0" + txtDiscount.Text);
transaction.cash = decimal.Parse("0" + txtCash.Text);
transaction.card = decimal.Parse("0" + txtCard.Text);
transaction.cheque = decimal.Parse("0" + txtCheque.Text);
transaction.cheque_no = decimal.Parse("0" + txtChequeNo.Text);
//Get the Username of Logged in user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
//Lets Create a Boolean Variable and set its value to false
bool success = false;
//Actual Code to Insert Transaction And Transaction Details
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//Create aboolean value and insert transaction
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
//Use for loop to insert Transaction Details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//Get all the details of the product
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//Get the Product name and convert it to id
string ProductName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.transastion_id = transactionID;
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][3].ToString());
transactionDetail.discount = decimal.Parse(transactionDT.Rows[i][4].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][5].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
//Here Increase or Decrease Product Quantity based on Purchase or sales
string transactionType = lblTop.Text;
//Lets check whether we are on Purchase or Sales
bool x = false;
if (transactionType == "Purchase")
{
//Decrease the Product coz RTS
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
//Increase the Product Quntiyt coz CRN
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//Insert Transaction Details inside the database
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
tDAL.UpdateInvNo(decimal.Parse(tDAL.GetNextInvoiceNo(transaction.type).ToString()), transaction.type);
//tDAL.UpdateInvNo(decimal.Parse(txtInvoiceNo.Text), transaction.type);
//update grand total
if (success == true)
{
////////////frmReport r = new frmReport();
////////////r.DocId = 1;
////////////r.TrID = transactionID;
////////////r.ShowDialog();
//Transaction Complete
scope.Complete();
//Code to Print Bill
//to do print bills
//DGVPrinter printer = new DGVPrinter();
//printer.Title = "\r\n\r\n\r\n ANYSTORE PVT. LTD. \r\n\r\n";
//printer.SubTitle = "Kathmandu, Nepal \r\n Phone: 01-045XXXX \r\n\r\n";
//printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
//printer.PageNumbers = true;
//printer.PageNumberInHeader = false;
//printer.PorportionalColumns = true;
//printer.HeaderCellAlignment = StringAlignment.Near;
//printer.Footer = "Discount: " + txtDiscount.Text + "% \r\n" + "VAT: " + txtVat.Text + "% \r\n" + "Grand Total: " + txtGrandTotal.Text + "\r\n\r\n" + "Thank you for doing business with us.";
//printer.FooterSpacing = 15;
//printer.PrintDataGridView(dgvAddedProducts);
//MessageBox.Show("Transaction Completed Sucessfully");
//Celar the Data Grid View and Clear all the TExtboxes
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
transactionDT.Rows.Clear();
txtSearchProduct.Text = "";
cmbItemName.Text = "";
TxtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtCash.Text = "0";
txtCard.Text = "0";
txtCheque.Text = "0";
txtChequeNo.Text = "0";
txtReturnAmount.Text = "0";
txtInvoiceNo.Text = (decimal.Parse(txtInvoiceNo.Text) + 1).ToString();
}
else
{
//Transaction Failed
MessageBox.Show("Transaction Failed");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//get the value from purchase form first
transactionBLL transaction = new transactionBLL();
transaction.type = lblTop.Text;
//get the ID of dealer or customer here.
//let get the name of dealer first
string DeaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(DeaCustName);
transaction.dea_cus_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
//Get the username of logged in user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
//lets create boolean variable and set it value to false/
bool success = false;
//Actual Code to insert transaction and transaction detail
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//create a boolean Value and insert transaction
bool w = tDAL.InsertTransaction(transaction, out transactionID);
//use for loop to insert transaction Detail
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//Get all the detail of products
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//Get the products name and convert ID
string ProductName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
//Here Increase or Decrease product Quantity based on Pyurchase or Sales
string transactionType = lblTop.Text;
//let check weather we are in purchase or sales
bool x = false;
if (transactionType == "PURCHASE")
{
x = pDAL.Increaseproduct(transactionDetail.product_id, transactionDetail.qty);
//Increase the product
}
else if (transactionType == "SALES")
{
//decrease the product
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//Insert transaction Detail in to DataBase
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
//Transaction Completed
scope.Complete();
//Code to Print the Bill of products
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\n\r\n ANYSTORE PVT.LTD. \r\n\r\n";
printer.SubTitle = "Highfrezh, Ajoke \r\n phone: 01-41XXXXX \r\n\r\n";
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumbers = true;
printer.PageNumberInHeader = false;
printer.PorportionalColumns = true;
printer.HeaderCellAlignment = StringAlignment.Near;
printer.Footer = "Discount: " + txtDiscount.Text + "% \r\n" + "VAT: " + txtVat.Text + "% \r\n" + "Grand Total: " + txtGrandTotal.Text + "\r\n\r\n" + "Thanks for doing business with us";
printer.FooterSpacing = 15;
printer.PrintDataGridView(dgvAddedProducts);
MessageBox.Show("Transaction Complete successfully");
//Clear datagrid veiw and all the TextBoxs
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtProductSearch.Text = "";
txtProductName.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
txtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
//Transaction Failed
MessageBox.Show("Transaction Failed");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//get the details from the form purchase sales form first
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
//get the id of dealer or customer
//lets get name of the delar or customer first
string deaCustName = txtDandCName.Text;
deaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.gst = decimal.Parse(txtGST.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
//get the user name of logged in user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactiondt;
//boolean variable and set its value to FALSE
bool success = false;
//actual code to insert transaction and transaction details
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//create bool value and insert transaction
bool w = tDAL.Insert_transaction(transaction, out transactionID);
//use for loop to insert transaction details
for (int i = 0; i < transactiondt.Rows.Count; i++)
{
//get all the details of the product
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//get the product name and converse into id
string ProductName = transactiondt.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductsIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactiondt.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactiondt.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactiondt.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
//Increase or Decrease Product Qty based on Purchase Or Sales
string transactionType = lblTop.Text;
//check whether we r on purchase or sales
bool x = false;
if (transactionType == "PURCHASE")
{
//Increase the Product
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "SALES")
{
//Decrease the Product
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//Insert transactionsDetails inside the db
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
//transaction is Compelete
scope.Complete();
//scope to print the bill
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\n\r\nRISHI SOFTWARE PVT.LTD\r\n\r\n";
printer.SubTitle = "Kenduadihi, Bankura \r\n Phone:-89720635\r\n\r\n";
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumbers = true;
printer.PageNumberInHeader = false;
printer.PorportionalColumns = true;
printer.HeaderCellAlignment = StringAlignment.Near;
//footer for our bill
printer.Footer = "Discount:- " + txtDiscount.Text + "% \r\n" + "GST:- " + txtGST.Text + "%\r\n" + "Grand Total:- " + txtGrandTotal.Text + "\r\n\r\n" + "Thank You For Shopping With Us";
printer.FooterSpacing = 15;
printer.PrintDataGridView(dgvAddedProducts);
MessageBox.Show("Transaction Completed Successfully");
//clear the data grid view and clear all the textboxes
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtDandCSearch.Text = "";
txtDandCName.Text = "";
txtDandCEmail.Text = "";
txtDandCContact.Text = "";
txtDandCAddress.Text = "";
txtPDSearch.Text = "";
txtPDName.Text = "";
txtPDInventory.Text = "0";
txtPDRate.Text = "0";
txtPDQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtGST.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
//Transaction Failed
MessageBox.Show("Transaction Failed!");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (cmbBoxTransactionType.Text == "Giao hàng" && txtBoxCustomerAddress.Text == "")
{
MessageBox.Show("Bạn chưa điền địa chỉ giao hàng của khách!");
}
else if (txtBoxCustomerName.Text == "")
{
MessageBox.Show("Bạn quên điền thông tin khách hàng");
}
else if (Convert.ToInt32(txtBoxSubTotal.Text.Replace(",", "")) == 0)
{
MessageBox.Show("Bạn chưa thêm món ăn vào đơn ");
}
else
{
int totalRows = dgvAddedProducts.Rows.Count;
int verticalLength = (totalRows * 3 + 23) * 13;
printPreviewDialog1.Document = printDocument1;
printDocument1.DefaultPageSettings.PaperSize = new System.Drawing.Printing.PaperSize("pprnm", 300, verticalLength);
printPreviewDialog1.ShowDialog();
//Get the value from Purchase sales
transactionBLL transactionBLL = new transactionBLL();
//Get customer details
transactionBLL.customer_name = txtBoxCustomerName.Text;
transactionBLL.customer_contact = txtBoxCustomerContact.Text;
transactionBLL.type = cmbBoxTransactionType.Text;
transactionBLL.grandTotal = Convert.ToInt32(txtBoxGrandTotal.Text.Replace(",", ""));
transactionBLL.transaction_date = DateTime.Now;
transactionBLL.tax = 0;
transactionBLL.discount = Convert.ToInt32(txtBoxDiscount.Text);
transactionBLL.billText = receipt;
string username = fLogin.logged_in;
transactionBLL.added_by = username;
transactionBLL.transactionDetails = transactionDT;
//Lets create a boolean var and set its value to false
bool success = false;
int transactionID = -1;
//Create a boolean value and insert transaction
bool transactionInsert = transactionDAL.Insert_Transaction(transactionBLL);
//Use for loop to insert transaction details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//Get all the details of the product
transactionDetailBLL transactionDetailBLL = new transactionDetailBLL();
//Get the product name and convert it to ID
string ProductName = transactionDT.Rows[i][0].ToString();
productBLL productBLL = productDAl.GetIDFromProductName(ProductName);
transactionDetailBLL.product_id = productBLL.id;
transactionDetailBLL.product_note = transactionDT.Rows[i][1].ToString();
transactionDetailBLL.rate = Convert.ToInt32(transactionDT.Rows[i][2].ToString().Replace(",", ""));
transactionDetailBLL.qty = Convert.ToInt32(transactionDT.Rows[i][3].ToString());
transactionDetailBLL.total = Convert.ToInt32(transactionDT.Rows[i][4].ToString().Replace(",", ""));
transactionDetailBLL.customer_name = txtBoxCustomerName.Text;
transactionDetailBLL.customer_contact = txtBoxCustomerContact.Text;
transactionDetailBLL.added_date = DateTime.Now;
transactionDetailBLL.added_by = username;
//Insert transaction details inside the database
bool transactionDetailInsert = transactionDetailDAL.InsertTransactionDetail(transactionDetailBLL);
success = transactionInsert && transactionDetailInsert;
}
if (success = true)
{
MessageBox.Show("Hóa đơn hoàn tất");
//Print bill
receipt = "-----------------------------------------------------------------------------" + Environment.NewLine;
clear();
}
else
{
//transaction failed
MessageBox.Show("Hóa đơn thất bại");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//get the details from the Purchasesale form
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
//get the id of dealer or customer
//get the name of dealer or customer
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
//Get the username of logged in user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
//create a Boolean variable and set its value to false
bool success = false;
//Actual code to insert Transaction and transaction details
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//boolean value and insert transaction
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
//use for loop to insert Transaction Details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//Get all the details of the product
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//get the product name and convert it to id
string ProductName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
//insert transaction details inside the database
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && y;
}
if (success == true)
{
//transaction complete
scope.Complete();
MessageBox.Show("Transaction Complete Sucessfull.");
//clear data gridview and textbox
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtSearchProduct.Text = "";
txtProductName.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
txtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
//Transaction failed
MessageBox.Show("Transaction failed.");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//Get the values from purchase sales from first
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
//Get the id of Dealer and Customer
//Lets get the name of the dealer and customer first
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.ig = decimal.Parse(txtig.Text);
transaction.cg = decimal.Parse(txtcg.Text);
transaction.sg = decimal.Parse(txtsg.Text);
transaction.igamount = decimal.Parse(textigstamount.Text);
transaction.cgamount = decimal.Parse(textcgstamount.Text);
transaction.sgamount = decimal.Parse(textsgstamount.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
transaction.discountamount = decimal.Parse(textdiscoutamount.Text);
//Get the username of logged in user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
//Create a Boolean Variable and set its value to false
bool success = false;
//Actual code to Insert Transaction and transactionDetails
using (TransactionScope scope = new TransactionScope())
{
int tranactionID = -1;
//Create a Boolean Value and Insert Transaction
bool w = tDAL.Insert_Transaction(transaction, out tranactionID);
//Use for loop to insert transaction details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//Get all the details of the product
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//Get the product name and convert it to ID
string ProductName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
//Increase or Decrease Product Quantity Based on Purchase or Sales
string transactionType = lblTop.Text;
//Check Whetehr we are on purchase or sales
bool x = false;
if (transactionType == "Purchase")
{
//Increase the Product
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
//Decrease Product Quantity
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//Insert TransactionDetails inside our database
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
//Transaction Complete
scope.Complete();
label6.Text = txtSubTotal.Text;
label7.Text = txtDiscount.Text;
label8.Text = txtcg.Text;
label9.Text = txtig.Text;
label10.Text = txtsg.Text;
label11.Text = textcgstamount.Text;
label12.Text = textigstamount.Text;
label13.Text = textsgstamount.Text;
label14.Text = txtGrandTotal.Text;
label15.Text = textdiscoutamount.Text;
MessageBox.Show("Transaction Completed Successfully.");
comboBox1.Visible = true;
//Clear the data Grid View and all the TextBxs
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtAddress.Text = "";
txtSearchProduct.Text = "";
txtProductName.Text = "";
txtInventory.Text = "";
txtRate.Text = "";
txtQty.Text = "";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtig.Text = "0";
txtcg.Text = "0";
txtsg.Text = "0";
textigstamount.Text = "0";
textsgstamount.Text = "0";
textcgstamount.Text = "0";
textdiscoutamount.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "";
}
else
{
MessageBox.Show("Transaction Failed.");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//Get the Values from PurchaseSales Form First
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
//Get the ID of Dealer or Customer Here
//Lets get name of the dealer or customer first
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
//Get the Username of Logged in user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
//Lets Create a Boolean Variable and set its value to false
bool success = false;
//Actual Code to Insert Transaction And Transaction Details
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//Create aboolean value and insert transaction
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
//Use for loop to insert Transaction Details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//Get all the details of the product
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//Get the Product name and convert it to id
string ProductName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
//Here Increase or Decrease Product Quantity based on Purchase or sales
string transactionType = lblTop.Text;
//Lets check whether we are on Purchase or Sales
bool x = false;
if (transactionType == "Purchase")
{
//Increase the Product
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
//Decrease the Product Quntiyt
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//Insert Transaction Details inside the database
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
//Transaction Complete
scope.Complete();
MessageBox.Show("Transaction Completed Sucessfully");
//Celar the Data Grid View and Clear all the TExtboxes
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtSearchProduct.Text = "";
txtProductName.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
TxtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
//Transaction Failed
MessageBox.Show("Transaction Failed");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//Get the Values from PurchaseSales Form First
transactionsBLL transaction = new transactionsBLL();
transaction.type = lblTop.Text;
//Get the ID of Dealer or Customer Here
//Lets get name of the dealer or customer first
string deaCustName = txtName.Text;
DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName);
transaction.dea_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVat.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
//Get the Username of Logged in user
string username = frmLogin.loggedIn;
userBLL u = uDAL.GetIDFromUsername(username);
transaction.added_by = u.id;
transaction.transactionDetails = transactionDT;
//Lets Create a Boolean Variable and set its value to false
bool success = false;
//Actual Code to Insert Transaction And Transaction Details
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//Create aboolean value and insert transaction
bool w = tDAL.Insert_Transaction(transaction, out transactionID);
//Use for loop to insert Transaction Details
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//Get all the details of the product
transactionDetailBLL transactionDetail = new transactionDetailBLL();
//Get the Product name and convert it to id
string ProductName = transactionDT.Rows[i][0].ToString();
productsBLL p = pDAL.GetProductIDFromName(ProductName);
transactionDetail.product_id = p.id;
transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
transactionDetail.dea_cust_id = dc.id;
transactionDetail.added_date = DateTime.Now;
transactionDetail.added_by = u.id;
//Here Increase or Decrease Product Quantity based on Purchase or sales
string transactionType = lblTop.Text;
//Lets check whether we are on Purchase or Sales
bool x = false;
if (transactionType == "Purchase")
{
//Increase the Product
x = pDAL.IncreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
else if (transactionType == "Sales")
{
//Decrease the Product Quntiyt
x = pDAL.DecreaseProduct(transactionDetail.product_id, transactionDetail.qty);
}
//Insert Transaction Details inside the database
bool y = tdDAL.InsertTransactionDetail(transactionDetail);
success = w && x && y;
}
if (success == true)
{
//Transaction Complete
scope.Complete();
//Code to Print Bill
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\n\r\n MEGA STORE PVT. LTD. \r\n\r\n";
printer.SubTitle = "Kurunegala, Puttalam Rd \r\n Phone: 077-8513462 \r\n\r\n";
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumbers = true;
printer.PageNumberInHeader = false;
printer.PorportionalColumns = true;
printer.HeaderCellAlignment = StringAlignment.Near;
printer.Footer = "Discount: " + txtDiscount.Text + "% \r\n" + "VAT: " + txtVat.Text + "% \r\n" + "Grand Total: " + txtGrandTotal.Text + "\r\n\r\n" + "Thank you for doing business with us.";
printer.FooterSpacing = 15;
printer.PrintDataGridView(dgvAddedProducts);
MessageBox.Show("Transaction Completed Sucessfully");
//Celar the Data Grid View and Clear all the TExtboxes
dgvAddedProducts.DataSource = null;
dgvAddedProducts.Rows.Clear();
txtSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtSearchProduct.Text = "";
txtProductName.Text = "";
txtInventory.Text = "0";
txtRate.Text = "0";
TxtQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVat.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmount.Text = "0";
txtReturnAmount.Text = "0";
}
else
{
//Transaction Failed
MessageBox.Show("Transaction Failed");
}
}
}
// Here we will create and declare a bool variable.
public bool InsertTranscationDetail(transactionDetailBLL td)
{
// Create a boolean Variable , create a boolean value and set its default value to false
bool isSuccess = false;
// creating sql connection to database. This will be in between bool variable isSuccess and we have returned it as well.
SqlConnection conn = new SqlConnection(myconnstring);
try
{
// writing SQL Query to get all data from database
string sql = "INSERT INTO tbl_transaction_detail (product_id,rate,qty,total,dea_cust_id,added_date,added_by) VALUES (@product_id,@rate,@qty,@total,@dea_cust_id,@added_date,@added_by)";
// create sql command to pass values
SqlCommand cmd = new SqlCommand(sql, conn);
//passing values through parameters using cmd
cmd.Parameters.AddWithValue("@product_id", td.product_id);
cmd.Parameters.AddWithValue("@rate", td.rate);
cmd.Parameters.AddWithValue("@qty", td.qty);
cmd.Parameters.AddWithValue("@total", td.total);
cmd.Parameters.AddWithValue("@dea_cust_id", td.dea_cust_id);
cmd.Parameters.AddWithValue("@added_date", td.added_date);
cmd.Parameters.AddWithValue("@added_by", td.added_by);
// Open Database connection
conn.Open();
//creating int variable to execute the query. Here we don't need first column or first row so we will use this old method
int rows = cmd.ExecuteNonQuery();
//object o = cmd.ExecuteScalar();
//if the query is executed successfully then its value will be greater than zero else less than zero
if (rows > 0)
{
isSuccess = true;
}
else
{
// Query Not Done successfully
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
