//protected void txtCustomerIdChanged(object sender, EventArgs e)
//{
// string begin = Func.FormatYYYYmmdd(txtDateFrom.Text);
// string end = Func.FormatYYYYmmdd(txtDateTo.Text);
// if (!String.IsNullOrEmpty(begin) && !String.IsNullOrEmpty(end))
// {
// //mvMessage.CheckRequired(txt, "* là Danh mục bắt bắt buộc nhập");
// txtCustomerId.Text = DbHelper.GetScalar("SELECT A.CustomerId FROM RentContract AS A INNER JOIN RC_Room AS B ON A.ContractId = B.ContractId Where B.BeginContract <= '" + begin + "' and B.BeginContract <= '" + end + "' and B.EndContract >= '" + begin + "' and B.EndContract >= '" + begin + "' and B.RoomId = '" + lblRoomId.Text + "'");
// lblCustomerName.Text = "Không tìm thấy có Khách Hàng nào đang sử dụng phòng này";
// if (!String.IsNullOrEmpty(txtCustomerId.Text))
// {
// lblCustomerName.Text = DbHelper.GetScalar("Select Name From Customer Where CustomerId = '" + txtCustomerId.Text + "'");
// }
// }
//}
/// <summary>
/// Insert data
/// </summary>
private void InsertData()
{
//Get and Insert Data
BD_RoomUsedElecWaterData data = new BD_RoomUsedElecWaterData();
ITransaction tran = factory.GetInsertObject(data);
data.CustomerId = drpCustomerId.SelectedValue;
data.DateFrom = Func.FormatYYYYmmdd(txtDateFrom.Text.Trim());
data.DateTo = Func.FormatYYYYmmdd(txtDateTo.Text.Trim());
data.OldIndex = txtOldIndex.Text.Trim().Replace(',','.');
data.NewIndex = txtNewIndex.Text.Trim().Replace(',', '.');
data.OtherFee01 = txtOtherFee1.Text.Trim().Replace(',', '.');
data.OtherFee02 = txtOtherFee2.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.YearMonth = drpYear.SelectedValue + drpMonth.SelectedValue;
data.DelFlag = "0";
data.TariffsOfElecId = drpTariffsOfElec.SelectedValue;
data.RoomId = lblRoomId.Text;
data.TarrifsType = "1";
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);
txtOldIndex.Text = "";
txtNewIndex.Text = "";
ShowData();
}
else
{
OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name);
mvMessage.AddError(addUnSuccess);
}
}
/// <summary>
/// Update
/// </summary>
private void DeleteData(string strId)
{
BD_RoomUsedElecWaterData data = new BD_RoomUsedElecWaterData();
ITransaction tran = factory.GetLoadObject(data, strId);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_RoomUsedElecWaterData)tran.Result;
data.DelFlag = "1";
data.OldIndex = data.OldIndex.Replace(',','.');
data.NewIndex = data.NewIndex.Replace(',', '.');
data.ElecPricePercent = data.ElecPricePercent.Replace(',', '.');
data.WaterPricePercent = data.WaterPricePercent.Replace(',', '.');
data.OtherFee01 = data.OtherFee01.Replace(',', '.');
data.OtherFee02 = data.OtherFee02.Replace(',', '.');
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.LogActionUpdateId, deleteSuccess, Page.User.Identity.Name);
mvMessage.SetCompleteMessage(deleteSuccess);
ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), key, postback, true);
}
else
{
OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateUnSuccess, Page.User.Identity.Name);
mvMessage.AddError(updateUnSuccess);
}
}
}