void doLoadGridData(object sender, EventArgs e)
{
item_code_lbl.Top = GF.pageTop;
code.Top = item_code_lbl.Top - 3;
item_cat_lbl.Top = item_name_lbl.Top = item_code_lbl.Top + 27;
item_name.Top = item_cat_lbl.Top - 3;
item_cat.Top = item_name.Top - 3;
line_sep1.Top = item_cat_lbl.Top + 35; line_sep1.Width = btn_dgv.Width;
btn_dgv.rearrange(line_sep1.Top + 15);
GF.resetAC(this);
loadGridData();
}
void EnableClick(object sender, EventArgs e)
{
string the_id = btn_dgv.DGV.SelectedRows[0].Cells[btn_dgv.DGV.Columns.Count - 1].Value.ToString();
queryString = "UPDATE COUPON_SET_CONFIG SET IS_USE = 1 WHERE COUPON_SET_CONFIG_ID = " + the_id;
GF.showLoading(this);
if (!DB.set(queryString, "ENABLE COUPON_SET_CONFIG[" + the_id + "]"))
{
MessageBox.Show("ERROR ENABLE THE COUPON SET !!", "ERROR");
GF.closeLoading();
}
DB.close();
GF.closeLoading();
loadData();
}
/// <summary>
/// 掛け算
/// </summary>
/// <param name="val1"></param>
/// <param name="val2"></param>
/// <returns></returns>
public static GF operator *(GF val1, GF val2)
{
GF result;
if (val1 == null || val2 == null || val1.val == 0 || val2.val == 0)
{
result = new GF(0, InKind.inVal);
}
else
{
result = new GF((short)((val1.exp + val2.exp) % (RS.GF_MOD - 1)), InKind.inExp);
}
return(result);
}
public Monster_Spell_Effect_Flag(int index, Monster_Spell_Flag method, GF gf, bool timed, Timed_Effect flag,
random_value Base, random_value dam, int chance, bool save, Object_Flag res_flag, random_value power)
{
this.index = index;
this.method = method;
this.gf = gf;
this.timed = timed;
this.flag = flag;
this.Base = Base;
this.dam = dam;
this.chance = chance;
this.save = save;
this.res_flag = res_flag;
this.power = power;
}
public program_manage()
{
InitializeComponent();
GF.doDebug("===== CHILD FORM :: " + this.Name + " IS OPENED =====");
this.FormClosing += (s, e) =>
{
GF.doDebug("===== CHILD FORM :: " + this.Name + " IS CLOSED =====");
};
program_type_id.Items.Add(new ComboItem(-1, "== PROGRAM TYPE =="));
program_type_id.SelectedIndex = 0;
GF.enableButton(new_item_btn);
GF.disableButton(edit_item_btn);
}
void DeleteClick(object sender, EventArgs e)
{
string the_id = btn_dgv.DGV.SelectedRows[0].Cells["debtor_id"].Value.ToString();
queryString = "UPDATE DEBTOR SET IS_USE = 0 WHERE DEBTOR_ID = " + the_id;
GF.showLoading(this);
if (!DB.set(queryString, "DISABLE DEBTOR[" + the_id + "]"))
{
MessageBox.Show("ERROR DISABLE THE DEBTOR !!", "ERROR");
GF.closeLoading();
}
DB.close();
GF.closeLoading();
loadGridData();
}
void DeleteClick(object sender, EventArgs e)
{
string the_id = btn_dgv.DGV.SelectedRows[0].Cells[btn_dgv.DGV.Columns.Count - 1].Value.ToString();
queryString = "UPDATE AGENT SET IS_USE = 0 WHERE AGENT_ID = " + the_id;
GF.showLoading(this);
if (!DB.set(queryString, "DISABLE AGENT[" + the_id + "]"))
{
MessageBox.Show("ERROR DISABLE THE AGENT !!", "ERROR");
GF.closeLoading();
}
DB.close();
GF.closeLoading();
loadGridData();
}
private void manage_btn_Click(object sender, EventArgs e)
{
if (expire_amount.Text.Trim() == "")
{
MessageBox.Show("PLEASE ENTER THE EXPIRY DETAIL !!", "ERROR");
expire_amount.Select();
return;
}
GF.showLoading(this);
string queryString = "SELECT * FROM GIFT_VOUCHER_CONFIG";
using (DataTable DT = DB.getS(queryString, null, "CHECK GIFT_VOUCHER_CONFIG IF EXISTED", false))
{
if (DT.Rows.Count == 0)
{
queryString = "INSERT INTO GIFT_VOUCHER_CONFIG ( EXPIRE_AMOUNT, EXPIRE_UNIT ) VALUES (";
queryString += expire_amount.Text.Trim() + ", ";
queryString += ((ComboItem)expire_unit.SelectedItem).Key.ToString() + "')";
}
if (DT.Rows.Count == 1)
{
queryString = "UPDATE GIFT_VOUCHER_CONFIG SET ";
queryString += "EXPIRE_AMOUNT = " + expire_amount.Text.Trim() + ", ";
queryString += "EXPIRE_UNIT = " + ((ComboItem)expire_unit.SelectedItem).Key.ToString() + ", ";
queryString = queryString.Substring(0, queryString.Length - 2) + " ";
queryString += "WHERE GIFT_VOUCHER_CONFIG_ID = 1";
}
}
DB.beginTrans();
if (DB.set(queryString, manage_btn.Text.Trim() + " GIFT VOUCHER CONFIG"))
{
DB.close();
MessageBox.Show("GIFT VOUCHER CONFIG IS " + (manage_btn.Text.Trim() == "ADD" ? "ADDE" : manage_btn.Text.Trim()) + "D !!", "COMPLETED");
GF.closeLoading();
this.Close();
return;
}
else
{
MessageBox.Show("ERROR INSERT INTO DATABASE !!", "ERROR");
GF.closeLoading();
return;
}
}
public bool ConfirmBooking(BookingDTO objBooking)
{
try
{
if (oDB == null)
{
oDB = new DatabaseManager();
}
string sProcName = "up_Booking_Confirmation";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iBookingID", DbType.Int32, objBooking.BookingId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sExOrderNo", DbType.String, objBooking.ExchangeOrderNo);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@dtVoucherDate", DbType.DateTime, GF.Handle19000101(objBooking.VoucherDate, false));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@dtArrivalDT", DbType.DateTime, GF.HandleMaxMinDates(objBooking.ArrivalDateTime, true));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sArrivalTransport", DbType.String, objBooking.ArrivalTransport);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iArrivalCityId", DbType.Int32, objBooking.ArrivalCityId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@dtDepartureDT", DbType.DateTime, GF.HandleMaxMinDates(objBooking.DepartureDateTime, true));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sDepartureTransport", DbType.String, objBooking.DepartureTransport);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iDepartureCityId", DbType.Int32, objBooking.DepartureCityId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sArrivalVehicleNo", DbType.String, objBooking.ArrivalVehicleNo);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sArrivalTransportCompany", DbType.String, objBooking.ArrivalTransportCompany);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sDepartureVehicleNo", DbType.String, objBooking.DepartureVehicleNo);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sDepartureTransportCompany", DbType.String, objBooking.DepartureTransportCompany);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sTourID", DbType.String, objBooking.TourId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ArrivalVehicleNameType", DbType.String, objBooking.ArrivalVehicleNameType);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ArrivalTransportCompanyPhoneNo", DbType.String, objBooking.ArrivalTransportCompanyPhoneNo);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ArrivalDriverPhoneNo", DbType.String, objBooking.ArrivalDriverPhoneNo);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DepartureVehicleNameType", DbType.String, objBooking.DepartureVehicleNameType);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DepartureTransportCompanyPhoneNo", DbType.String, objBooking.DepartureTransportCompanyPhoneNo);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DepartureDriverPhoneNo", DbType.String, objBooking.DepartureDriverPhoneNo);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@arrivalTransportId", DbType.String, objBooking.ArrivalTransportId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@departureTransportId", DbType.String, objBooking.DepartureTransportId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
objBooking = null;
GF.LogError("clsBookingConfirmationHandler.ConfirmBooking", exp.Message);
}
return(true);
}
public RoomBookingDateWiseDTO[] GetWaitListedBookings(DateTime StartDate, DateTime EndDate, int notThisBookingId, int AccomId)
{
RoomBookingDateWiseDTO[] oBookingRoomDataDateWise;
DataSet dsRoomOtherBookings;
DataRow dr;
string sProcName;
DatabaseManager oDB;
dsRoomOtherBookings = null;
oBookingRoomDataDateWise = null;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_WaitListedBookings";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@StartDate", DbType.Date, StartDate);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EndDate", DbType.Date, EndDate);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@notThisBookingId", DbType.Int32, notThisBookingId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomId", DbType.Int32, AccomId);
dsRoomOtherBookings = oDB.ExecuteDataSet(oDB.DbCmd);
oDB = null;
}
catch (Exception exp)
{
oDB = null;
dsRoomOtherBookings = null;
GF.LogError("clsBookingRoomHandler.GetRoomOtherBookings", exp.Message);
}
if (dsRoomOtherBookings != null && dsRoomOtherBookings.Tables.Count > 0)
{
if (dsRoomOtherBookings.Tables[0].Rows.Count > 0)
{
oBookingRoomDataDateWise = new RoomBookingDateWiseDTO[dsRoomOtherBookings.Tables[0].Rows.Count];
for (int i = 0; i < dsRoomOtherBookings.Tables[0].Rows.Count; i++)
{
dr = dsRoomOtherBookings.Tables[0].Rows[i];
oBookingRoomDataDateWise[i] = new RoomBookingDateWiseDTO();
oBookingRoomDataDateWise[i].BookingId = Convert.ToInt32(dr.ItemArray.GetValue(0));
oBookingRoomDataDateWise[i].BookingCode = Convert.ToString(dr.ItemArray.GetValue(1)).Trim();
oBookingRoomDataDateWise[i].AccomodationId = Convert.ToInt32(dr.ItemArray.GetValue(2));
oBookingRoomDataDateWise[i].Startdate = Convert.ToDateTime(dr.ItemArray.GetValue(3).ToString());
oBookingRoomDataDateWise[i].Enddate = Convert.ToDateTime(dr.ItemArray.GetValue(4).ToString());
oBookingRoomDataDateWise[i].BookingReference = Convert.ToString(dr.ItemArray.GetValue(5)).Trim();
}
}
}
return(oBookingRoomDataDateWise);
}
// DELEGATE PART :: END
public void loadGridData()
{
GF.showLoading(this);
this.btn_dgv.DGV.Rows.Clear();
if (btn_dgv.DGV.Columns.Count == 0)
{
this.btn_dgv.DGV.Columns.Add("year_no", "YEAR");
this.btn_dgv.DGV.Columns.Add("day_name", "DAY NAME");
this.btn_dgv.DGV.Columns.Add("start_date", "START DATE");
this.btn_dgv.DGV.Columns.Add("end_date", "END DATE");
this.btn_dgv.DGV.Columns.Add("emp_config_yearly_dayoff_id", "EMP_CONFIG_YEARLY_DAYOFF_ID");
this.btn_dgv.DGV.Columns["emp_config_yearly_dayoff_id"].Visible = false;
}
// GET TOTAL PAGE
String queryString = @"SELECT EMP_CONFIG_YEARLY_DAYOFF_ID, YEAR_NO, DAY_NAME, CONVERT(VARCHAR,START_DATE,103) START_DATE, CONVERT(VARCHAR,END_DATE,103) END_DATE FROM EMP_CONFIG_YEARLY_DAYOFF WHERE 1=1";
if (((ComboItem)this.year.SelectedItem).Key != -1)
{
queryString += " AND year_no = " + ((ComboItem)this.year.SelectedItem).Key.ToString();
}
;
GF.getTotalPage(btn_dgv, queryString, null);
queryString = DB.insertRowNum("year_no DESC, start_date ASC", queryString);
using (DataTable myDT = DB.getS(queryString, null, "GET ALL EMP CONFIG YEARLY_DAYOFF"))
{
int rowNum = 0;
foreach (DataRow myRow in myDT.Rows)
{
this.btn_dgv.DGV.Rows.Add(
myRow["year_no"],
myRow["day_name"].ToString().Trim(),
myRow["start_date"].ToString().Split(' ')[0].ToString(),
myRow["end_date"].ToString().Split(' ')[0].ToString(),
myRow["emp_config_yearly_dayoff_id"]
);
this.btn_dgv.DGV[1, rowNum].Style.Alignment = DataGridViewContentAlignment.MiddleLeft;
rowNum++;
}
}
GF.updateRowNum(btn_dgv.DGV, true);
this.btn_dgv.DGV.ClearSelection();
GF.closeLoading();
}
public store()
{
InitializeComponent();
code_lbl.Top = item_name_lbl.Top = item_cat_lbl.Top = GF.pageTop;
code.Top = item_name.Top = item_name_lbl.Top - 3;
line_sep.Top = item_name_lbl.Top + 35; line_sep.Width = btn_dgv.Width;
btn_dgv.preventDGVSelectionChanged = true;
btn_dgv.edit_btn.Visible = false;
//btn_dgv.add_btn.Left = btn_dgv.edit_btn.Left;
btn_dgv.del_btn.Text = "OUT";// btn_dgv.del_btn.Width = 146; btn_dgv.del_btn.Left = 1749;
btn_dgv.add_btn.Text = "IN"; btn_dgv.add_btn.Left = btn_dgv.del_btn.Left - btn_dgv.add_btn.Width - 5;
btn_dgv.refresh_btn.Text = "SEARCH BY BARCODE"; btn_dgv.refresh_btn.Width = 209;
//btn_dgv.search_btn.Left = btn_dgv.refresh_btn.Left + btn_dgv.refresh_btn.Width + 5;
btn_dgv.search_btn.Visible = false;
item_cat.Items.Clear();
item_cat.Items.Add(new ComboItem(-1, "== CATEGORY =="));
string queryString = "SELECT * FROM ITEM_TYPE WHERE IS_USE = 1 ORDER BY ITEM_TYPE_NAME ASC";
using (DataTable DT = DB.getS(queryString, null, "GET ITEM CATEGORIES", false))
{
foreach (DataRow row in DT.Rows)
{
item_cat.Items.Add(new ComboItem(Convert.ToInt32(row["ITEM_TYPE_ID"].ToString()), row["ITEM_TYPE_NAME"].ToString()));
}
}
item_cat.SelectedIndex = 0;
GF.enableButton(btn_dgv.del_btn);
//UC EVENTS
btn_dgv.AddClick += new btn_dgv.AddClickHandler(AddClick);
btn_dgv.DeleteClick += new btn_dgv.DeleteClickHandler(DeleteClick);
btn_dgv.RefreshClick += new btn_dgv.RefreshClickHandler(BarcodeClick);
//PAGING DELEGATE
btn_dgv.firstClick += new btn_dgv.firstClickHandler(doLoadGridData);
btn_dgv.prevClick += new btn_dgv.prevClickHandler(doLoadGridData);
btn_dgv.nextClick += new btn_dgv.nextClickHandler(doLoadGridData);
btn_dgv.lastClick += new btn_dgv.lastClickHandler(doLoadGridData);
btn_dgv.pageNumberChanged += new btn_dgv.pageNumberChangedHandler(doLoadGridData);
}
public Tasks_result Get(string Team_ID)
{
if (!GF.session_check())
{
return(new Tasks_result(5));
}
if (!GF.Check_if_Admin(Team_ID))
{
return(new Tasks_result(0));
}
usid = GF.get_usid();
Get_Tasks(Team_ID);
return(new Tasks_result(Tasks));
}
private BookingTouristDTO[] GetIndianNationalsData(BookingTouristDTO[] bookingTouristDetailsDto)
{
List <BookingTouristDTO> bookingTouristList = new List <BookingTouristDTO>();
BookingTouristDTO bookingTouristDTO;
for (int i = 0; i < bookingTouristDetailsDto.Length; i++)
{
if (bookingTouristDetailsDto[i].NationalityId == GF.GetIndianNatinalityId())
{
bookingTouristDTO = new BookingTouristDTO();
bookingTouristDTO = bookingTouristDetailsDto[i];
bookingTouristList.Add(bookingTouristDTO);
}
}
return(bookingTouristList.ToArray());
}
void DeleteClick(object sender, EventArgs e)
{
string the_id = btn_dgv.DGV.SelectedRows[0].Cells[btn_dgv.DGV.Columns.Count - 1].Value.ToString();
string is_use = (btn_dgv.del_btn.Text == "DISABLE" ? "0" : "1");
queryString = "UPDATE COUPON_SET_CONFIG SET IS_USE = " + is_use + " WHERE COUPON_SET_CONFIG_ID = " + the_id;
GF.showLoading(this);
if (!DB.set(queryString, btn_dgv.del_btn.Text + " COUPON_SET_CONFIG[" + the_id + "]"))
{
MessageBox.Show("ERROR " + btn_dgv.del_btn.Text + " THE COUPON SET !!", "ERROR");
GF.closeLoading();
}
DB.close();
GF.closeLoading();
loadData();
}
private void reservation_approve_Load(object sender, EventArgs e)
{
approved_by.Items.Add(new ComboItem(-1, "APPROVER"));
approved_by.Items.Add(new ComboItem(0, "S.A."));
String queryString = "SELECT EMP_ID, FULLNAME FROM EMPLOYEE WHERE EMP_STATUS=1 AND CAN_APPROVE=1 ORDER BY FULLNAME";
using (DataTable DT = DB.getS(queryString, null, "GET APPROVABLE EMPLOYEE", false))
{
foreach (DataRow row in DT.Rows)
{
approved_by.Items.Add(new ComboItem(Convert.ToInt32(row["EMP_ID"].ToString()), row["FULLNAME"].ToString()));
}
}
approved_by.SelectedIndex = 0;
GF.resizeComboBox(approved_by);
}
public contract_rate_detail()
{
InitializeComponent();
GF.doDebug("===== CHILD FORM :: " + this.Name + " IS OPENED =====");
this.FormClosing += (s, e) =>
{
GF.doDebug("===== CHILD FORM :: " + this.Name + " IS CLOSED =====");
};
btn_dgv.DGV.EditMode = DataGridViewEditMode.EditOnEnter;
btn_dgv.hideTopPanel();
btn_dgv.paging_panel.Visible = false;
btn_dgv.Left = 10;
this.Height = 800;
btn_dgv.DGV.RowHeadersVisible = false;
}
private void register_gift_certificate_Load(object sender, EventArgs e)
{
queryString = "SELECT * FROM SPA_PROGRAM WHERE IS_USE = 1 ORDER BY CODE";
using (DataTable DT = DB.getS(queryString, null, "GET ALL ACTIVE SPA PROGRAM", false))
{
price_list = new List <string>();
spa_program_id.Items.Add(new ComboItem(-1, "== SPA PROGRAM =="));
foreach (DataRow row in DT.Rows)
{
spa_program_id.Items.Add(new ComboItem(Convert.ToInt32(row["SPA_PROGRAM_ID"].ToString()), "[#" + row["CODE"].ToString() + "] " + row["PROGRAM_NAME"].ToString()));
price_list.Add(row["PRICE"].ToString());
}
}
spa_program_id.SelectedIndex = 0;
GF.resizeComboBox(spa_program_id);
discount_unit.Items.Clear();
discount_unit.Items.Add(new ComboItem(0, "%"));
discount_unit.Items.Add(new ComboItem(1, Properties.Settings.Default.money_unit));
discount_unit.SelectedIndex = 0;
GF.resizeComboBox(discount_unit);
int expire_amount = -1;
int expire_unit = -1;
queryString = "SELECT * FROM GIFT_CERTIFICATE_CONFIG";
using (DataTable DT = DB.getS(queryString, null, "GET GIFT CERTIFICATE CONFIG", false))
{
// GET GIFT CERTIFICATE CONFIG
expire_amount = Convert.ToInt32(DT.Rows[0]["EXPIRE_AMOUNT"].ToString());
expire_unit = Convert.ToInt32(DT.Rows[0]["EXPIRE_UNIT"].ToString());
}
DateTime theExpiryDate = Convert.ToDateTime(GF.TODAY());
if (expire_unit == 0)
{
theExpiryDate = theExpiryDate.AddMonths(expire_amount);
}
if (expire_unit == 1)
{
theExpiryDate = theExpiryDate.AddYears(expire_amount);
}
expiry_date.Text = theExpiryDate.ToString();
card_no.Select();
}
public debtor_data()
{
InitializeComponent();
GF.addKeyUp(this);
debtor_type_id.Items.Add(new ComboItem(-1, "ALL"));
queryString = "SELECT * FROM DEBTOR_TYPE ORDER BY DEBTOR_TYPE_ID";
using (DataTable DT = DB.getS(queryString, null, "GET DEBTOR_TYPE", false))
{
foreach (DataRow row in DT.Rows)
{
debtor_type_id.Items.Add(new ComboItem(Convert.ToInt32(row["DEBTOR_TYPE_ID"].ToString()), row["DEBTOR_TYPE_NAME"].ToString()));
}
}
debtor_type_id.SelectedIndex = 0;
btn_dgv.refresh_btn.Text = "DEBT LIST";
GF.disableButton(btn_dgv.refresh_btn);
btn_dgv.DGV.SelectionChanged += (s, e) =>
{
if (btn_dgv.DGV.SelectedRows.Count == 1)
{
GF.enableButton(btn_dgv.refresh_btn);
}
else
{
GF.disableButton(btn_dgv.refresh_btn);
}
};
//UC EVENTS
btn_dgv.AddClick += new btn_dgv.AddClickHandler(AddClick);
btn_dgv.EditClick += new btn_dgv.EditClickHandler(EditClick);
btn_dgv.DeleteClick += new btn_dgv.DeleteClickHandler(DeleteClick);
btn_dgv.EnableClick += new btn_dgv.EnableClickHandler(EnableClick);
btn_dgv.RefreshClick += new btn_dgv.RefreshClickHandler(DebtListClick); // USE REFRESH BUTTON AS DEBT LIST BUTTON
btn_dgv.SearchClick += new btn_dgv.SearchClickHandler(doLoadGridData);
//PAGING DELEGATE
btn_dgv.firstClick += new btn_dgv.firstClickHandler(doLoadGridData);
btn_dgv.prevClick += new btn_dgv.prevClickHandler(doLoadGridData);
btn_dgv.nextClick += new btn_dgv.nextClickHandler(doLoadGridData);
btn_dgv.lastClick += new btn_dgv.lastClickHandler(doLoadGridData);
btn_dgv.pageNumberChanged += new btn_dgv.pageNumberChangedHandler(doLoadGridData);
}
private void receive_TextChanged(object sender, EventArgs e)
{
Double receiveAmount = 0;
if (receive.Text.Trim() != "")
{
receiveAmount = Double.Parse(receive.Text.Trim().Replace(GF.thousandSep, ""));
}
Double changeAmount = receiveAmount - Double.Parse(grand_total.Text.Trim().Replace(GF.thousandSep, ""));
if (changeAmount < 0)
{
changeAmount = 0;
}
change.Text = GF.formatDecimal(changeAmount);
}
private DataSet GetDataFromDB(string Query)
{
DatabaseManager oDB = new DatabaseManager();
DataSet ds = null;
try
{
oDB.DbCmd = oDB.GetSqlStringCommand(Query);
//DataSet ds = oDB.FetchRecords("tblBookingDetails", Query);
ds = oDB.ExecuteDataSet(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsDepartmentMaster.GetDataFromDB", exp.Message);
}
return(ds);
}
private void first_btn_Click(object sender, EventArgs e)
{
GF.showLoading((this.Parent as Form));
page.Text = "1";
GF.disableBtn(first_btn);
GF.disableBtn(prev_btn);
if (Convert.ToInt32(page.Text.Trim()) < Convert.ToInt32(max_page.Text.Trim()))
{
GF.enableBtn(next_btn, Color.DodgerBlue);
GF.enableBtn(last_btn, Color.DodgerBlue);
}
onFirstClick(EventArgs.Empty);
}
bool validate(out Dictionary <string, string> postParam)
{
postParam = null;
if (string.IsNullOrEmpty(pagination.page.Text.Trim()))
{
GF.Error("ยังไม่ได้ระบุ 'หน้าที่' !");
pagination.page.Select();
return(false);
}
postParam = new()
{
{ "page", pagination.page.Text.Trim() }
};
return(true);
}
private void branch_list_ItemCheck(object sender, ItemCheckEventArgs e)
{
if (isReady)
{
isReady = false;
GF.showLoading(this);
if (e.NewValue == CheckState.Checked)
{
for (int i = 0; i < branch_list.Items.Count; i++)
{
branch_list.SetItemCheckState(i, CheckState.Unchecked);
}
}
isReady = true;
GF.closeLoading();
}
}
private void therapist1_SelectedIndexChanged(object sender, EventArgs e)
{
if (therapist1.SelectedIndex > 0 && masseur_use > 1)
{
if (therapist1_id == -1)
{
therapist1_id = ((ComboItem)therapist1.SelectedItem).Key;
}
GF.showLoading(this);
getTherapist(ref therapist2, ((ComboItem)therapist1.SelectedItem).Key);
GF.closeLoading();
}
else
{
therapist2.SelectedIndex = 0;
}
}
/// <summary>
/// Converts the .gf pixel data to raw bitmap data of a specified size
/// </summary>
/// <param name="gf">The GF file data</param>
/// <param name="width">The image width</param>
/// <param name="height">The image height</param>
/// <param name="offset">The offset in the pixel array</param>
/// <returns>The raw image data</returns>
public static RawBitmapData GetRawBitmapData(this GF gf, int width, int height, int offset = 0)
{
// Check if the size is scaled
bool isScaled = gf.Width != width || gf.Height != height;
// Get the scale factors
double widthScale = gf.Width / (double)width;
double heightScale = gf.Height / (double)height;
// Get the format
GF_Format format = gf.PixelFormat;
// Get the pixel format
PixelFormat pixelFormat = format.SupportsTransparency() ? PixelFormat.Format32bppArgb : PixelFormat.Format24bppRgb;
// Get the number of bitmap channels
int bmpChannels = Image.GetPixelFormatSize(pixelFormat) / 8;
// Create the pixel array
byte[] rawPixelData = new byte[width * height * bmpChannels];
// Enumerate each pixel
for (uint y = 0; y < height; y++)
{
for (uint x = 0; x < width; x++)
{
// Get the offsets for the pixel colors
var pixelOffset = isScaled
? (long)((gf.Width * Math.Floor((y * heightScale)) + Math.Floor((x * widthScale))) * gf.Channels + offset)
: (width * y + x) * gf.Channels + offset;
// NOTE: We reverse the Y-axis here since the .gf images are always flipped vertically
long rawOffset = (width * (height - y - 1) + x) * bmpChannels;
// Get the pixels
foreach (var b in gf.GetBGRAPixel(format, gf.PixelData, pixelOffset))
{
rawPixelData[rawOffset] = b;
rawOffset++;
}
}
}
// Return the raw bitmap data
return(new RawBitmapData(width, height, rawPixelData, pixelFormat));
}
public void resetPagination(string rowCount)
{
total_record.Text = rowCount;
if (rowCount == "0")
{
max_page.Text = "0";
}
else
{
max_page.Text = ((Convert.ToInt32(rowCount) / GF.rowsPerPage) + 1).ToString();
if (Convert.ToInt32(max_page.Text.Trim()) <= 1)
{
page.Text = max_page.Text;
GF.disableBtn(first_btn);
GF.disableBtn(prev_btn);
GF.disableBtn(next_btn);
GF.disableBtn(last_btn);
page.Enabled = false;
this.Enabled = false;
}
else
{
GF.enableBtn(first_btn, Color.DodgerBlue);
GF.enableBtn(prev_btn, Color.DodgerBlue);
GF.enableBtn(next_btn, Color.DodgerBlue);
GF.enableBtn(last_btn, Color.DodgerBlue);
page.Enabled = true;
this.Enabled = true;
}
}
if (page.Text.Trim() == "1")
{
GF.disableBtn(first_btn);
GF.disableBtn(prev_btn);
}
if (page.Text.Trim() == max_page.Text.Trim())
{
GF.disableBtn(next_btn);
GF.disableBtn(last_btn);
}
GF.closeLoading();
}
private bool ValidateValues()
{
if (txtUserName.Text.Trim() == "")
{
lblStatus.Text = "Please enter User Name.";
return(false);
}
if (!String.IsNullOrEmpty(txtUserEmailId.Text))
{
if (!GF.ValidateEmailId(txtUserEmailId.Text.Trim()))
{
lblStatus.Text = "Please enter correct email id.";
return(false);
}
}
return(true);
}
public Ann_Result Get(string Team_ID)
{
if (!GF.session_check())
{
return(new Ann_Result(5));
}
User_Id = GF.get_usid();
if (GF.Check_if_Joined(Team_ID))
{
return(new Ann_Result(Get_Ann(Team_ID)));
}
else
{
return(new Ann_Result(0));
}
}
private bool Insert(BookingWaitListDTO[] oBookingWaitListData)
{
string sProcName = string.Empty;
try
{
if (oBookingWaitListData != null && oBookingWaitListData.Length > 0)
{
if (oDB == null)
{
oDB = new DatabaseManager();
}
//sProcName = "up_Ins_BookingWaitList2";
sProcName = "up_Ins_BookingWaitList3";
for (int i = 0; i < oBookingWaitListData.Length; i++)
{
if (oBookingWaitListData[i] != null)
{
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iBookingId", DbType.Int32, oBookingWaitListData[i].BookingId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomId", DbType.Int32, oBookingWaitListData[i].AccomId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iRoomCategoryId", DbType.Int32, oBookingWaitListData[i].RoomCategoryId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iRoomTypeId", DbType.Int32, oBookingWaitListData[i].RoomTypeId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iNo_Of_Rooms_Waitlisted", DbType.Int32, oBookingWaitListData[i].No_Of_RoomsWaitListed);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@pax", DbType.Int32, oBookingWaitListData[i].paxstying);
oDB.ExecuteNonQuery(oDB.DbCmd);
oDB.DbCmd.Parameters.Clear();
}
}
}
}
catch (Exception exp)
{
oDB = null;
oBookingWaitListData = null;
GF.LogError("clsBookingWaitListHandler.SaveData", exp.Message);
return(false);
}
finally
{
oDB = null;
oBookingWaitListData = null;
}
return(true);
}
public bool timed; /* true if timed, false if permanent */
#endregion Fields
#region Constructors
public Monster_Spell_Effect_Flag(int index, Monster_Spell_Flag method, GF gf, bool timed, Timed_Effect flag,
random_value Base, random_value dam, int chance, bool save, Object_Flag res_flag, random_value power)
{
this.index = index;
this.method = method;
this.gf = gf;
this.timed = timed;
this.flag = flag;
this.Base = Base;
this.dam = dam;
this.chance = chance;
this.save = save;
this.res_flag = res_flag;
this.power = power;
}
/**
* Update monster knowledge of player resists.
*
* \param m_idx is the monster who is learning
* \param type is the GF_ type to which it's learning about the player's
* resistance (or lack of)
*/
void monster_learn_resists(Player.Player p, GF type)
{
//GF gf_ptr = &gf_table[type];
update_smart_learn(p, type.resist);
update_smart_learn(p, type.immunity);
update_smart_learn(p, type.vuln);
return;
}
/// <summary>
///
/// </summary>
/// <param name="account"></param>
/// <param name="emailCategory"></param>
private void SendMail(Account account,GF.Infrastructure.Crosscutting.Context.HostSendMail.EmailCategory emailCategory)
{
EMail emailModel = CreateEmail(account, emailCategory);
HostSendMail hostSendMail = HostSendMail.CreateHostSendMail();
hostSendMail.SendMail(emailModel);
}
/// <summary>
///
/// </summary>
/// <param name="account"></param>
/// <returns></returns>
private EMail CreateEmail(Account account, GF.Infrastructure.Crosscutting.Context.HostSendMail.EmailCategory emailCategory)
{
EMail activeMail = EMail.CreateEMail();
activeMail.UserName = "******";
activeMail.Password = "******";
activeMail.MailFrom = "*****@*****.**";
activeMail.DisplaySenderName = "GloriousFuture";
activeMail.MailToList.Add(account.Email);
activeMail.MailCCList = new List<string>();
activeMail.MailBCCList = new List<string>();
activeMail.Encoding = Encoding.UTF8;
switch (emailCategory)
{
case HostSendMail.EmailCategory.ActivationCode:
activeMail.Subject = Resource.ResourceMessage.info_EmailSubjectActivationCode;
activeMail.ContentBody = string.Format(Resource.ResourceMessage.info_EmailContentBodyActivationCode,account.AccountName);
break;
case HostSendMail.EmailCategory.ResetPassword:
activeMail.Subject = Resource.ResourceMessage.info_EmailContentBodyResetPassword;
activeMail.ContentBody = string.Format(Resource.ResourceMessage.info_EmailContentBodyResetPassword, account.AccountName);
break;
case HostSendMail.EmailCategory.ChangePassword:
activeMail.Subject = Resource.ResourceMessage.info_EmailSubjectChangePassword;
activeMail.ContentBody = string.Format(Resource.ResourceMessage.info_EmailContentBodyChangePassword, account.AccountName);
break;
case HostSendMail.EmailCategory.Recharge:
activeMail.Subject = Resource.ResourceMessage.info_EmailSubjectRecharge;
activeMail.ContentBody = string.Format(Resource.ResourceMessage.info_EmailContentBodyRecharge, account.AccountName);
break;
default:
break;
}
activeMail.Host = "smtp.163.com";
//mailEntity.Port = 465;
activeMail.TimeOut = 999999;
activeMail.Encoding = Encoding.UTF8; //Encoding.GetEncoding("GB2312"); ;
activeMail.IsBodyHtml = true;
activeMail.EnableSSL = true;
return activeMail;
}
