private void manage_btn_Click(object sender, EventArgs e) { String queryString = ""; if (amount.Text.Trim() == "") { MessageBox.Show("PLEASE ENTER DISCOUNT AMOUNT !!", "ERROR"); return; } if (approved_by.SelectedIndex == 1) { if (approve_code.Text.Trim() != GF.SAapproveCode) { MessageBox.Show("APPROVE CODE IS NOT CORRECT !!", "ERROR"); approve_code.Focus(); return; } else { approve_id = GF.emp_id; } } else if (approved_by.SelectedIndex > 1 && approve_id == -1) { if (approve_code.Text.Trim().Length == 0) { MessageBox.Show("PLEASE ENTER APPROVE CODE !!", "ERROR"); return; } Dictionary <string, string> Params = new Dictionary <string, string>(); //Params.Add("@approve_code", CRYPT.Encode(approve_code.Text.Trim())); queryString = "SELECT * FROM EMPLOYEE WHERE EMP_ID = " + ((ComboItem)approved_by.SelectedItem).Key.ToString() + " AND approve_code = '" + CRYPT.Encode(approve_code.Text.Trim()) + "'"; using (DataTable DT = DB.getS(queryString, null, "CHECK APPROVE CODE WITH EMP_ID[" + ((ComboItem)approved_by.SelectedItem).Key.ToString() + "]", false)) { if (DT.Rows.Count == 0) { MessageBox.Show("APPROVE CODE IS NOT CORRECT !!", "ERROR"); approve_code.Focus(); return; } else if (DT.Rows.Count == 1 && DT.Rows[0]["EMP_STATUS"].ToString() != "1") { MessageBox.Show("THIS EMPLOYEE CANNOT APPROVE ANYMORE !!", "ERROR"); approved_by.Focus(); return; } else if (DT.Rows[0]["CAN_APPROVE"].ToString() != "1") { MessageBox.Show("THIS EMPLOYEE CANNOT APPROVE !!", "ERROR"); return; } else { approve_id = Convert.ToInt32(DT.Rows[0]["EMP_ID"].ToString()); } } } if (approve_id == -1) { MessageBox.Show("MANUAL DISCOUNT NEEDS APPROVAL !!", "ERROR"); return; } List <string> param = new List <string>(); string subject = ""; string bill_detail_id = ""; if (item.SelectedIndex == 0) { subject = item.Text; bill_detail_id = "-1"; } else { if (card_data != null) { subject = card_data["PROGRAM_NAME"].ToString(); } else { subject = item.Text; } bill_detail_id = ((ComboItem)item.SelectedItem).Key.ToString(); } if (reason.Text.Trim() != "") { subject += " ==" + reason.Text.Trim() + "=="; } if (unit.Text.Trim() == "%" && Convert.ToInt32(amount.Text.Trim()) > 100) { amount.Text = "100"; } param.Add(discount_type.Text + " DISCOUNT"); param.Add(subject + " ** " + GF.formatNumber(Convert.ToInt32(amount.Text)) + " " + ((ComboItem)unit.SelectedItem).Value + " **"); param.Add(GF.formatNumber(Convert.ToInt32(amount.Text))); param.Add(Properties.Settings.Default.money_unit); param.Add(bill_detail_id); param.Add((new Random().Next(1, 1000000) * -1).ToString()); param.Add("0"); param.Add(GF.formatNumber(Convert.ToInt32(amount.Text))); param.Add((card_id != -1 ? card_id.ToString() : "")); param.Add(approve_id.ToString()); ((cashier)this.Owner).pushRow("DISCOUNT", param); ((cashier)this.Owner).updateTotal(); this.Close(); }
private void approve_code_Leave(object sender, EventArgs e) { if (((ComboItem)approved_by.SelectedItem).Key == 0) { if (approve_code.Text.Trim() != GF.SAapproveCode) { MessageBox.Show("APPROVE CODE IS NOT CORRECT !!", "ERROR"); approve_code.Focus(); return; } } else { Dictionary <string, string> Params = new Dictionary <string, string>(); //Params.Add("@approve_code", CRYPT.Encode(approve_code.Text.Trim())); String queryString = "SELECT * FROM EMPLOYEE WHERE EMP_ID = " + ((ComboItem)approved_by.SelectedItem).Key.ToString() + " AND approve_code = '" + CRYPT.Encode(approve_code.Text.Trim()) + "'"; using (DataTable DT = DB.getS(queryString, Params, "CHECK APPROVE CODE WITH EMP_ID[" + ((ComboItem)approved_by.SelectedItem).Key.ToString() + "]", false)) { if (DT.Rows.Count == 0) { MessageBox.Show("APPROVE CODE IS NOT CORRECT !!", "ERROR"); approve_code.Focus(); return; } } } }
private void manage_btn_Click(object sender, EventArgs e) { if (fullname.Text.Trim() == "") { MessageBox.Show("PLEASE ENTER EMPLOYEE'S FULLNAME !!", "ERROR"); fullname.Focus(); return; } if (employee_code.Text.Trim() == "") { MessageBox.Show("PLEASE ENTER EMPLOYEE'S CODE !!", "ERROR"); employee_code.Focus(); return; } if (GF.emptyDate(register_date.Text.Trim())) { MessageBox.Show("PLEASE ENTER REGISTER DATE !!", "ERROR"); register_date.Focus(); return; } Dictionary <string, string> Params = new Dictionary <string, string>(); /*Params.Add("@fullname", fullname.Text); * Params.Add("@emp_code", employee_code.Text);*/ string queryString = "SELECT * FROM EMPLOYEE WHERE (FULLNAME = '" + fullname.Text + "' OR CODE LIKE '" + employee_code.Text + "')"; if (manage_btn.Text == "UPDATE") { queryString += " AND EMP_ID != " + id.ToString(); } using (DataTable myDT = DB.getS(queryString, Params, "CHECK EMP BEFORE EXECUTE", false)) { if (myDT.Rows.Count > 0) { MessageBox.Show("THIS EMPLOYEE IS ALREADY EXISTED IN DATABASE !!", "ERROR"); return; } else { GF.showLoading(this); DB.beginTrans(); if (manage_btn.Text == "ADD") { queryString = "INSERT INTO EMPLOYEE (FULLNAME, NICKNAME, CODE, EMP_DEPT_ID, EMP_TYPE, REGISTER_DATE, CAN_APPROVE, APPROVE_CODE) VALUES ("; queryString += "'" + fullname.Text.Trim() + "', "; queryString += (nickname.Text.Trim() == String.Empty ? "NULL" : "'" + nickname.Text.Trim() + "'") + ", "; queryString += "'" + employee_code.Text.Trim() + "', "; queryString += ((ComboItem)department.SelectedItem).Key.ToString() + ", "; queryString += ((ComboItem)emp_type_id.SelectedItem).Key.ToString() + ", "; queryString += GF.modDate(register_date.Text.Trim()) + ", "; queryString += (this.can_approve.Checked ? "1" : "0") + ", "; queryString += (this.can_approve.Checked ? "'" + CRYPT.Encode(approve_code.Text.Trim()) + "'" : "NULL") + ")"; this.id = DB.insertReturnID(queryString, "INSERT EMPLOYEE RETURN ID"); if (this.id == -1) { MessageBox.Show("ERROR INSERT EMPLOYEE !!", "ERROR"); GF.closeLoading(); return; } DB.close(); GF.closeLoading(); //MessageBox.Show("EMPLOYEE IS ADDED !!", "COMPLETED"); ((btn_dgv)this.Owner.Controls["btn_dgv"]).refresh_btn.PerformClick(); this.Close(); } if (manage_btn.Text == "UPDATE") { queryString = "UPDATE EMPLOYEE SET "; queryString += "FULLNAME = '" + fullname.Text.Trim() + "', "; queryString += "NICKNAME = " + (nickname.Text.Trim() == String.Empty ? "NULL" : "'" + nickname.Text.Trim() + "'") + ", "; queryString += "CODE = '" + employee_code.Text.Trim() + "', "; queryString += "EMP_DEPT_ID = " + ((ComboItem)department.SelectedItem).Key.ToString() + ", "; queryString += "EMP_TYPE = " + ((ComboItem)emp_type_id.SelectedItem).Key.ToString() + ", "; queryString += "REGISTER_DATE = " + GF.modDate(register_date.Text.Trim()) + ", "; queryString += "CAN_APPROVE = " + (can_approve.Checked ? "1" : "0") + ", "; queryString += "APPROVE_CODE = " + (can_approve.Checked ? "'" + CRYPT.Encode(approve_code.Text.Trim()) + "'" : "NULL") + " "; queryString += "WHERE EMP_ID = " + id.ToString(); if (DB.set(queryString, "UPDATE EMP[" + id.ToString() + "]")) { GF.closeLoading(); DB.close(); //MessageBox.Show("EMPLOYEE IS UPDATED !!", "COMPLETED"); ((btn_dgv)this.Owner.Controls["btn_dgv"]).refresh_btn.PerformClick(); this.Close(); } else { MessageBox.Show("ERROR UPDATE EMPLOYEE !!", "ERROR"); GF.closeLoading(); return; } } } } }