protected void ctlAddNew_Click(object sender, ImageClickEventArgs e)
{
DbMileageRateRevision MiRvs = new DbMileageRateRevision();
MiRvs.EffectiveFromDate = UIHelper.ParseDate(ctlEffectiveFrom.DateValue);
MiRvs.EffectiveToDate = UIHelper.ParseDate(ctlctlEffectiveTo.DateValue);
#region Validate MileageRate
Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors();
if (MiRvs.EffectiveFromDate > MiRvs.EffectiveToDate)
{
errors.AddError("MileageRateRivision.Error", new Spring.Validation.ErrorMessage("Effective From more than Effective To "));
}
#endregion
if (!errors.IsEmpty)
{
this.ValidationErrors.MergeErrors(errors);
return;
}
DbMileageRateRevisionService.AddMileageRateRevision(MiRvs, UserAccount.UserID);
ctlEffectiveFrom.DateValue = string.Empty;
ctlctlEffectiveTo.DateValue = string.Empty;
ctlMiRvsGrid.DataCountAndBind();
ctlUpdatePanelGridview.Update();
}
protected void UpdateMrrButton_Click(object sender, ImageClickEventArgs e)
{
DbMileageRateRevision MiRvs = new DbMileageRateRevision();
MiRvs.Id = new Guid(MiRvsId.Value);
MiRvs.EffectiveFromDate = UIHelper.ParseDate(ctlEffectiveFrom.DateValue);
MiRvs.EffectiveToDate = UIHelper.ParseDate(ctlctlEffectiveTo.DateValue);
#region Validate MileageRate
Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors();
if (MiRvs.EffectiveFromDate > MiRvs.EffectiveToDate)
{
errors.AddError("MileageRateRivision.Error", new Spring.Validation.ErrorMessage("Effective From more than Effective To "));
}
#endregion
if (!errors.IsEmpty)
{
this.ValidationErrors.MergeErrors(errors);
return;
}
DbMileageRateRevisionService.UpdateMileageRateRevision(MiRvs, UserAccount.UserID);
DivManageMileageRate.Style.Add("display", "none");
ctlAddItem.Visible = true;
ctlMiRvsGrid.DataCountAndBind();
ctlUpdatePanelGridview.Update();
}
protected void ctlMileageRateRevisionGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "ApproveItem")
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
string ItemId = ctlMiRvsGrid.DataKeys[rowIndex].Values["Id"].ToString();
string EffectiveFrom = ctlMiRvsGrid.DataKeys[rowIndex].Values["EffectiveFromDate"].ToString();
string EffectiveTo = ctlMiRvsGrid.DataKeys[rowIndex].Values["EffectiveToDate"].ToString();
DivMileageIltem.Style.Add("display", "none");
DbMileageRateRevision MiRvs = new DbMileageRateRevision();
MiRvs.Id = new Guid(ItemId);
MiRvs.Status = 1;
MiRvs.EffectiveFromDate = Convert.ToDateTime(EffectiveFrom);
MiRvs.EffectiveToDate = Convert.ToDateTime(EffectiveTo);
DbMileageRateRevisionService.ApproveMileageRateRevision(MiRvs, UserAccount.UserID);
ctlMiRvsDetail.Visible = false;
}
else if (e.CommandName == "ViewItem")
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
string ItemId = ctlMiRvsGrid.DataKeys[rowIndex].Values["Id"].ToString();
string Status = ctlMiRvsGrid.DataKeys[rowIndex].Values["StatusDesc"].ToString();
//นำค่า MileageRateRivision Id ไปเก็บ Hidden Field ของ ตารางล่าง
MiRvsId.Value = ItemId;
MiRvsStatus.Value = Status;
DivManageMileageRate.Style.Add("display", "none");
DivMileageIltem.Style.Add("display", "none");
ctlMiRvsDetail.Visible = true;
ctlAddItem.Visible = true;
ctlMiRvsDetail.DataCountAndBind();
}
else if (e.CommandName == "RemoveItem")
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
string ItemId = ctlMiRvsGrid.DataKeys[rowIndex].Values["Id"].ToString();
DbMileageRateRevision MiRvs = new DbMileageRateRevision();
MiRvs.Id = new Guid(ItemId);
DbMileageRateRevisionService.RemoveMileageRateRevision(MiRvs);
ctlMiRvsDetail.Visible = false;
DivManageMileageRate.Style.Add("display", "none");
DivMileageIltem.Style.Add("display", "none");
ctlAddItem.Visible = true;
}
else if (e.CommandName == "CancelItem")
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
string ItemId = ctlMiRvsGrid.DataKeys[rowIndex].Values["Id"].ToString();
string ApprovedDate = ctlMiRvsGrid.DataKeys[rowIndex].Values["ApprovedDate"].ToString();
string EffectiveFrom = ctlMiRvsGrid.DataKeys[rowIndex].Values["EffectiveFromDate"].ToString();
string EffectiveTo = ctlMiRvsGrid.DataKeys[rowIndex].Values["EffectiveToDate"].ToString();
DbMileageRateRevision MiRvs = new DbMileageRateRevision();
MiRvs.Id = new Guid(ItemId);
MiRvs.ApprovedDate = Convert.ToDateTime(ApprovedDate);
MiRvs.EffectiveFromDate = Convert.ToDateTime(EffectiveFrom);
MiRvs.EffectiveToDate = Convert.ToDateTime(EffectiveTo);
MiRvs.Status = 2;
DbMileageRateRevisionService.CancelMileageRateRevision(MiRvs, UserAccount.UserID);
DivManageMileageRate.Style.Add("display", "none");
DivMileageIltem.Style.Add("display", "none");
ctlAddItem.Visible = true;
}
else if (e.CommandName == "ImportItem")
{
ctlMiRvsDetail.Visible = false;
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
MiRvsItemId.Value = ctlMiRvsGrid.DataKeys[rowIndex].Values["Id"].ToString();
MileageRateRevisionLookUp.Show();
DivManageMileageRate.Style.Add("display", "none");
DivMileageIltem.Style.Add("display", "none");
ctlAddItem.Visible = true;
}
else if (e.CommandName == "EditMiRvsItem")
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
MiRvsId.Value = ctlMiRvsGrid.DataKeys[rowIndex].Values["Id"].ToString();
DbMileageRateRevision result = ScgDbQueryProvider.DbMileageRateRevisionQuery.FindEffectiveDate(new Guid(MiRvsId.Value));
ctlEffectiveFrom.Value = result.EffectiveFromDate;
ctlctlEffectiveTo.Value = result.EffectiveToDate;
DivMileageIltem.Style.Add("display", "none");
ctlMiRvsDetail.Visible = false;
ctlAddItem.Visible = false;
AddButton.Visible = false;
UpdateMrrButton.Visible = true;
DivManageMileageRate.Style.Add("display", "block");
}
ctlMiRvsGrid.DataCountAndBind();
ctlUpdatePanelGridview.Update();
}
