private void btnSave_Click(object sender, EventArgs e) { if (id == 0) { if (txtName.Text == "") { MessageBox.Show("សូមបំពេញពត៏មានឲ្យបានត្រឹមត្រូវ!!!"); } else if (txtPassword.Text == "") { MessageBox.Show("សូមបំពេញពត៏មានឲ្យបានត្រឹមត្រូវ!!!"); } else if (txtCommission.Text == "") { MessageBox.Show("សូមបំពេញពត៏មានឲ្យបានត្រឹមត្រូវ!!!"); } else { DTO.Staff staff = new DTO.Staff(); staff.Staffname = txtName.Text; staff.Staffpassword = txtPassword.Text; staff.Stafftype = txtType.Text; staff.Commisionrate = System.Convert.ToDecimal(txtCommission.Text); staff.Lastlogin = System.DateTime.Today; staff.StoreId = (int)cbStock.SelectedValue; if (new StaffDAO().AddStaff(staff)) { clearForm(); listStaff(); id = 0; } else { MessageBox.Show("ប្រតិបត្តិការណ៍បរាជ័យ!!!"); } } } else { DTO.Staff staff = new DTO.Staff(); staff.Staffid = id; staff.Staffname = txtName.Text; staff.Staffpassword = txtPassword.Text; staff.Stafftype = txtType.Text; staff.Commisionrate = System.Convert.ToDecimal(txtCommission.Text); staff.StoreId = (int)cbStock.SelectedValue; if (new StaffDAO().UpdateStaff(staff)) { clearForm(); listStaff(); id = 0; btnDelete.Visible = false; } else { MessageBox.Show("ប្រតិបត្តិការណ៍បរាជ័យ!!!"); } } }
public SqlDataReader Staff_Search_SelectList(DTO.Staff StaffLine) { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "usp_Staff_Search_SelectList"; sqlCmd.Parameters.AddWithValue("@companyName", ((StaffLine.LastName != null) ? (object)StaffLine.LastName : DBNull.Value)); sqlCmd.Connection = this._sqlConn; if (this._sqlConn.State == ConnectionState.Closed) { this._sqlConn.Open(); } SqlDataReader rd = sqlCmd.ExecuteReader(CommandBehavior.CloseConnection); return(rd); }
private void btnSave_Click(object sender, EventArgs e) { if (id == 0) { if (txtExpenseAmount.Text == "" && txtIncomeAmount.Text == "") { MessageBox.Show("សូមបំពេញពត៏មានឲ្យបានត្រឹមត្រូវ!!!"); } else { DTO.Staff staff = new DTO.Staff(); // GET FROM USER SESSION staff.Staffid = UserSession.Session.Staff.Staffid; // CONVERTING VALIDATION decimal incomeAmount = 0; decimal expenseAmount = 0; if (txtIncomeAmount.Text != "") incomeAmount = System.Convert.ToDecimal(txtIncomeAmount.Text); else incomeAmount = 0; if (txtExpenseAmount.Text != "") expenseAmount = System.Convert.ToDecimal(txtExpenseAmount.Text); else expenseAmount = 0; DTO.Transaction tran = new DTO.Transaction(incomeAmount , expenseAmount , staff , txtRemark.Text); if (new TransactionDAO().AddTransaction(tran)) { txtIncomeAmount.Clear(); txtExpenseAmount.Clear(); txtRemark.Clear(); txtIncomeAmount.Enabled = true; txtExpenseAmount.Enabled = true; dgvTransaction.DataSource = new DAO.TransactionDAO().GetAllTransactions().Tables[0]; id = 0; } else { MessageBox.Show("ប្រតិបត្តិការណ៍បរាជ័យ!!!"); } } } else { DTO.Staff staff = new DTO.Staff(); // GET FROM USER SESSION staff.Staffid = UserSession.Session.Staff.Staffid; // CONVERTING VALIDATION decimal incomeAmount = 0; decimal expenseAmount = 0; if (txtIncomeAmount.Text != "") incomeAmount = System.Convert.ToDecimal(txtIncomeAmount.Text); else incomeAmount = 0; if (txtExpenseAmount.Text != "") expenseAmount = System.Convert.ToDecimal(txtExpenseAmount.Text); else expenseAmount = 0; DTO.Transaction tran = new DTO.Transaction(incomeAmount , expenseAmount , staff , txtRemark.Text); tran.Transactionid = id; if (new TransactionDAO().UpdateTransaction(tran)) { txtIncomeAmount.Clear(); txtExpenseAmount.Clear(); txtRemark.Clear(); txtIncomeAmount.Enabled = true; txtExpenseAmount.Enabled = true; dgvTransaction.DataSource = new DAO.TransactionDAO().GetAllTransactions().Tables[0]; id = 0; } else { } } getBalance(); }
private void btnSave_Click(object sender, EventArgs e) { if (id == 0) { if ( txtBarcode.Text.Trim() == "" || txtProductCode.Text.Trim() == "" || txtName.Text.Trim() == "" // || cboCategory.SelectedValue == "" || txtPriceIn.Text.Trim() == "" || txtPriceOut.Text.Trim() == "" ) { MessageBox.Show("សូមបំពេញពត៏មានឲ្យបានត្រឹមត្រូវ!!!"); } else { DAO.ProductDAO productDAO = new DAO.ProductDAO(); if (productDAO.checkProduct(txtProductCode.Text)) { MessageBox.Show("លេខកូដទំនិញរបស់លោកអ្នកមានរួចហើយ សូមបញ្ចូលលេខកូដទំនិញផ្សេង"); return; } DTO.Staff staff = new DTO.Staff(); staff.Staffid = UserSession.Session.Staff.Staffid;// Data.user.Staffid; DTO.Category cate = new DTO.Category(); cate.Categoryid = (int)cboCategory.SelectedValue; DTO.Product product = new DTO.Product(0,txtProductCode.Text.Trim(), txtBarcode.Text.Trim(), txtName.Text.Trim(), txtDescription.Text.Trim(), Decimal.Parse(txtPriceIn.Text.Trim()), Decimal.Parse(txtPriceOut.Text.Trim()), txtRemark.Text.Trim(), staff, staff, cate); if (new DAO.ProductDAO().addProduct(product)) { ClearForm(); dgvProduct.DataSource = new DAO.ProductDAO().getAllProductDS().Tables[0]; id = 0; } else { MessageBox.Show("ប្រតិបត្តិការណ៍បរាជ័យ!!!"); } } } else { if (txtBarcode.Text.Trim() == "" || txtProductCode.Text.Trim() == "" || txtName.Text.Trim() == "" // || cboCategory.SelectedValue == "" || txtPriceIn.Text.Trim() == "" || txtPriceOut.Text.Trim() == "" ) { MessageBox.Show("សូមបំពេញពត៏មានឲ្យបានត្រឹមត្រូវ!!!"); } else { DTO.Staff staff = new DTO.Staff(); staff.Staffid = UserSession.Session.Staff.Staffid;// Data.user.Staffid; DTO.Category cate = new DTO.Category(); cate.Categoryid = (int)cboCategory.SelectedValue; DTO.Product product = new DTO.Product(id, txtProductCode.Text.Trim(), txtBarcode.Text.Trim(), txtName.Text.Trim(), txtDescription.Text.Trim(), Decimal.Parse(txtPriceIn.Text.Trim()), Decimal.Parse(txtPriceOut.Text.Trim()), txtRemark.Text.Trim(), staff, staff, cate); if (new DAO.ProductDAO().updateProduct(product)) { ClearForm(); dgvProduct.DataSource = new DAO.ProductDAO().getAllProductDS().Tables[0]; id = 0; delete.Visible = false; } else { MessageBox.Show("ប្រតិបត្តិការណ៍បរាជ័យ!!!"); } } } }
private void Save_Click(object sender, EventArgs e) { if (id == 0) { if (txtName.Text == "" || txtPhone.Text == "" || txtCode.Text == "") { MessageBox.Show("សូមបំពេញពត៏មានឲ្យបានត្រឹមត្រូវ!!!"); } else { DTO.Member member = new DTO.Member(); member.Membername = txtName.Text; member.MemberCode = txtCode.Text; member.Phonenumber = txtPhone.Text; DTO.Staff staff = new DTO.Staff(); staff.Staffid = UserSession.Session.Staff.Staffid; member.Createdby = staff; member.MemberTypeId = (int)cbMemberType.SelectedValue; decimal discount = 0; if (txtDiscountRate.Text != "") { discount = System.Convert.ToDecimal(txtDiscountRate.Text); } member.Discountrate = discount; if (new MemberDAO().addMember(member)) { txtName.Clear(); txtCode.Clear(); txtDiscountRate.Clear(); txtPhone.Clear(); dgvMember.DataSource = new DAO.MemberDAO().getAllMembersWithDataSet().Tables[0]; id = 0; } else { MessageBox.Show("ប្រតិបត្តិការណ៍បរាជ័យ!!!"); } } } else { DTO.Member member = new DTO.Member(); member.Membername = txtName.Text; member.MemberCode = txtCode.Text; member.Phonenumber = txtPhone.Text; DTO.Staff staff = new DTO.Staff(); staff.Staffid = UserSession.Session.Staff.Staffid; member.Updatedby = staff; member.Memberid = id; decimal discount = 0; if (txtDiscountRate.Text != "") { discount = System.Convert.ToDecimal(txtDiscountRate.Text); } member.Discountrate = discount; member.MemberTypeId = (int)cbMemberType.SelectedValue; if (new MemberDAO().updateMemeber(member)) { txtName.Clear(); txtCode.Clear(); txtDiscountRate.Clear(); txtPhone.Clear(); dgvMember.DataSource = new DAO.MemberDAO().getAllMembersWithDataSet().Tables[0]; id = 0; delete.Visible = false; } else { MessageBox.Show("ប្រតិបត្តិការណ៍បរាជ័យ!!!"); } } }