private void emp_data_manage_Load(object sender, EventArgs e)
{
/*if (id == -1) attachment_btn.Visible = false;
* else attachment_btn.Visible = true;*/
if (id != -1)
{
string queryString = @"
SELECT
TOP 1
A.FULLNAME,
A.NICKNAME,
A.CODE,
A.EMP_TYPE,
CONVERT(VARCHAR,A.REGISTER_DATE,103) REGISTER_DATE,
A.CAN_APPROVE,
A.APPROVE_CODE,
B.DEPT_NAME
FROM EMPLOYEE A
LEFT OUTER JOIN EMP_DEPT B ON A.EMP_DEPT_ID = B.EMP_DEPT_ID
WHERE A.EMP_ID = " + id.ToString();
using (DataTable myDT = DB.getS(queryString, null, "GET EMP DATA", false))
{
foreach (DataRow myRow in myDT.Rows)
{
fullname.Text = myRow["FULLNAME"].ToString();
nickname.Text = myRow["NICKNAME"].ToString();
employee_code.Text = myRow["CODE"].ToString();
emp_type_id.Text = myRow["EMP_TYPE"].ToString();
register_date.Text = myRow["REGISTER_DATE"].ToString();
if (myRow["CAN_APPROVE"].ToString() == "1")
{
can_approve.Checked = true;
}
else
{
can_approve.Checked = false;
}
approve_code.Text = CRYPT.Decode(myRow["APPROVE_CODE"].ToString());
department.Text = myRow["DEPT_NAME"].ToString();
}
}
}
else
{
String queryString = "SELECT CONVERT(NVARCHAR(MAX), GETDATE(),103) TODAY";
using (DataTable myDT = DB.getS(queryString, null, "GET TODAY", false))
{
register_date.Text = myDT.Rows[0]["TODAY"].ToString();
}
}
}
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;
}
}
}
}
public CRYPTHandler(ISession client, ChatCommandBase cmd) : base(client, cmd)
{
_cmd = (CRYPT)cmd;
}
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 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;
}
}
}
}
}
