private void DGV_SelectionChanged(object sender, EventArgs e)
{
if (!preventDGVSelectionChanged)
{
if (DGV.SelectedRows.Count == 1)
{
GF.disableButton(this.ParentForm.Controls.Find("add_btn", true)[0] as Button);
GF.enableButton(this.ParentForm.Controls.Find("edit_btn", true)[0] as Button);
if (!preventEnable) // USE ENABLE BUTTON
{
if (DGV.Columns.Contains("is_use"))
{
if (DGV.SelectedRows[0].Cells["is_use"].Value.ToString() == "ACTIVE")
{
GF.enableButton(this.ParentForm.Controls.Find("del_btn", true)[0] as Button);
if (useDefaultEnable)
{
this.ParentForm.Controls.Find("enable_btn", true)[0].Visible = false;
}
}
if (DGV.SelectedRows[0].Cells["is_use"].Value.ToString() == "INACTIVE")
{
GF.disableButton(this.ParentForm.Controls.Find("del_btn", true)[0] as Button);
if (useDefaultEnable)
{
this.ParentForm.Controls.Find("enable_btn", true)[0].Visible = true;
}
}
}
else
{
GF.enableButton(this.ParentForm.Controls.Find("del_btn", true)[0] as Button);
}
}
else // NOT USE ENABLE BUTTON
{
if (DGV.SelectedRows[0].DefaultCellStyle.BackColor != Color.Khaki && DGV.SelectedRows[0].DefaultCellStyle.BackColor != Color.LightCoral)
{
GF.enableButton(this.ParentForm.Controls.Find("del_btn", true)[0] as Button);
}
else
{
GF.disableButton(this.ParentForm.Controls.Find("del_btn", true)[0] as Button);
}
}
}
else
{
GF.enableButton(this.ParentForm.Controls.Find("add_btn", true)[0] as Button);
GF.disableButton(this.ParentForm.Controls.Find("edit_btn", true)[0] as Button);
GF.disableButton(this.ParentForm.Controls.Find("del_btn", true)[0] as Button);
if (preventEnable)
{
this.ParentForm.Controls.Find("enable_btn", true)[0].Visible = false;
}
}
}
}
private void DGV_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (!viewOnly)
{
GF.enableButton(delete_btn);
}
}
private void total_lbl_TextChanged(object sender, EventArgs e)
{
int tmp;
Int32.TryParse(total_lbl.Text.Trim(), out tmp);
if (tmp > 1)
{
GF.enableButton(next_btn);
GF.enableButton(last_btn);
}
}
private void file_path_TextChanged(object sender, EventArgs e)
{
if (file_path.Text.Trim() != "")
{
GF.enableButton(add_btn);
Properties.Settings.Default.attachment_path = file_path.Text.Trim().Substring(0, file_path.Text.Trim().LastIndexOf('\\'));
Properties.Settings.Default.Save();
}
else
{
GF.disableButton(add_btn);
}
}
private void last_btn_Click(object sender, EventArgs e)
{
GF.showLoading();
page_txt.Text = total_lbl.Text;
int.TryParse(page_txt.Text, out GF.currentPage);
GF.disableButton(last_btn);
GF.disableButton(next_btn);
if (page_txt.Text != "1")
{
GF.enableButton(first_btn);
GF.enableButton(prev_btn);
}
onLastClick(EventArgs.Empty);
}
private void next_btn_Click(object sender, EventArgs e)
{
GF.showLoading();
page_txt.Text = (Convert.ToInt32(page_txt.Text) + 1).ToString();
int.TryParse(page_txt.Text, out GF.currentPage);
if (page_txt.Text == total_lbl.Text)
{
GF.disableButton(last_btn);
GF.disableButton(next_btn);
}
if (page_txt.Text != "1")
{
GF.enableButton(first_btn);
GF.enableButton(prev_btn);
}
onNextClick(EventArgs.Empty);
}
private void btn_dgv_Load(object sender, EventArgs e)
{
this.Width = Screen.PrimaryScreen.Bounds.Width - (this.Left * 2);
paging_panel.Top = this.Height - this.Top - 165;
DGV.Height = paging_panel.Top - 70;
GF.disableButton(first_btn);
GF.disableButton(prev_btn);
GF.disableButton(next_btn);
GF.disableButton(last_btn);
page_txt.Text = "1";
int tmp;
Int32.TryParse(total_lbl.Text.Trim(), out tmp);
if (tmp > 1)
{
GF.enableButton(next_btn);
GF.enableButton(last_btn);
}
//preventDGVSelectionChanged = true;
}
private void card_print_Load(object sender, EventArgs e)
{
String queryString = "";
DataTable DT = null;
switch (card_type)
{
case 0:
case 1: // MEMBERCARD & MEMBERCARD_LIMITED_EDITION
print_card1_btn.Text = "FRONT";
print_card2_btn.Text = "BACK";
attach_paper_btn.Text = "ATTACH PAPER";
break;
case 2: // GIFT CERTIFICATE
print_card1_btn.Text = "CARD";
print_card1_btn.Width = attach_paper_btn.Width;
print_card2_btn.Visible = false;
break;
case 3: // GIFT VOUCHER
GF.enableButton(print_card1_btn);
print_card1_btn.Text = "CARD";
print_card1_btn.Width = attach_paper_btn.Width;
print_card2_btn.Visible = false;
attach_paper_btn.Visible = false;
groupBox1.Height = attach_paper_btn.Top;
instruction_lbl.Top = groupBox1.Height + 15;
this.Height = instruction_lbl.Top + instruction_lbl.Height + 40;
break;
}
switch (card_type)
{
case 0:
case 1: // MEMBERCARD
queryString = @"
SELECT
A.CARD_NO,
B.*, C.CODE
FROM MEMBERCARD A
INNER JOIN MEMBERCARD_TYPE B ON A.MEMBERCARD_TYPE_ID = B.MEMBERCARD_TYPE_ID
INNER JOIN CUSTOMER C ON A.CUSTOMER_ID = C.CUSTOMER_ID
WHERE A.MEMBERCARD_ID = " + GF.selected_id.ToString();
using (DT = DB.getS(queryString, null, "GET DATA FROM MEMBERCARD_TYPE", false))
{
file1 = DT.Rows[0]["FRONT_CARD"].ToString();
file2 = DT.Rows[0]["BACK_CARD"].ToString();
file3 = DT.Rows[0]["ATTACH_PAPER"].ToString();
customer_code = DT.Rows[0]["CODE"].ToString();
if (card_no == "")
{
card_no = DT.Rows[0]["CARD_NO"].ToString();
}
}
break;
case 2: // GIFT CERTIFICATE
queryString = "SELECT A.*, B.RUS_NAME FROM GIFT_CERTIFICATE A LEFT OUTER JOIN SPA_PROGRAM B ON A.SPA_PROGRAM_ID = B.SPA_PROGRAM_ID WHERE A.GIFT_CERTIFICATE_ID = " + GF.selected_id.ToString();
using (DT = DB.getS(queryString, null, "GET SPA_PROGRAM_NAME FROM GIFT_CERTIFICATE[" + GF.selected_id.ToString() + "]", false))
{
if (DT.Rows.Count == 1)
{
spaProgramName = DT.Rows[0]["RUS_NAME"].ToString();
if (DT.Rows[0]["BALANCE_MAX"].ToString() != "")
{
price = DT.Rows[0]["BALANCE_MAX"].ToString();
}
else
{
price = DT.Rows[0]["PRICE"].ToString();
}
from_txt = DT.Rows[0]["FROM_TXT"].ToString();
for_txt = DT.Rows[0]["FOR_TXT"].ToString();
if (card_no == "")
{
card_no = DT.Rows[0]["CARD_NO"].ToString();
}
}
}
queryString = "SELECT * FROM GIFT_CERTIFICATE_CONFIG";
DT = DB.getS(queryString, null, "GET GIFT_CERTIFICATE_CONFIG", false);
file1 = DT.Rows[0]["CARD1"].ToString();
file3 = DT.Rows[0]["CARD2"].ToString();
break;
case 3: // GIFT VOUCHER
String[] tmp = GF.tmpText.Split();
if (!isReIssue)
{
if (GF.selected_id.ToString() != "-1")
{
queryString = "SELECT RUS_NAME FROM SPA_PROGRAM WHERE SPA_PROGRAM_ID = " + GF.selected_id.ToString();
using (DT = DB.getS(queryString, null, "GET RUS_NAME OF SPA_PROGRAM_NAME FROM GIFT_VOUCHER", false))
{
spaProgramName = DT.Rows[0]["RUS_NAME"].ToString();
}
}
else
{
spaProgramName = "ALL SPA PROGRAM " + tmp[0] + " " + tmp[1];
}
}
else
{
if (GF.selected_id.ToString() != "-1")
{
queryString = "SELECT B.RUS_NAME FROM GIFT_VOUCHER A INNER JOIN SPA_PROGRAM B ON A.SPA_PROGRAM_ID = B.SPA_PROGRAM_ID WHERE A.GIFT_VOUCHER_ID = " + GF.selected_id.ToString();
using (DT = DB.getS(queryString, null, "GET RUS_NAME OF SPA_PROGRAM_NAME FROM GIFT_VOUCHER", false))
{
spaProgramName = DT.Rows[0]["RUS_NAME"].ToString();
}
}
else
{
spaProgramName = "ALL SPA PROGRAM " + tmp[0] + " " + tmp[1];
}
}
queryString = "SELECT * FROM GIFT_VOUCHER_CONFIG";
using (DT = DB.getS(queryString, null, "GET GIFT_VOUCHER_CONFIG", false))
{
file1 = DT.Rows[0]["CARD"].ToString();
}
break;
}
if (!isReIssue)
{
expire_amount = Convert.ToInt32(DT.Rows[0]["EXPIRE_AMOUNT"].ToString());
expire_unit = Convert.ToInt32(DT.Rows[0]["EXPIRE_UNIT"].ToString());
if (expire_amount.ToString() != "0")
{
DateTime expiryDate = new DateTime();
if (expire_unit == 0)
{
expiryDate = DateTime.Now.AddMonths(expire_amount);
}
if (expire_unit == 1)
{
expiryDate = DateTime.Now.AddYears(expire_amount);
}
expire_date = expiryDate.Day.ToString("00") + "/" + expiryDate.Month.ToString("00") + "/" + expiryDate.Year.ToString();
}
if (card_type == 3)
{
card_no = (DateTime.Now.Year + 543).ToString() + DateTime.Now.Month.ToString("00") + DateTime.Now.Day.ToString("00") + DateTime.Now.Hour.ToString("00") + DateTime.Now.Minute.ToString("00") + DateTime.Now.Second.ToString("00") + new Random().Next(1, 100).ToString("00");
}
switch (card_type)
{
case 0:
case 1: // MEMBERCARD
break;
case 2:
insertString = "UPDATE GIFT_CERTIFICATE SET IS_PAID = 1, IS_USE = 1 WHERE GIFT_CERTIFICATE_ID = " + GF.selected_id.ToString();
break;
case 3: // GIFT_VOUCHER
String[] tmp = GF.tmpText.Split(' ');
insertString = "INSERT INTO GIFT_VOUCHER (" + (billID != -1 ? "BILL_ID, " : "") + "CARD_NO, SPA_PROGRAM_ID, EXPIRY_DATE, DISCOUNT_AMOUNT, DISCOUNT_UNIT, ISSUE_BY, APPROVED_BY, ISSUE_FOR";
if (member_card_id != -1)
{
insertString += ", MEMBERCARD_ID";
}
insertString += ") SELECT " + (billID != -1 ? billID.ToString() + ", " : "") + "'" + card_no + "', " + GF.selected_id.ToString() + ", ";
if (GF.selected_id.ToString() != "-1")
{
insertString += "DATEADD(";
if (expire_unit == 0)
{
insertString += "MONTH";
}
if (expire_unit == 1)
{
insertString += "YEAR";
}
insertString += ", " + expire_amount.ToString() + ", GETDATE()), ";
}
else
{
insertString += GF.modDate(tmp[2]) + ", ";
}
insertString += tmp[0] + ", ";
insertString += (tmp[1].Trim() == "%" ? "0, " : "1, ");
insertString += GF.emp_id.ToString() + ", " + approved_id.ToString() + ", '" + gv_issue_for + "'";
if (member_card_id != -1)
{
insertString += ", " + member_card_id.ToString();
}
insertString += " FROM GIFT_VOUCHER_CONFIG WHERE GIFT_VOUCHER_CONFIG_ID = 1";
break;
}
if (insertString.Trim() != "")
{
DB.beginTrans();
GF.doDebug(">>>>>>>>>> " + insertString);
if (!DB.set(insertString, "INSERT INTO " + type_name[card_type] + " TABLE"))
{
GF.closeLoading();
MessageBox.Show("ERROR INSERT INTO " + type_name[card_type] + " TABLE !!", "ERROR");
return;
}
else
{
DB.close();
}
}
}
else
{
switch (card_type)
{
case 0:
case 1: // MEMBERCARD
queryString = "SELECT CARD_NO, CONVERT(NVARCHAR(MAX), EXPIRE_DATE, 103) EXPIRY_DATE FROM MEMBERCARD WHERE MEMBERCARD_ID = " + GF.selected_id.ToString();
DT = DB.getS(queryString, null, "GET CARD_NO, EXPIRY_DATE FROM MEMBERCARD[" + GF.selected_id.ToString() + "]", false);
break;
case 2:
queryString = "SELECT CARD_NO, CONVERT(NVARCHAR(MAX), EXPIRY_DATE, 103) EXPIRY_DATE FROM GIFT_CERTIFICATE WHERE GIFT_CERTIFICATE_ID = " + GF.selected_id.ToString();
DT = DB.getS(queryString, null, "GET CARD_NO, EXPIRY_DATE FROM GIFT_CERTIFICATE[" + GF.selected_id.ToString() + "]", false);
break;
case 3:
queryString = "SELECT CARD_NO, CONVERT(NVARCHAR(MAX), EXPIRY_DATE, 103) EXPIRY_DATE FROM GIFT_VOUCHER WHERE GIFT_VOUCHER_ID = " + GF.selected_id.ToString();
DT = DB.getS(queryString, null, "GET CARD_NO, EXPIRY_DATE FROM GIFT_VOUCHER[" + GF.selected_id.ToString() + "]", false);
break;
}
card_no = DT.Rows[0]["CARD_NO"].ToString();
expire_date = DT.Rows[0]["EXPIRY_DATE"].ToString();
DT.Dispose();
}
}
