private void datagridRefresh() { dataGridView1.Rows.Clear(); dataGridView1.Refresh(); SqlConnection conn = LaundryServiceConn.GetConnection(); SqlDataReader sqlRead = null; SqlCommand scmd = new SqlCommand( " SELECT * FROM clothes", conn); scmd.Parameters.Clear(); conn.Open(); sqlRead = scmd.ExecuteReader(); dataGridView1.ReadOnly = true; while (sqlRead.Read()) { dataGridView1.Rows.Add( sqlRead["CL_ID"].ToString(), sqlRead["CL_NAME"].ToString(), sqlRead["TYPE_ID"].ToString(), sqlRead["PRICE_ADD"].ToString() ); } conn.Close(); }
private void btnSave_Click(object sender, EventArgs e) { int count = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { if (bool.Parse(row.Cells[6].Value.ToString()) == true) { String orderId = dataGridView1.Rows[row.Index].Cells[0].Value.ToString(); using (SqlConnection conn = LaundryServiceConn.GetConnection()) { SqlCommand scmd = new SqlCommand("UPDATE [order] SET [STATUS] = @status WHERE [ORDER_ID] = @orderId", conn); conn.Open(); scmd.Parameters.AddWithValue("@status", 1); scmd.Parameters.AddWithValue("@orderId", orderId); scmd.ExecuteNonQuery(); conn.Close(); } count++; } } showDataGridComplete(); showDataGridNoComplete(); }
// show data on data grid private void showDataGrid() { SqlConnection conn = LaundryServiceConn.GetConnection(); SqlDataReader sqlRead = null; SqlCommand scmd = new SqlCommand( " SELECT a.[PROMO_ID]" + " , a.[PROMO_NAME]" + " , a.[PROMO_DISCRIPTION]" + " , a.[PROMO_PRICE]" + " , a.[PROMO_QTY]" + " , a.[CL_ID]" + " , b.BALANCE" + " FROM[dbo].[promotion] a" + " RIGHT JOIN[dbo].[promotionCondition] b ON a.[PROMO_ID] = b.PROMO_ID" + " where b.CUS_ID = @cusId", conn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@cusId", cusID); conn.Open(); sqlRead = scmd.ExecuteReader(); dataGPackCus.ReadOnly = true; while (sqlRead.Read()) { dataGPackCus.Rows.Add( sqlRead["PROMO_NAME"].ToString(), sqlRead["BALANCE"].ToString() ); } conn.Close(); }
private void frmAddType_Load(object sender, EventArgs e) { txtTypeID.Enabled = false; txtTypeName.Enabled = false; dataGridView1.Rows.Clear(); dataGridView1.Refresh(); SqlConnection conn = LaundryServiceConn.GetConnection(); SqlDataReader sqlRead = null; SqlCommand scmd = new SqlCommand( " SELECT * FROM type", conn); scmd.Parameters.Clear(); conn.Open(); sqlRead = scmd.ExecuteReader(); dataGridView1.ReadOnly = true; while (sqlRead.Read()) { dataGridView1.Rows.Add( sqlRead["TYPE_ID"].ToString(), sqlRead["TYPE_NAME"].ToString() ); } conn.Close(); }
private void btnDelete_Click(object sender, EventArgs e) { //DELETE DialogResult dialogResult = MessageBox.Show("Do you want to delete " + txtClothesName.Text, "Message", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("DELETE FROM clothes WHERE [CL_ID]=@clothesID ", conn); conn.Open(); scmd.Parameters.AddWithValue("@clothesID", txtClothesID.Text); scmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Delete successed"); clear(); datagridRefresh(); } else if (dialogResult == DialogResult.No) { //do something else } }
private void showDataGrid() { dataGridView1.Rows.Clear(); dataGridView1.Refresh(); SqlConnection conn = LaundryServiceConn.GetConnection(); SqlDataReader sqlRead = null; SqlCommand scmd = new SqlCommand( " SELECT * FROM promotion", conn); scmd.Parameters.Clear(); // scmd.Parameters.AddWithValue("@cusId", cusID); conn.Open(); sqlRead = scmd.ExecuteReader(); dataGridView1.ReadOnly = true; while (sqlRead.Read()) { dataGridView1.Rows.Add( sqlRead["PROMO_ID"].ToString(), sqlRead["PROMO_NAME"].ToString(), sqlRead["PROMO_QTY"].ToString(), sqlRead["PROMO_PRICE"].ToString() ); } conn.Close(); }
private void btnAdd_Click(object sender, EventArgs e) { if (txtPromoName.Text == "" || txtPromoDisc.Text == "" || txtPromoPrice.Text == "" || txtPromoQty.Text == "" || comboBox1.Text == "") { MessageBox.Show("Enter all data ,please.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if(txtPromoID.Text == "") { // SAVE SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("INSERT INTO promotion ([PROMO_NAME],[PROMO_DISCRIPTION],[PROMO_PRICE],[PROMO_QTY],[CL_ID] ) VALUES ( @promoName,@promoDesc,@promoPrice,@promoQty,@clothesID )", conn); conn.Open(); scmd.Parameters.AddWithValue("@promoName", txtPromoName.Text); scmd.Parameters.AddWithValue("@promoDesc", txtPromoDisc.Text); scmd.Parameters.AddWithValue("@promoPrice", txtPromoPrice.Text); scmd.Parameters.AddWithValue("@promoQty", txtPromoQty.Text); scmd.Parameters.AddWithValue("@clothesID", comboBox1.SelectedIndex + 1); scmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Insert successed"); } else { // UPDATE SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("UPDATE promotion SET [PROMO_NAME] = @promoName ,[PROMO_DISCRIPTION]= @promoDesc ,[PROMO_PRICE] = @promoPrice ,[PROMO_QTY] = @promoQty ,[CL_ID]= @clothesID WHERE [PROMO_ID]= @promoID", conn); conn.Open(); scmd.Parameters.AddWithValue("@promoID", txtPromoID.Text); scmd.Parameters.AddWithValue("@promoName", txtPromoName.Text); scmd.Parameters.AddWithValue("@promoDesc", txtPromoDisc.Text); scmd.Parameters.AddWithValue("@promoPrice", txtPromoPrice.Text); scmd.Parameters.AddWithValue("@promoQty", txtPromoQty.Text); scmd.Parameters.AddWithValue("@clothesID", comboBox1.SelectedIndex + 1); scmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Update successed"); } clear(); datagridRefresh(); } }
private void button1_Click(object sender, EventArgs e) { if (Double.Parse(txtReceive.Text) < total || String.IsNullOrEmpty(txtReceive.Text)) { MessageBox.Show("Sorry, not enough money.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtReceive.Text = ""; } else { Double change = Double.Parse(txtReceive.Text) - total; txtChange.Text = change.ToString(); SqlConnection conn = LaundryServiceConn.GetConnection(); foreach (DataGridViewRow row in dataGridView2.Rows) { // String cellProID = row.Cells[0].Value == null ? "" : row.Cells[0].Value.ToString(); Int32 cellProID = row.Cells[0].Value == null ? 0 : Int32.Parse(row.Cells[0].Value.ToString()); Int32 cellProQty = row.Cells[2].Value == null ? 0 : Int32.Parse(row.Cells[2].Value.ToString()); //String cellProName = row.Cells[1].Value == null ? "" : row.Cells[1].Value.ToString(); //Double cellProPrice = row.Cells[2].Value == null ? 0 : Double.Parse(row.Cells[2].Value.ToString()); DateTime thisDay = DateTime.Today; string scmd = "INSERT INTO promotionCondition ([PROMO_ID],[CUS_ID],[PRO_DATE_BUY],[QTY_ITEM] ,[BALANCE] ,[TOTAL]) VALUES ( @promoID, @cusID, @proDateBuy, @qty,@balance,@total)"; conn.Open(); using (SqlCommand cmd = new SqlCommand(scmd, conn)) { if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.Parameters.AddWithValue("@promoID", cellProID); cmd.Parameters.AddWithValue("@cusID", cusID); cmd.Parameters.AddWithValue("@proDateBuy", thisDay); cmd.Parameters.AddWithValue("@qty", cellProQty); cmd.Parameters.AddWithValue("@balance", cellProQty); cmd.Parameters.AddWithValue("@total", total); cmd.ExecuteNonQuery(); conn.Close(); } } MessageBox.Show("successed, thanks."); dataGridView2.Rows.Clear(); dataGridView2.Refresh(); txtChange.Text = ""; txtReceive.Text = ""; txtTotal.Text = ""; } }
private void frmAddPromotion_Load(object sender, EventArgs e) { txtPromoID.Enabled = false; txtPromoName.Enabled = false; txtPromoDisc.Enabled = false; txtPromoPrice.Enabled = false; txtPromoQty.Enabled = false; comboBox1.Enabled = false; dataGridView1.Rows.Clear(); dataGridView1.Refresh(); SqlConnection conn = LaundryServiceConn.GetConnection(); SqlDataReader sqlRead = null; SqlCommand scmd = new SqlCommand( " SELECT * FROM promotion", conn); scmd.Parameters.Clear(); conn.Open(); sqlRead = scmd.ExecuteReader(); dataGridView1.ReadOnly = true; while (sqlRead.Read()) { dataGridView1.Rows.Add( sqlRead["PROMO_ID"].ToString(), sqlRead["PROMO_NAME"].ToString(), sqlRead["PROMO_DISCRIPTION"].ToString(), sqlRead["PROMO_PRICE"].ToString(), sqlRead["PROMO_QTY"].ToString(), sqlRead["CL_ID"].ToString() ); } conn.Close(); using (SqlConnection con = LaundryServiceConn.GetConnection()) { SqlCommand sqlCmd = new SqlCommand("SELECT * FROM clothes", con); con.Open(); SqlDataReader sqlReader = sqlCmd.ExecuteReader(); while (sqlReader.Read()) { comboBox1.Items.Add(new Item( Int32.Parse(sqlReader["CL_ID"].ToString()), sqlReader["CL_NAME"].ToString()) ); } sqlReader.Close(); } }
private void showDataGridComplete() { dataGridView2.Rows.Clear(); dataGridView2.Refresh(); using (SqlConnection conn = LaundryServiceConn.GetConnection()) { SqlDataReader sqlRead = null; SqlCommand scmd = new SqlCommand( " SELECT " + "a.[ORDER_ID] , a.[ORDER_NO] ,a.[ORDER_REGISTER_DATE] , a.[ORDER_COMPETE] , a.[ORDER_EXPIRE] , a.[PROMO_ID] , a.[CUS_ID] , a.[CL_ID] , a.[ORDER_QTY] , a.[ORDER_PRICE] , a.[STATUS] , b.[PROMO_NAME] , b.[PROMO_PRICE] " + " FROM[laundryService].[dbo].[order] a " + " LEFT JOIN[laundryService].[dbo].[promotion] b ON a.PROMO_ID = b.PROMO_ID " + " WHERE a.[STATUS] = 1 AND a.[CUS_ID] = @cusId " + " ORDER BY a.[STATUS] ASC,a.[ORDER_NO], a.[ORDER_COMPETE] DESC", conn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@cusId", cusID); if (ConnectionState.Closed == conn.State) { conn.Open(); } sqlRead = scmd.ExecuteReader(); dataGridView2.ReadOnly = true; String orderNo = ""; while (sqlRead.Read()) { //orderNo = orderNo.Equals(sqlRead["ORDER_NO"].ToString()) ? "" : sqlRead["ORDER_NO"].ToString(); orderNo = sqlRead["ORDER_NO"].ToString(); DateTime regisDate = Convert.ToDateTime(sqlRead["ORDER_REGISTER_DATE"].ToString()); DateTime completeDate = Convert.ToDateTime(sqlRead["ORDER_COMPETE"].ToString()); dataGridView2.Rows.Add( sqlRead["ORDER_ID"].ToString(), orderNo, sqlRead["ORDER_QTY"].ToString(), sqlRead["ORDER_PRICE"].ToString(), String.Format("{0:d}", regisDate), String.Format("{0:d}", completeDate), sqlRead["STATUS"].ToString() == "1" ); } conn.Close(); txtOrdComplete.Text = String.Format("{0} {1}", txtOrdComplete.Text, dataGridView2.RowCount); } }
private void btnSave_Click(object sender, EventArgs e) { if (txtClothesName.Text == "" || txtClothesPrice.Text == "" || comboBox1.Text == "") { MessageBox.Show("Enter all data ,please.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (txtClothesID.Text == "") { // SAVE SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("INSERT INTO clothes ([CL_NAME],[TYPE_ID],[PRICE_ADD]) VALUES ( @clothesName,@typeID,@priceAdd)", conn); conn.Open(); scmd.Parameters.AddWithValue("@clothesName", txtClothesName.Text); scmd.Parameters.AddWithValue("@typeID", comboBox1.SelectedIndex + 1); scmd.Parameters.AddWithValue("@priceAdd", txtClothesPrice.Text); scmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Insert successed"); } else { // UPDATE SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("UPDATE clothes SET [CL_NAME] = @clothesName ,[TYPE_ID]= @typeID ,[PRICE_ADD] = @priceAdd WHERE [CL_ID]= @clothesID", conn); conn.Open(); scmd.Parameters.AddWithValue("@clothesID", txtClothesID.Text); scmd.Parameters.AddWithValue("@clothesName", txtClothesName.Text); scmd.Parameters.AddWithValue("@typeID", comboBox1.SelectedIndex + 1); scmd.Parameters.AddWithValue("@priceAdd", txtClothesPrice.Text); scmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Update successed"); } clear(); datagridRefresh(); } }
private void update() { using (SqlConnection conn = LaundryServiceConn.GetConnection()) { SqlCommand scmd = new SqlCommand("UPDATE customer SET [CUS_NAME] =@cusName ,[CUS_PHONE] = @cusPhone,[CUS_ADDRESS] = @cusAddress WHERE [CUS_ID]= @cusId", conn); conn.Open(); scmd.Parameters.AddWithValue("@cusName", txtCusname.Text); scmd.Parameters.AddWithValue("@cusPhone", txtCusPhone.Text); scmd.Parameters.AddWithValue("@cusAddress", txtCusAddress.Text); scmd.Parameters.AddWithValue("@cusId", txtCusId.Text); scmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Update successed"); } }
//private void add4() //{ // int insertID = 0; // string sqlIns = "INSERT INTO customer ([CUS_NAME],[CUS_PHONE],[CUS_ADDRESS]) VALUES ( @cusName ,@cusPhone,@cusAddress )"; // SqlConnection conn = LaundryServiceConn.GetConnection(); // conn.Open(); // try // { // SqlCommand cmdIns = new SqlCommand(sqlIns, conn); // cmdIns.Parameters.AddWithValue("@cusName", "test"); // cmdIns.Parameters.AddWithValue("@cusPhone", "0866954585"); // cmdIns.Parameters.AddWithValue("@cusAddress", "dindang"); // cmdIns.ExecuteNonQuery(); // cmdIns.Parameters.Clear(); // cmdIns.CommandText = "SELECT @@IDENTITY"; // // Get the last inserted id. // insertID = Convert.ToInt32(cmdIns.ExecuteScalar()); // cmdIns.Dispose(); // cmdIns = null; // } // catch (Exception ex) // { // throw new Exception(ex.ToString(), ex); // } // finally // { // conn.Close(); // } // Console.WriteLine(insertID); //} //private void add3() //{ // using (SqlConnection conn = LaundryServiceConn.GetConnection()) // { // string saveCus = "INSERT INTO customer ([CUS_NAME],[CUS_PHONE],[CUS_ADDRESS]) VALUES ( @cusName ,@cusPhone,@cusAddress )"; // using (SqlCommand querySaveCus = new SqlCommand(saveCus)) // { // querySaveCus.Connection = conn; // querySaveCus.Parameters.Add("@cusName", SqlDbType.NVarChar, 255).Value = txtCusName.Text; // querySaveCus.Parameters.Add("@cusPhone", SqlDbType.NVarChar, 20).Value = txtCusPhone.Text; // querySaveCus.Parameters.Add("@cusAddress", SqlDbType.NVarChar, 255).Value = txtCusAddress.Text; // conn.Open(); // } // } //} private void add() { // connect database & Add data SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("INSERT INTO customer ( [CUS_NAME],[CUS_PHONE],[CUS_ADDRESS] ) VALUES ( @cusName ,@cusPhone,@cusAddress )", conn); conn.Open(); scmd.Parameters.AddWithValue("@cusName", txtCusName.Text); scmd.Parameters.AddWithValue("@cusPhone", txtCusPhone.Text); scmd.Parameters.AddWithValue("@cusAddress", txtCusAddress.Text); scmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Saved successed"); }
private void comboType() { // combobox using (SqlConnection conn = LaundryServiceConn.GetConnection()) { SqlCommand sqlCmd = new SqlCommand("SELECT * FROM type", conn); conn.Open(); SqlDataReader sqlReader = sqlCmd.ExecuteReader(); while (sqlReader.Read()) { comboBox1.Items.Add(new ItemCombo( Int32.Parse(sqlReader["TYPE_ID"].ToString()), sqlReader["TYPE_NAME"].ToString()) ); } sqlReader.Close(); } }
private void btnLogin_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtUsername.Text) || txtUsername.Text == "Username") { MessageBox.Show("Enter Username ,please.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (String.IsNullOrEmpty(txtPassword.Text) || txtPassword.Text == "Password") { MessageBox.Show("Enter password ,please.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (count < 3) { SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("select count (*) as cnt from [laundryService].[dbo].[user] where [USERNAME]=@usr and [PASSWORD]=@pwd", conn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@usr", txtUsername.Text); scmd.Parameters.AddWithValue("@pwd", txtPassword.Text); conn.Open(); if (scmd.ExecuteScalar().ToString() == "1") { MessageBox.Show("Login Success."); frmMain frm = new frmMain(); frm.Show(); this.Hide(); } else { MessageBox.Show("Login fail.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtUsername.Clear(); txtPassword.Clear(); count = count + 1; } conn.Close(); } else { MessageBox.Show("Connect Developer", "Validate", MessageBoxButtons.OK, MessageBoxIcon.Stop); this.Close(); } }
private void btnSave_Click(object sender, EventArgs e) { if (txtTypeName.Text == "") { MessageBox.Show("Enter all data ,please.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (txtTypeID.Text == "") { // SAVE SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("INSERT INTO type ([TYPE_NAME]) VALUES ( @typeName)", conn); conn.Open(); scmd.Parameters.AddWithValue("@typeName", txtTypeName.Text); scmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Insert successed"); } else { // UPDATE SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("UPDATE type SET [TYPE_NAME] = @typeName WHERE [TYPE_ID]= @typeID", conn); conn.Open(); scmd.Parameters.AddWithValue("@typeID", txtTypeID.Text); scmd.Parameters.AddWithValue("@typeName", txtTypeName.Text); scmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Update successed"); } clear(); datagridRefresh(); } }
private void frmOrder_Load(object sender, EventArgs e) { SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("select * from customer where [CUS_ID]=@cusId", conn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@cusId", cusID); conn.Open(); SqlDataReader reader = null; reader = scmd.ExecuteReader(); while (reader.Read()) { lblCusID.Text = "" + reader["CUS_ID"].ToString(); lblCusName.Text = "" + reader["CUS_NAME"].ToString(); } conn.Close(); showDataGrid(); comboType(); }
private void frmCusInfo_Load(object sender, EventArgs e) { SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("select * from customer where [CUS_ID]=@cusId", conn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@cusId", cusID); conn.Open(); SqlDataReader reader = null; reader = scmd.ExecuteReader(); while (reader.Read()) { txtCusId.Text = "" + reader["CUS_ID"].ToString(); txtCusname.Text = reader["CUS_NAME"].ToString(); txtCusPhone.Text = reader["CUS_PHONE"].ToString(); txtCusAddress.Text = reader["CUS_ADDRESS"].ToString(); } conn.Close(); showDataGrid(); }
private void showDataGrid(int typeId) { SqlConnection conn = LaundryServiceConn.GetConnection(); SqlDataReader sqlRead = null; SqlCommand scmd = new SqlCommand( " SELECT * FROM clothes WHERE [TYPE_ID] = @typeId", conn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@typeId", typeId); conn.Open(); sqlRead = scmd.ExecuteReader(); dataGridView2.Rows.Clear(); dataGridView2.Refresh(); dataGridView2.ReadOnly = true; while (sqlRead.Read()) { dataGridView2.Rows.Add(sqlRead["CL_ID"].ToString(), sqlRead["CL_NAME"].ToString(), sqlRead["PRICE_ADD"].ToString()); } conn.Close(); }
private void frmParent_Load(object sender, EventArgs e) { SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("select * from customer where [CUS_ID]=@cusId", conn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@cusId", cusID); conn.Open(); SqlDataReader reader = null; reader = scmd.ExecuteReader(); while (reader.Read()) { this.Text = "Customer : " + reader["CUS_NAME"].ToString(); } conn.Close(); panel1.Controls.Clear(); frmCusInfo frm = new frmCusInfo(cusID); frm.TopLevel = false; panel1.Controls.Add(frm); frm.Show(); }
private void btnSearch_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtCustomer.Text)) { MessageBox.Show("Enter ID customer,please.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //seach by phone if (checkBoxPhone.Checked == true) { SqlConnection connn = LaundryServiceConn.GetConnection(); SqlCommand scmdd = new SqlCommand("select count (*) as cnt ,[CUS_ID] from [laundryService].[dbo].[customer] where [CUS_PHONE]=@cusPhone GROUP BY [CUS_ID] ", connn); scmdd.Parameters.Clear(); scmdd.Parameters.AddWithValue("@cusPhone", txtCustomer.Text); // scmdd.Parameters.AddWithValue("@cusId", txtCustomer.Text); connn.Open(); if (scmdd.ExecuteScalar().ToString() == "1") { String cusId = null; SqlDataReader sRead = scmdd.ExecuteReader(); while (sRead.Read()) { //MessageBox.Show(sRead["CUS_ID"].ToString()); cusId = sRead["CUS_ID"].ToString(); } Program.ACTIVE_CUSTOMER_ID = Int32.Parse(cusId); frmParent frm = new frmParent(cusId); frm.Show(); this.Hide(); } else { MessageBox.Show("Invalid ID customer or phone number,please enter again.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtCustomer.Clear(); } connn.Close(); } else //seach by ID { SqlConnection conn = LaundryServiceConn.GetConnection(); SqlCommand scmd = new SqlCommand("select count (*) as cnt,[CUS_ID] from [laundryService].[dbo].[customer] where [CUS_ID]=@cusId GROUP BY [CUS_ID] ", conn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@cusId", txtCustomer.Text); conn.Open(); if (scmd.ExecuteScalar().ToString() == "1") { String cusId = txtCustomer.Text; Program.ACTIVE_CUSTOMER_ID = Int32.Parse(txtCustomer.Text); frmParent frm = new frmParent(cusId); frm.Show(); this.Hide(); } else { MessageBox.Show("Invalid ID customer or phone number,please enter again.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtCustomer.Clear(); } conn.Close(); } }
private void btnReceive_Click(object sender, EventArgs e) { if (checkInput() == false) { MessageBox.Show("Please ,Fill your input"); return; } if (Double.Parse(txtReceive.Text) < Double.Parse(txtTotal.Text) || String.IsNullOrEmpty(txtReceive.Text)) { MessageBox.Show("Sorry, not enough money.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtReceive.Text = ""; } else { // check all value to calculate double moneychange = 0.0; moneychange = Double.Parse(txtReceive.Text) - Double.Parse(txtTotal.Text); txtChange.Text = moneychange.ToString("F"); // CHECK PACKAGE BALANCE if (checkPackageBalance()) { // SAVE AND UPDATE BALANCE string orderNo = generateOrderNo(); using (SqlConnection conn = LaundryServiceConn.GetConnection()) { // date row data from dataGridView1 int cntSavedItem = 0; int cntItem = dataGridView1.RowCount; foreach (DataGridViewRow row in dataGridView1.Rows) { string saveNewOrder = " INSERT INTO [order] " + " ([ORDER_NO],[ORDER_REGISTER_DATE],[ORDER_COMPETE],[ORDER_EXPIRE],[PROMO_ID], [CUS_ID] ,[CL_ID] ,[ORDER_QTY] , [ORDER_PRICE] ) " + " VALUES " + " ( @orderNo, @orderRegisDate, @orderCompleteDate, @orderExpireDate, @promoId, @cusId , @clotherId ,@orderQty , @orderPrice) "; SqlCommand scmd = new SqlCommand(saveNewOrder, conn); if (ConnectionState.Closed == conn.State) { conn.Open(); } String clotherId = row.Cells[0].Value.ToString(); String orderPrice = row.Cells[2].Value.ToString(); String orderQty = row.Cells[3].Value.ToString(); String promoId = row.Cells[4].Value.ToString(); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@orderNo", orderNo); scmd.Parameters.AddWithValue("@orderRegisDate", DateTime.Now.Date); scmd.Parameters.AddWithValue("@orderCompleteDate", dateTimePicker2.Value.Date); scmd.Parameters.AddWithValue("@orderExpireDate", DateTime.Now.AddYears(1)); scmd.Parameters.AddWithValue("@promoId", promoId); scmd.Parameters.AddWithValue("@cusId", cusID); scmd.Parameters.AddWithValue("@clotherId", clotherId); scmd.Parameters.AddWithValue("@orderQty", orderQty); scmd.Parameters.AddWithValue("@orderPrice", orderPrice); //check ( pakacge id , promotion id ) is 0 not update promotion balance if (promoId != "0") { // update balance in [promotionCondition] string upDate = "UPDATE [promotionCondition] SET [BALANCE] = [BALANCE] - @balance WHERE [PROMO_ID] = @promoId AND[CUS_ID] = @cusId "; SqlCommand ucmd = new SqlCommand(upDate, conn); if (ConnectionState.Closed == conn.State) { conn.Open(); } ucmd.Parameters.Clear(); ucmd.Parameters.AddWithValue("@balance", orderQty); ucmd.Parameters.AddWithValue("@promoId", promoId); ucmd.Parameters.AddWithValue("@cusId", cusID); ucmd.ExecuteNonQuery(); } cntSavedItem += scmd.ExecuteNonQuery(); } if (cntSavedItem == cntItem) { MessageBox.Show("Save complete"); dataGridView1.Rows.Clear(); dataGridView1.Refresh(); txtReceive.Text = "0"; txtChange.Text = ""; txtTotal.Text = ""; } else { MessageBox.Show("Save not complete"); } conn.Close(); } } } }