public bool Delete(DeaCustBLL dc)
{
//SQlConnection for Database Connection
SqlConnection conn = new SqlConnection(myconnstrng);
//Create a Boolean Variable and set its default value to false
bool isSuccess = false;
try
{
//SQL Query to Delete Data from dAtabase
string sql = "DELETE FROM tbl_dea_cust WHERE id=@id";
//SQL command to pass the value
SqlCommand cmd = new SqlCommand(sql, conn);
//Passing the value
cmd.Parameters.AddWithValue("@id", dc.id);
//Open DB Connection
conn.Open();
//integer variable
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
{
conn.Close();
}
return(isSuccess);
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
string keyword = txtSearch.Text;
if (keyword == "")
{
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
return;
}
DeaCustBLL dc = dcDAL.SearchDealerCustomerForTransation(keyword);
txtName.Text = dc.name;
txtEmail.Text = dc.email;
txtContact.Text = dc.contact;
txtAddress.Text = dc.address;
}
public bool Update(DeaCustBLL dc)
{
SqlConnection conn = new SqlConnection(myconnstrng);
bool isSuccess = false;
try
{
string sql = "UPDATE tbl_dea_cust SET type=@type, name=@name, email=@email, contact=@contact, address=@address, added_date=@added_date, added_by=@added_by WHERE id=@id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@type", dc.type);
cmd.Parameters.AddWithValue("@name", dc.name);
cmd.Parameters.AddWithValue("@email", dc.email);
cmd.Parameters.AddWithValue("@contact", dc.contact);
cmd.Parameters.AddWithValue("@address", dc.address);
cmd.Parameters.AddWithValue("@added_date", dc.added_date);
cmd.Parameters.AddWithValue("@added_by", dc.added_by);
cmd.Parameters.AddWithValue("@id", dc.id);
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);
}
public bool Insert(DeaCustBLL d)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
String sql = "INSERT INTO tbl_dea_cust (type,name,email,contact,address,added_date,added_by) values (@type,@name,@email,@contact,@address,@added_date,@added_by) ";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@type", d.type);
cmd.Parameters.AddWithValue("@name", d.name);
cmd.Parameters.AddWithValue("@email", d.email);
cmd.Parameters.AddWithValue("@contact", d.contact);
cmd.Parameters.AddWithValue("@address", d.address);
cmd.Parameters.AddWithValue("@added_date", d.added_date);
cmd.Parameters.AddWithValue("@added_by", d.added_by);
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if the query is execute Successfully then ethe value to rows will be greater than 0 else it will be less than 0
if (rows > 0)
{
//Query Successfuly
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public DeaCustBLL SearchDealerCustomerForTransaction(string keyword)
{
//create an object for DeaCustBLL class
DeaCustBLL dc = new DeaCustBLL();
//create a database connection
SqlConnection conn = new SqlConnection(myconnstrng);
//create a dtatable to hold the value temporarily
DataTable dt = new DataTable();
try
{
//write a query to search deale or customer based on keywords
string sql = "SELECT name, email, contact, address FROM tbl_dea_cust WHERE id LIKE '%" + keyword + "%' OR name LIKE '%" + keyword + "%'";
//create sql data adapter to execute the query
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
//open the database connection
conn.Open();
//transfer the data from sqldata adapter to data table
adapter.Fill(dt);
//if we have values on dt we need to save it in deALERcUSTOMER bll
if (dt.Rows.Count > 0)
{
dc.name = dt.Rows[0]["name"].ToString();
dc.email = dt.Rows[0]["email"].ToString();
dc.contact = dt.Rows[0]["contact"].ToString();
dc.address = dt.Rows[0]["address"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
//close database connection
conn.Close();
}
return(dc);
}
public bool Delete(DeaCustBLL dc)
{
//create a boolean variable and set its value to false
bool isSuccess = false;
//sql connection for database connection
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//sql query to delete from database
string sql = "DELETE FROM tbl_dea_cust WHERE id=@id";
SqlCommand cmd = new SqlCommand(sql, conn);
//passing the value using cmd
cmd.Parameters.AddWithValue("@id", dc.id);
//open sqlconnection
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if the query executed successfully then the vqlue of rows will be greater than 0, else less tham 0
if (rows > 0)
{
//query executed successfully
isSuccess = true;
}
else
{
//failed to xecute query
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public DeaCustBLL GetDeaCustIDFromName(string Name)
{
//first create object of DeaCustBLL and return it.
DeaCustBLL dc = new DeaCustBLL();
//SQL connection here
SqlConnection conn = new SqlConnection(myconnstrng);
//create data table to hold the data temporarily
DataTable dt = new DataTable();
try
{
//Sql Quary to get customer or dealer ID based on NAme.
string sql = "SELECT id FROM tbl_dea_cust WHERE name='" + Name + "'";
//Create sql Adapter to Execute the Quary
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
//opening Database connection
conn.Open();
//passing value from adapter to DataTable dt
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//passing the value from dt to DeaCust dc.
dc.id = int.Parse(dt.Rows[0]["id"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(dc);
return(dc);
}
public bool Insert(DeaCustBLL dc)
{
SqlConnection conn = new SqlConnection(myconnstrng);
bool isSuccess = false;
try
{
string sql = "INSERT INTO tbl_dea_cust (type, name, email, contact, address, added_date, added_by) VALUES (@type, @name, @email, @contact, @address, @added_date, @added_by)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@type", dc.type);
cmd.Parameters.AddWithValue("@name", dc.name);
cmd.Parameters.AddWithValue("@email", dc.email);
cmd.Parameters.AddWithValue("@contact", dc.contact);
cmd.Parameters.AddWithValue("@address", dc.address);
cmd.Parameters.AddWithValue("@added_date", dc.added_date);
cmd.Parameters.AddWithValue("@added_by", dc.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);
}
public DeaCustBLL GetDeaCustIDFromName(string Name)
{
//create an object of DeaCustBLL and return it
DeaCustBLL dc = new DeaCustBLL();
//SQL Connection
SqlConnection conn = new SqlConnection(myconnectstring);
//DataTable to hold data
DataTable dt = new DataTable();
try
{
//SQL Query to get ID Based on Name
string sql = "SELECT id FROM tbl_dea_cust WHERE name = '" + Name + "'";
//Create SQL DataAdapter to execute the query
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
conn.Open();
//Passing the value from Adapter to DataTable
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//Pass the value from dt to DeaCustBLL dc
dc.id = int.Parse(dt.Rows[0]["id"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(dc);
}
public DeaCustBLL GetDeaCustIDFromName(string Name)
{
//First Create an Object of DeaCust BLL and Return it
DeaCustBLL dc = new DeaCustBLL();
//Sql Connnection here
SqlConnection conn = new SqlConnection(myconnstrng);
//Data Table to Hold the Data temporarily
DataTable dt = new DataTable();
try
{
//SQL Query to Get id Based on Name
string sql = "SELECT id FROM tbl_dea_cust WHERE name ='" + Name + "'";
//Create the SQL Data Adapter to Execute the Query
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
conn.Open();
//Passing the value from Adpter to DataTable
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//Pass the value from dt to DeaCustBLL dc
dc.id = int.Parse(dt.Rows[0]["id"].ToString());
}
}
catch (Exception ex)
{
//Show the Error When Message
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(dc);
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
//get the keyword from textbox
string keyword = txtSearch.Text;
if (keyword == "")
{
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
return;
}
//write the code to get the details and set the value on textboxes
DeaCustBLL dc = dcDAL.SearchDealerCustomerForTransaction(keyword);
//now transfer or set the value from DeaCustBLL to textboxes
txtName.Text = dc.name;
txtEmail.Text = dc.email;
txtContact.Text = dc.contact;
txtAddress.Text = dc.address;
}
public DeaCustBLL SearchDealerCustomerForTransaction(string keyword)
{
// create an object for DeaCustBLL
DeaCustBLL dc = new DeaCustBLL();
// Create a Db Connection
SqlConnection conn = new SqlConnection(myconnstrng);
// create a data Table to hold the value Temporarily
DataTable dt = new DataTable();
try
{
//write a sql query to search dealer or customer based on keywords
string sql = "select name, email, contact, address from tbl_dea_cust where id like '%" + keyword + "%' or name like '%" + keyword + "%'";
// create sql Data Adapter to excute the query
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
// transfer the data to datatable
adapter.Fill(dt);
// if we have values in dt we need to save it in dealerCustomer BLL
if (dt.Rows.Count > 0)
{
dc.name = dt.Rows[0]["name"].ToString();
dc.email = dt.Rows[0]["email"].ToString();
dc.contact = dt.Rows[0]["contact"].ToString();
dc.address = dt.Rows[0]["address"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(dc);
}
public bool Delete(DeaCustBLL dc)
{
//create a boolean variable and set its dafault value to false
bool isSuccess = false;
//connecting to database
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//sql query to delete from database
string sql = "DELETE FROM tbl_dea_cust WHERE id=@id";
//creating sql command to pass valuesin our query
SqlCommand cmd = new SqlCommand(sql, conn);
//passing values through parameters
cmd.Parameters.AddWithValue("@id", dc.id);
//open database connection
conn.Open();
//creating the int variable to execute query
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public DeaCustBLL GetDeaCustIDFromName(string Name)
{
// first create an obj of Deacust BLL and return it
DeaCustBLL dc = new DeaCustBLL();
// Sql Connection here
SqlConnection conn = new SqlConnection(myconnstrng);
// Data table to hold data temporarily
DataTable dt = new DataTable();
try
{
// sql query to get ID based oon name
string sql = "select id from tbl_dea_cust where name='" + Name + "'";
// sql Data Adapter to excute query
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
conn.Open();
// passing the value from adapter to data table
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//Pass the value from dt to DeaCustBLL dc
dc.id = int.Parse(dt.Rows[0]["id"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(dc);
}
public bool Delete(DeaCustBLL dc)
{
// SQL connection for database connection
SqlConnection conn = new SqlConnection(myconnstrng);
// create a boolean variable and set its default value to false
bool isSuccess = false;
try
{
// SQl Query to delete data from database
string sql = "delete from tbl_dea_cust where id=@id";
// sql command to pass value
SqlCommand cmd = new SqlCommand(sql, conn);
// pass the value
cmd.Parameters.AddWithValue("@id", dc.id);
// open DB connection
conn.Open();
// int varable to check delete is successful
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Delete(DeaCustBLL dc)
{
SqlConnection conn = new SqlConnection(myconnstrng);
bool isSuccess = false;
try
{
string sql = "DELETE FROM tbl_dea_cust WHERE id=@id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@id", dc.id);
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 txtSearch_TextChanged(object sender, EventArgs e)
{
//Get the Keyword from TextBox
string keywords = txtSearch.Text;
if (keywords == "")
{
//Clear all the TextBoxs
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
return;
}
//Write the code to get the details and set the value on textboxes
DeaCustBLL dc = dcDAL.SearchDealerCustomerForTransaction(keywords);
//Set the value from DeaCustBLL to TextBoxs
txtName.Text = dc.name;
txtEmail.Text = dc.email;
txtContact.Text = dc.contact;
txtAddress.Text = dc.address;
}
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);
}
}
public bool Insert(DeaCustBLL dc)
{
// creating a boolean variable and setting 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);
// start block
try
{
// writing SQL Query to get all data from database
string sql = "INSERT INTO tbl_dea_cust (type,name,email,contact,address,added_date,added_by) VALUES (@type,@name,@email,@contact,@address,@added_date,@added_by)";
// create sql command to pass values
SqlCommand cmd = new SqlCommand(sql, conn);
//passing values through parameters
cmd.Parameters.AddWithValue("@type", dc.type);
cmd.Parameters.AddWithValue("@name", dc.name);
cmd.Parameters.AddWithValue("@email", dc.email);
cmd.Parameters.AddWithValue("@contact", dc.contact);
cmd.Parameters.AddWithValue("@address", dc.address);
cmd.Parameters.AddWithValue("@added_date", dc.added_date);
cmd.Parameters.AddWithValue("@added_by", dc.added_by);
// Open connection
conn.Open();
//creating int variable to execute query
int rows = cmd.ExecuteNonQuery();
//if the query is executed successfully then its value will be greater than zero else less than zero
if (rows > 0)
{
// Query executed Successfully
isSuccess = true;
}
else
{
// Query Not Done successfully
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Update(DeaCustBLL dc)
{
// creating boolean variable and set its value to false
bool isSuccess = false;
// write query to update. Write SQL Connection
SqlConnection conn = new SqlConnection(myconnstring);
try
{
// writing SQL Query to get all data from database. We wil lalways add id into Update
string sql = "UPDATE tbl_dea_cust SET type=@type,name=@name,email=@email,contact=@contact,address=@address,added_date=@added_date,added_by=@added_by WHERE id=@id";
// create sql command to pass values to query
SqlCommand cmd = new SqlCommand(sql, conn);
//passing values through parameters
cmd.Parameters.AddWithValue("@type", dc.type);
cmd.Parameters.AddWithValue("@name", dc.name);
cmd.Parameters.AddWithValue("@email", dc.email);
cmd.Parameters.AddWithValue("@contact", dc.contact);
cmd.Parameters.AddWithValue("@address", dc.address);
cmd.Parameters.AddWithValue("@added_date", dc.added_date);
cmd.Parameters.AddWithValue("@added_by", dc.added_by);
cmd.Parameters.AddWithValue("@id", dc.id);
// Open connection
conn.Open();
//creating int variable to execute query
int rows = cmd.ExecuteNonQuery();
//if the query is executed successfully then its value will be greater than zero else less than zero
if (rows > 0)
{
// Query executed Successfully
isSuccess = true;
}
else
{
// Query Not Done successfully
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
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 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)
{
//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();
//Code to Print Bill
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\n\r\n iResell\r\n\r\n";
printer.SubTitle = "Dorart \r\n [email protected] \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");
}
}
}
private void btnSaveCal_Click(object sender, EventArgs e)
{
//Get the Values from PurchaseSales Form First
TransactionsBLL transaction = new TransactionsBLL();
transaction.type = UserDashboard.TransactionType;
//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 = Login.loggedInUser;
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 = UserDashboard.TransactionType;
//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();
Mymessage mymessage = new Mymessage("Transaction Completed Sucessfully");
mymessage.Show();
//Celar the Data Grid View and Clear all the TExtboxes
GDVCustomer.DataSource = null;
GDVCustomer.Rows.Clear();
txtDeaCustSearch.Text = "";
txtName.Text = "";
txtEMail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtPrdctSearch.Text = "";
txtPrdctName.Text = "";
txtPrdctInventory.Text = "0";
txtProductRate.Text = "0";
txtPrdctQty.Text = "0";
txtSubTotal.Text = "0";
txtDiscount.Text = "0";
txtVAT.Text = "0";
txtGrandTotal.Text = "0";
txtPaidAmt.Text = "0";
txtReturnAmount.Text = "0";
printPreviewDialog1.Document = printDocument1;
printPreviewDialog1.ShowDialog();
}
else
{
//Transaction Failed
MessageBox.Show("Transaction Failed");
}
}
}
