/// <summary>
/// Load data
/// </summary>
private void LoadData()
{
BD_RoomData data = new BD_RoomData();
ITransaction tran = factory.GetLoadObject(data, id);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomData)tran.Result;
lblRoomId.Text = data.id;
lblName.Text = data.Name;
lblArea.Text = data.Area;
lblFloor.Text = data.Floor;
}
DbHelper.FillListSearch(drpCustomerId, "SELECT CustomerId,CustomerId + '-' + Name as Name FROM Customer Where BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "'", "Name", "CustomerId");
ShowData();
}
/// <summary>
/// Insert data
/// </summary>
private void InsertData()
{
BD_RoomData dataR = new BD_RoomData();
ITransaction tranR = factory.GetLoadObject(dataR, lblRoomId.Text);
Execute(tranR);
if (!HasError)
{
//Get Data
dataR = (BD_RoomData)tranR.Result;
//Get and Insert Data
BD_RoomExtraTimeData data = new BD_RoomExtraTimeData();
ITransaction tran = factory.GetInsertObject(data);
data.CustomerId = drpCustomerId.SelectedValue;
data.WorkingDate = Func.FormatYYYYmmdd(txtWorkingDate.Text.Trim());
//data.EndWD = Func.FormatYYYYmmdd(txtEndWD.Text.Trim());
data.YearMonth = drpYear.SelectedValue + drpMonth.SelectedValue;
data.ExtraHour = txtExtraHour.Text.Replace(",", ".");
data.Comment = txtComment.Text.Trim();
data.Vat = dataR.Vat.Replace(",", ".");
data.PriceUSD = dataR.MonthExtraTimePriceUsd.Replace(",", ".");
data.PriceVND = dataR.MonthExtraTimePriceVND.Replace(",", ".");
data.ModifiedBy = Page.User.Identity.Name;
data.CreatedBy = Page.User.Identity.Name;
data.Created = DateTime.Now.ToString("yyyyMMddHHmmss");
data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
data.DelFlag = "0";
data.RoomId = lblRoomId.Text;
data.BuildingId = Func.ParseString(Session["__BUILDINGID__"]);
Execute(tran);
if (!HasError)
{
OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name);
mvMessage.SetCompleteMessage(addSuccess);
ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), key, postback, true);
ShowData();
}
else
{
OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name);
mvMessage.AddError(addUnSuccess);
}
}
}
/// <summary>
/// Init values
/// </summary>
protected override void DoInit()
{
try
{
Hashtable tmp = new Hashtable();
for (int i = 0; i < 24; i++)
{
drpHourFrom.Items.Add(new ListItem(Func.ParseString(i).PadLeft(2, '0'), Func.ParseString(i).PadLeft(2, '0')));
drpHourTo.Items.Add(new ListItem(Func.ParseString(i).PadLeft(2, '0'), Func.ParseString(i).PadLeft(2, '0')));
}
drpHourFrom.Items.FindByValue(DateTime.Now.AddHours(-1).ToString("hh")).Selected = true;
drpHourTo.Items.FindByValue(DateTime.Now.AddHours(1).ToString("hh")).Selected = true;
BD_RoomBookingData data = new BD_RoomBookingData();
ITransaction tran = factory.GetLoadObject(data, hidId.Value);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomBookingData)tran.Result;
lnbCustomerId.Text = data.CustomerId;
lblBookingDate.Text = Func.FormatDMY(data.BookingDate);
drpHourFrom.SelectedValue = data.BookingHourFrom.PadLeft(2, '0');
drpHourTo.SelectedValue = data.BookingHourTo.PadLeft(2, '0');
drpMinuteFrom.Value = data.BookingMinuteFrom.PadLeft(2, '0');
drpMinuteTo.Value = data.BookingMinuteTo.PadLeft(2, '0');
txtPriceVND.Text = Func.ParseString(Func.ParseDouble(data.PriceVND));
txtPriceUSD.Text = data.PriceUSD;
txtVat.Text = data.VAT;
chkBookingType.Checked = (data.BookingType == "1" ? true : false);
txtContractNo.Text = data.ContractNo;
txtRate.Text = Func.ParseString(Func.ParseDouble(data.Rate));
txtRateDate.Text = data.RateDate;
float hour = Func.ParseInt(data.BookingHourTo) - Func.ParseInt(data.BookingHourFrom);
int hourOdd = Func.ParseInt(data.BookingMinuteTo) - Func.ParseInt(data.BookingMinuteFrom);
if (hourOdd < 0)
{
hour--;
}
else
{
hour += Func.ParseFloat(hourOdd) / 60;
}
//lblSumVND.Text = Func.ParseString((long)(Func.ParseFloat(data.PriceVND) * hour) + (long)(Func.ParseFloat(data.PriceVND) * hour * Func.ParseFloat(data.VAT) / 100));
//lblSumUSD.Text = Func.ParseString(Func.ParseFloat(data.PriceUSD) * hour) + Func.ParseString(Func.ParseFloat(data.PriceUSD) * hour * Func.ParseFloat(data.VAT) / 100);
txtComment.Text = data.Comment;
if ("1".Equals(data.Status))
{
btnConfirm.Visible = false;
divPaid.Visible = true;
}
else
{
divPaid.Visible = false;
}
}
BD_RoomData dataR = new BD_RoomData();
ITransaction tranR = factory.GetLoadObject(dataR, data.RoomId);
Execute(tranR);
if (!HasError)
{
//Get Data
dataR = (BD_RoomData)tranR.Result;
lblName.Text = dataR.Name;
lblComment.Text = dataR.Comment;
lblRegional.Text = dataR.Regional;
lblFloor.Text = dataR.Floor;
lblArea.Text = dataR.Area;
lblHourManagerPriceVND.Text = dataR.HourRentPriceVND;
lblHourManagerPriceUSD.Text = dataR.HourRentPriceUSD;
lblVat.Text = data.VAT;
}
//string sql = " SELECT sum(PriceVND*Mount+PriceVND*Mount*VAT/100) VND,sum(PriceUSD*Mount+PriceUSD*Mount*VAT/100) USD";
//sql += " FROM [BD_RoomBookingService]";
//sql += " WHERE (ID IS NOT NULL) and DelFlag <> 1 and BookingId = '" + hidId.Value + "'";
//DataTable dt = DbHelper.GetDataTable(sql);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// lblSumServiceVND.Text = Func.ParseString(dt.Rows[i]["VND"]);
// lblSumServiceUSD.Text = Func.ParseString(dt.Rows[i]["USD"]);
//}
//lblSumPriceUSD.Text = "" + (Func.ParseFloat(lblSumUSD.Text) + Func.ParseFloat(lblSumServiceUSD.Text));
//lblSumPriceVND.Text = "" + (Func.ParseDouble(lblSumVND.Text) + Func.ParseDouble(lblSumServiceVND.Text));
//sql = " SELECT sum(MoneyUSD) USD,sum(MoneyVND) VND ";
//sql += " FROM [Payment]";
//sql += " WHERE (ID IS NOT NULL) and DelFlag <> 1 and BookingId = '" + hidId.Value + "'";
//dt = DbHelper.GetDataTable(sql);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// lblPaidUSD.Text = Func.ParseString(dt.Rows[i]["VND"]);
// lblPaidVND.Text = Func.ParseString(dt.Rows[i]["USD"]);
//}
//txtPaidUSD.Text = "" + (Func.ParseFloat(lblSumPriceUSD.Text) - Func.ParseFloat(lblPaidUSD.Text));
//txtPaidVND.Text = "" + (Func.ParseDouble(lblSumPriceVND.Text) - Func.ParseDouble(lblPaidVND.Text));
string sql = " SELECT LastPriceVND VND,LastPriceUSD USD";
sql += " FROM [PaymentBooking]";
sql += " WHERE BookingId = '" + hidId.Value + "'";
DataTable dt = DbHelper.GetDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
lblSumVND.Text = Func.ParseString(Func.ParseDouble(dt.Rows[i]["VND"]));
lblSumUSD.Text = Func.ParseString(dt.Rows[i]["USD"]);
}
//lblSumVND.Text = Func.ParseString((long)(Func.ParseFloat(data.PriceVND) * hour) + (long)(Func.ParseFloat(data.PriceVND) * hour * Func.ParseFloat(data.VAT) / 100));
//lblSumUSD.Text = Func.ParseString(Func.ParseFloat(data.PriceUSD) * hour) + Func.ParseString(Func.ParseFloat(data.PriceUSD) * hour * Func.ParseFloat(data.VAT) / 100);
sql = " SELECT sum(LastPriceVND) VND,sum(LastPriceUSD) USD";
sql += " FROM [PaymentBookingService]";
sql += " WHERE BookingId = '" + hidId.Value + "'";
dt = DbHelper.GetDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
lblSumServiceVND.Text = Func.ParseString(Func.ParseFloat(dt.Rows[i]["VND"]));
lblSumServiceUSD.Text = Func.ParseString(dt.Rows[i]["USD"]);
}
lblSumPriceUSD.Text = "" + (Func.ParseFloat(lblSumUSD.Text) + Func.ParseFloat(lblSumServiceUSD.Text));
lblSumPriceVND.Text = "" + (Func.ParseDouble(lblSumVND.Text) + Func.ParseDouble(lblSumServiceVND.Text));
sql = " SELECT sum(MoneyUSD) USD,sum(MoneyVND) VND ";
sql += " FROM [Payment]";
sql += " WHERE (ID IS NOT NULL) and DelFlag <> 1 and BookingId = '" + hidId.Value + "'";
dt = DbHelper.GetDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
lblPaidUSD.Text = Func.ParseString(Func.ParseFloat(dt.Rows[i]["USD"]));
lblPaidVND.Text = Func.ParseString(Func.ParseDouble(dt.Rows[i]["VND"]));
}
txtPaidUSD.Text = "" + (Func.ParseFloat(lblSumPriceUSD.Text) - Func.ParseFloat(lblPaidUSD.Text));
txtPaidVND.Text = "" + (Func.ParseDouble(lblSumPriceVND.Text) - Func.ParseDouble(lblPaidVND.Text));
ShowData();
string tmpPaid = DbHelper.GetScalar("Select count(*) from Payment Where BookingId = '" + hidId.Value + "' and DelFlag = '0' and PaymentType = '8'");
if ("1".Equals(tmpPaid))
{
btnPaid.Visible = false;
}
}
catch (Exception ex)
{
Console.Write(ex);
}
//return tmp;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
hidId.Value = Func.ParseString(Request["id"]);
PopupWidth = 600;
PopupHeight = 450;
ShowData();
DbHelper.FillListSearch(drpCustomerId, "SELECT CustomerId,CustomerId + '-' + Name as Name FROM Customer Where BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "'", "Name", "CustomerId");
BD_RoomData data = new BD_RoomData();
ITransaction tran = factory.GetLoadObject(data, hidId.Value);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomData)tran.Result;
lblName.Text = data.Name;
lblComment.Text = data.Comment;
lblRegional.Text = data.Regional;
lblFloor.Text = data.Floor;
lblArea.Text = data.Area;
//lblHourExtraTimePriceVND.Text = data.HourExtraTimePriceVND;
//lblHourExtraTimePriceUSD.Text = data.HourExtraTimePriceUsd;
//lblMonthRentPriceVND.Text = data.MonthRentPriceVND;
//lblMonthRentPriceUSD.Text = data.MonthRentPriceUSD;
lblHourManagerPriceVND.Text = data.HourRentPriceVND;
lblHourManagerPriceUSD.Text = data.HourRentPriceUSD;
//lblMonthExtraTimePriceVND.Text = data.MonthExtraTimePriceVND;
//lblMonthExtraTimePriceUSD.Text = data.MonthExtraTimePriceUsd;
txtPriceVND.Text = data.HourRentPriceVND;
txtPriceUSD.Text = data.HourRentPriceUSD;
txtVAT.Text = data.Vat;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
hidId.Value = Func.ParseString(Request["id"]);
txtBookingDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
DbHelper.FillListSearch(drpCustomerId, "SELECT CustomerId,CustomerId + '-' + Name as Name FROM Customer Where BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "'", "Name", "CustomerId");
drpCustomerId.SelectedValue = hidId.Value;
DbHelper.FillList(drpMeetingRoom, "SELECT Id,Name FROM BD_Room Where BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "' and IsMeetingRoom = '1'", "Name", "Id");
ViewBookingTime();
ShowData();
BD_RoomData data = new BD_RoomData();
ITransaction tran = factory.GetLoadObject(data, drpMeetingRoom.SelectedValue);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomData)tran.Result;
//lblName.Text = data.Name;
lblComment.Text = data.Comment;
lblRegional.Text = data.Regional;
lblFloor.Text = data.Floor;
lblArea.Text = data.Area;
lblHourRentPriceVND.Text = data.HourRentPriceVND;
lblHourRentPriceUSD.Text = data.HourRentPriceUSD;
txtPriceVND.Text = data.HourRentPriceVND;
txtPriceUSD.Text = data.HourRentPriceUSD;
txtVAT.Text = data.Vat;
}
}
}
protected void drpMeetingRoom_OnSelectedIndexChanged(object sender, EventArgs e)
{
ViewBookingTime();
BD_RoomData data = new BD_RoomData();
ITransaction tran = factory.GetLoadObject(data, drpMeetingRoom.SelectedValue);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomData)tran.Result;
//lblName.Text = data.Name;
lblComment.Text = data.Comment;
lblRegional.Text = data.Regional;
lblFloor.Text = data.Floor;
lblArea.Text = data.Area;
lblHourRentPriceVND.Text = data.HourRentPriceVND;
lblHourRentPriceUSD.Text = data.HourRentPriceUSD;
txtPriceVND.Text = data.HourRentPriceVND;
txtPriceUSD.Text = data.HourRentPriceUSD;
txtVAT.Text = data.Vat;
}
ShowData();
}
/// <summary>
/// Update
/// </summary>
private void UpdateData()
{
if (!checkData()) return;
BD_RoomData data = new BD_RoomData();
ITransaction tran = factory.GetLoadObject(data, hidId.Value);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomData)tran.Result;
data.Name = txtName.Text.Trim();
data.Comment = txtComment.Text.Trim();
data.ModifiedBy = Page.User.Identity.Name;
data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
data.DelFlag = true.Equals(chkDelFlag.Checked) ? "0" : "1";
data.IsMeetingRoom = (chkMeetinRoom.Checked == true ? "1" : "0");
data.Regional = txtRegional.Text;
data.Floor = txtFloor.Text;
data.Description = txtDescription.Text;
data.Area = txtArea.Text.Replace(',', '.');
data.HourRentPriceVND = txtHourRentPriceVND.Text.Trim().Replace(',', '.');
data.HourRentPriceUSD = txtHourRentPriceUSD.Text.Trim().Replace(',', '.');
data.HourManagerPriceVND = "0";
data.HourManagerPriceUSD = "0";
data.HourExtraTimePriceVND = txtHourExtraTimePriceVND.Text.Trim().Replace(',', '.');
data.HourExtraTimePriceUsd = txtHourExtraTimePriceUSD.Text.Trim().Replace(',', '.');
data.MonthRentPriceVND = txtMonthRentPriceVND.Text.Trim().Replace(',', '.');
data.MonthRentPriceUSD = txtMonthRentPriceUSD.Text.Trim().Replace(',', '.');
data.MonthManagerPriceVND = txtMonthManagerPriceVND.Text.Trim().Replace(',', '.');
data.MonthManagerPriceUSD = txtMonthManagerPriceUSD.Text.Trim().Replace(',', '.');
data.MonthExtraTimePriceVND = txtMonthExtraTimePriceVND.Text.Trim().Replace(',', '.');
data.MonthExtraTimePriceUsd = txtMonthExtraTimePriceUSD.Text.Trim().Replace(',', '.');
data.Vat = txtVat.Text.Trim().Replace(',', '.');
data.OtherFee01 = "0";
data.OtherFee02 = "0";
data.ExtraTimeMinPriceVND = txtMonthExtraTimePriceVND.Text.Trim().Replace(',', '.');
data.ExtraTimeMinPriceUSD = txtMonthExtraTimePriceUSD.Text.Trim().Replace(',', '.');
tran = factory.GetUpdateObject(data);
Execute(tran);
if (!HasError)
{
OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateSuccess, Page.User.Identity.Name);
mvMessage.SetCompleteMessage(updateSuccess);
ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), key, postback, true);
lblCreated.Text = !"".Equals(data.Created) ? data.CreatedBy + "(" + Func.Formatdmyhms(data.Created) + ")" : "";
lblModified.Text = !"".Equals(data.Modified) ? data.ModifiedBy + "(" + Func.Formatdmyhms(data.Modified) + ")" : "";
}
else
{
OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateUnSuccess, Page.User.Identity.Name);
mvMessage.AddError(updateUnSuccess);
}
}
}
/// <summary>
/// Load data
/// </summary>
private void LoadData()
{
BD_RoomData data = new BD_RoomData();
ITransaction tran = factory.GetLoadObject(data, id);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomData)tran.Result;
txtId.Text = data.id;
txtName.Text = data.Name;
txtComment.Text = data.Comment;
chkMeetinRoom.Checked = (data.IsMeetingRoom == "1" ? true : false);
txtRegional.Text = data.Regional;
txtFloor.Text = data.Floor;
txtArea.Text = data.Area;
txtHourRentPriceVND.Text = data.HourRentPriceVND;
txtHourRentPriceUSD.Text = data.HourRentPriceUSD;
txtMonthRentPriceVND.Text = data.MonthRentPriceVND;
txtMonthRentPriceUSD.Text = data.MonthRentPriceUSD;
txtMonthManagerPriceVND.Text = data.MonthManagerPriceVND;
txtMonthManagerPriceUSD.Text = data.MonthManagerPriceUSD;
txtHourExtraTimePriceVND.Text = data.HourExtraTimePriceVND;
txtHourExtraTimePriceUSD.Text = data.HourExtraTimePriceUsd;
txtMonthExtraTimePriceVND.Text = data.MonthExtraTimePriceVND;
txtMonthExtraTimePriceUSD.Text = data.MonthExtraTimePriceUsd;
txtVat.Text = data.Vat;
chkDelFlag.Checked = "1".Equals(data.DelFlag) ? false : true;
lblCreated.Text = !"".Equals(data.Created) ? data.CreatedBy + "(" + Func.Formatdmyhms(data.Created) + ")" : "";
lblModified.Text = !"".Equals(data.Modified) ? data.ModifiedBy + "(" + Func.Formatdmyhms(data.Modified) + ")" : "";
txtDescription.Text = data.Description;
hidId.Value = id;
}
}
/// <summary>
/// Load data
/// </summary>
private void LoadData()
{
BD_RoomData data = new BD_RoomData();
ITransaction tran = factory.GetLoadObject(data, id);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomData)tran.Result;
lblRoomId.Text = data.id;
lblName.Text = data.Name;
lblArea.Text = data.Area;
lblFloor.Text = data.Floor;
}
DbHelper.FillListSearch(drpCustomerId, "SELECT CustomerId,CustomerId + '-' + Name as Name FROM Customer Where BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "' and delflag = 0", "Name", "CustomerId");
string CustomerId = DbHelper.GetScalar("SELECT CustomerId FROM BD_RoomUsedElecWater where id = (select MAX(id) from BD_RoomUsedElecWater where RoomId = '" + id + "' and DelFlag = 0 and TarrifsType = 1)");
drpCustomerId.SelectedValue = CustomerId;
DbHelper.FillListSearch(drpTariffsOfElec, "Select Id,Name from BD_FeeGroup where BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "' and delflag = 0 and feeGroup = 1", "Name", "ID");
ShowData();
}
protected void drpRoom_SelectedIndexChanged(object sender, EventArgs e)
{
BD_RoomData data = new BD_RoomData();
ITransaction tran = factory.GetLoadObject(data, drpRoom.SelectedValue);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomData)tran.Result;
txtRentPriceVND.Text = data.MonthRentPriceVND;
txtRentPriceUSD.Text = data.MonthRentPriceUSD;
txtManagerPriceVND.Text = data.MonthManagerPriceVND;
txtManagerPriceUSD.Text = data.MonthManagerPriceUSD;
txtHourExtraTimePriceUsd.Text = data.HourExtraTimePriceUsd;
txtHourExtraTimePriceVND.Text = data.HourExtraTimePriceVND;
txtMonthExtraTimePriceUSD.Text = data.MonthExtraTimePriceUsd;
txtMonthExtraTimePriceVND.Text = data.MonthExtraTimePriceVND;
txtVAT.Text = data.Vat;
txtRentArea.Text = data.Area;
}
}
