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("ប្រតិបត្តិការណ៍បរាជ័យ!!!");
}
}
}
