/// <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; }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnConfirm_Click(object sender, EventArgs e) { mvMessage.CheckRequired(txtPriceVND, "Phí thuê(giờ)(VND): Danh mục phải nhập"); mvMessage.CheckRequired(txtPriceUSD, "Phí thuê(giờ)(USD): Danh mục phải nhập"); int from = Func.ParseInt(drpHourFrom.SelectedValue + drpMinuteFrom.Value); int to = Func.ParseInt(drpHourTo.SelectedValue + drpMinuteTo.Value); if (from >= to) { mvMessage.AddError("Thời gian đặt phòng không hợp lệ"); return; } if (!mvMessage.IsValid) return; //Get and Insert Data BD_RoomBookingData data = new BD_RoomBookingData(); ITransaction tran = factory.GetLoadObject(data, hidId.Value); Execute(tran); if (!HasError) { //Get Data data = (BD_RoomBookingData)tran.Result; data.BookingDate = Func.FormatYYYYmmdd(lblBookingDate.Text.Trim()); data.BookingHourFrom = drpHourFrom.SelectedValue; data.BookingHourTo = drpHourTo.SelectedValue; data.BookingMinuteFrom = drpMinuteFrom.Value; data.BookingMinuteTo = drpMinuteTo.Value; data.RentHourFrom = drpHourFrom.SelectedValue; data.RentHourTo = drpHourTo.SelectedValue; data.RentMinuteFrom = drpMinuteFrom.Value; data.RentMinuteTo = drpMinuteTo.Value; data.PriceVND = txtPriceVND.Text.Trim().Replace(',', '.'); data.PriceUSD = txtPriceUSD.Text.Trim().Replace(',', '.'); data.Status = "1";//2 la Huy; 0 la dat. 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; } data.Hour = Func.ParseString(hour); data.Comment = txtComment.Text.Trim(); data.VAT = txtVat.Text.Trim(); 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"; tran = factory.GetUpdateObject(data); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(addSuccess); } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name); mvMessage.AddError(addUnSuccess); } } }
protected void btnPaid_Click(object sender, EventArgs e) { //string exchangetype = (rdoUSD.Checked == true) ? "0" : "1"; //string money = (rdoUSD.Checked == true) ? txtPaidUSD.Text : txtPaidVND.Text; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "", "PopUp('../../Customer/PaymentBooking.aspx?paymenttype=8&id=" + lnbCustomerId.Text + "&yearmonth=" + Func.FormatYYYYmmdd(lblBookingDate.Text).Substring(0, 6) + "&exchangetype=" + exchangetype + "&money=" + money + "&bookingid=" + hidId.Value + "',600,600,'PaymentBooking', true);", true); try { BD_RoomBookingData data = new BD_RoomBookingData(); ITransaction tran = factory.GetLoadObject(data, hidId.Value); Execute(tran); if (!HasError) { //Get Data data = (BD_RoomBookingData)tran.Result; data.ContractNo = txtContractNo.Text.Trim(); data.Rate = txtRate.Text.Trim(); data.RateDate = Func.Formatymdhms(txtRateDate.Text); data.PaidMoneyType = rdoUSD.Checked == true ? "0" : "1"; data.ModifiedBy = Page.User.Identity.Name; data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); tran = factory.GetUpdateObject(data); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(addSuccess); } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name); mvMessage.AddError(addUnSuccess); } } } catch (Exception ex) { } try { PaymentData data = new PaymentData(); ITransaction tran = factory.GetInsertObject(data); 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.BuildingId = Func.ParseString(Session["__BUILDINGID__"]); data.CustomerId = lnbCustomerId.Text; data.PaymentDate = Func.FormatYYYYmmdd(txtContractDate.Text.Trim().Substring(0, 10)); data.YearMonth = data.PaymentDate.Substring(0, 6); data.PaymentType = "8"; data.PaidType = rdoUSD.Checked == true ? "0" : "1"; data.Paymenter = txtPaymenter.Text.Trim(); data.Receiver = txtReceiver.Text.Trim(); data.MoneyUSD = (rdoUSD.Checked == true) ? txtPriceUSD.Text.Replace(",", ".") : "0"; data.MoneyVND = (rdoVND.Checked == true) ? txtPriceVND.Text.Replace(",", ".") : "0"; data.Comment = txtComment.Text.Trim(); data.BookingId = hidId.Value; Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(addSuccess); } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name); mvMessage.AddError(addUnSuccess); } } catch (Exception ex) { } }
//protected void txtCustomerId_OnTextChanged(object sender, EventArgs e) //{ // lblCustomerName.Text = DbHelper.GetScalar("Select Name from Customer Where BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "' and CustomerId = '" + txtCustomerId.Text + "'"); //} /// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdd_Click(object sender, EventArgs e) { if (!checkData()) return; int from = Func.ParseInt(drpHourFrom.SelectedValue + drpMinuteFrom.Value); int to = Func.ParseInt(drpHourTo.SelectedValue + drpMinuteTo.Value); if (Func.ParseDate(txtBookingDate.Text).CompareTo(DateTime.Now) < 0) { mvMessage.AddError("Ngày đặt phòng không hợp lệ"); return; } if (from >= to) { mvMessage.AddError("Thời gian đặt phòng không hợp lệ"); return; } if (!mvMessage.IsValid) return; //Get and Insert Data BD_RoomBookingData data = new BD_RoomBookingData(); ITransaction tran = factory.GetInsertObject(data); data.CustomerId = drpCustomerId.SelectedValue; data.BookingDate = Func.FormatYYYYmmdd(txtBookingDate.Text.Trim()); data.BookingHourFrom = drpHourFrom.SelectedValue; data.BookingHourTo = drpHourTo.SelectedValue; data.BookingMinuteFrom = drpMinuteFrom.Value; data.BookingMinuteTo = drpMinuteTo.Value; data.PriceVND = txtPriceVND.Text.Trim().Replace(',', '.'); data.PriceUSD = txtPriceUSD.Text.Trim().Replace(',', '.'); data.Comment = txtComment.Text.Trim(); data.RoomId = hidId.Value; data.VAT = txtVAT.Text.Trim().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.Status = "0"; data.BuildingId = Func.ParseString(Session["__BUILDINGID__"]); data.BookingType = (chkBookingType.Checked == true ? "1" : "0"); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(addSuccess); ShowData(); } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name); mvMessage.AddError(addUnSuccess); } }
/// <summary> /// Update /// </summary> private void DeleteData(string id) { BD_RoomBookingData data = new BD_RoomBookingData(); ITransaction tran = factory.GetLoadObject(data, id); Execute(tran); if (!HasError) { //Get Data data = (BD_RoomBookingData)tran.Result; data.PriceVND = data.PriceVND.Replace(',', '.'); data.PriceUSD = data.PriceVND.Replace(',', '.'); data.ModifiedBy = Page.User.Identity.Name; data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); data.DelFlag = "1"; tran = factory.GetUpdateObject(data); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, deleteSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(deleteSuccess); } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, deleteUnSuccess, Page.User.Identity.Name); mvMessage.AddError(deleteUnSuccess); } } }
/// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { string command = e.CommandName; string colName = string.Empty; if (command.StartsWith("Sort")) { if (string.Compare(command, "SortID") == 0) { colName = "ID"; } else if (string.Compare(command, "SortName") == 0) { colName = "Name"; } else if (string.Compare(command, "SortModifiedBy") == 0) { colName = "ModifiedBy"; } else if (string.Compare(command, "SortModified") == 0) { colName = "Modified"; } if (colName == ListSortExpression) { ListSortDirection = (ListSortDirection == SortDirection.Ascending ? SortDirection.Descending : SortDirection.Ascending); } else { ListSortDirection = SortDirection.Descending; } ListSortExpression = colName; pager.CurrentPageIndex = 0; ShowData(); } else if (command.Equals("Delete")) { BD_RoomBookingData data = new BD_RoomBookingData(); ITransaction tran = factory.GetLoadObject(data, Func.ParseString(e.CommandArgument)); Execute(tran); if (!HasError) { //Get Data data = (BD_RoomBookingData)tran.Result; data.DelFlag = "1"; data.PriceUSD = data.PriceUSD.Replace(",", "."); tran = factory.GetUpdateObject(data); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, deleteSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(deleteSuccess); } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, deleteUnSuccess, Page.User.Identity.Name); mvMessage.AddError(deleteUnSuccess); } } } else if (command.Equals("Confirm")) { Response.Redirect(editConfirmPageName + ".aspx?id=" + e.CommandArgument); } else if (command.Equals("Delete")) { DeleteData("" + e.CommandArgument); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDelete_Click(object sender, EventArgs e) { BD_RoomBookingData data = new BD_RoomBookingData(); ITransaction tran = factory.GetLoadObject(data, hidId.Value); Execute(tran); if (!HasError) { //Get Data data = (BD_RoomBookingData)tran.Result; data.PriceVND = txtPriceVND.Text.Trim().Replace(".", "").Replace(",", "."); data.PriceUSD = txtPriceUSD.Text.Trim().Replace(".", "").Replace(",", "."); data.Status = "2";//2 la Huy; 0 la dat; 1 là OK data.Hour = data.Hour.Replace(".", "").Replace(",", "."); data.Comment = txtComment.Text.Trim(); data.VAT = txtVat.Text.Trim().Replace(".", "").Replace(",", "."); data.HourExtraPriceUSD = "0"; data.HourExtraPriceVND = "0"; 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 = "1"; data.OtherFee01 = "0"; data.OtherFee02 = "0"; data.Rate = data.Rate.Replace(".", "").Replace(",", "."); tran = factory.GetUpdateObject(data); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(addSuccess); btnConfirm.Visible = false; btnDelete.Visible = false; btnView.Visible = false; btnPaid.Visible = false; } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name); mvMessage.AddError(addUnSuccess); } } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnConfirm_Click(object sender, EventArgs e) { mvMessage.CheckRequired(txtContractDate, "Ngày xuất HĐ : Danh mục phải nhập"); mvMessage.CheckRequired(txtContractNo, "Hợp đồng số : Danh mục phải nhập"); mvMessage.CheckRequired(txtRate, "Tỉ giá quy đổi USD->VND : Danh mục phải nhập"); mvMessage.CheckRequired(txtRateDate, "Thời gian quy đổi: Danh mục phải nhập"); //mvMessage.CheckRequired(txtPaymenter, " Đại diện Khách Hàng : Danh mục phải nhập"); //mvMessage.CheckRequired(txtReceiver, "Đại diện Tòa nhà : Danh mục phải nhập"); int from = Func.ParseInt(drpHourFrom.SelectedValue + drpMinuteFrom.Value); int to = Func.ParseInt(drpHourTo.SelectedValue + drpMinuteTo.Value); if (from >= to) { mvMessage.AddError("Thời gian đặt phòng không hợp lệ"); return; } if (!mvMessage.IsValid) return; //Get and Insert Data BD_RoomBookingData data = new BD_RoomBookingData(); ITransaction tran = factory.GetLoadObject(data, hidId.Value); Execute(tran); if (!HasError) { //Get Data data = (BD_RoomBookingData)tran.Result; data.BookingDate = Func.FormatYYYYmmdd(lblBookingDate.Text.Trim()); data.BookingHourFrom = drpHourFrom.SelectedValue; data.BookingHourTo = drpHourTo.SelectedValue; data.BookingMinuteFrom = drpMinuteFrom.Value; data.BookingMinuteTo = drpMinuteTo.Value; data.RentHourFrom = drpHourFrom.SelectedValue; data.RentHourTo = drpHourTo.SelectedValue; data.RentMinuteFrom = drpMinuteFrom.Value; data.RentMinuteTo = drpMinuteTo.Value; data.PriceVND = txtPriceVND.Text.Trim().Replace(".", "").Replace(",", "."); data.PriceUSD = txtPriceUSD.Text.Trim().Replace(".", "").Replace(",", "."); data.Status = "1";//2 la Huy; 0 la dat; 1 là OK 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; } data.Hour = Func.ParseString(hour).Replace(".", "").Replace(",", "."); data.Comment = txtComment.Text.Trim(); data.VAT = txtVat.Text.Trim().Replace(".", "").Replace(",", "."); data.HourExtraPriceUSD = "0"; data.HourExtraPriceVND = "0"; 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.OtherFee01 = "0"; data.OtherFee02 = "0"; data.ContractDate = Func.FormatYYYYmmdd(txtContractDate.Text.Trim()); data.ContractNo = txtContractNo.Text; data.Rate = txtRate.Text.Replace(".", "").Replace(",", "."); data.RateDate = Func.FormatYYYYmmdd(txtRateDate.Text.Trim()); tran = factory.GetUpdateObject(data); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(addSuccess); btnConfirm.Visible = false; btnDelete.Visible = false; btnView.Visible = true; btnPaid.Visible = true; } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name); mvMessage.AddError(addUnSuccess); } } }