protected void ctlProvinceFormView_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
short provinceId = UIHelper.ParseShort(ctlProvinceFormView.DataKey.Value.ToString());
DbProvince dbProvince = DbProvinceService.FindByIdentity(provinceId);
TextBox ctlTxtProvinceName = ctlProvinceFormView.FindControl("ctlTxtProvinceName") as TextBox;
DropDownList ctlCmbRegionId = ctlProvinceFormView.FindControl("ctlCmbRegionId") as DropDownList;
TextBox ctlTxtComment = ctlProvinceFormView.FindControl("ctlTxtComment") as TextBox;
CheckBox chkActive = ctlProvinceFormView.FindControl("chkActive") as CheckBox;
//Master
dbProvince.Region = DbRegionService.FindByIdentity(UIHelper.ParseShort(ctlCmbRegionId.SelectedValue));
dbProvince.Comment = ctlTxtComment.Text;
dbProvince.Active = chkActive.Checked;
dbProvince.UpdPgm = ProgramCode;
dbProvince.UpdDate = DateTime.Now.Date;
dbProvince.UpdBy = UserAccount.UserID;
try
{
DbProvinceService.Save(dbProvince);
e.Cancel = true;
ctlGridProvince.DataCountAndBind();
ctlProvinceModalPopupExtender.Hide();
UpdatePanelGridView.Update();
}
catch (ServiceValidationException ex)
{
ValidationErrors.MergeErrors(ex.ValidationErrors);
}
}
protected void ctlSelect_Click(object sender, ImageClickEventArgs e)
{
if (this.IsMultiSelect == true)
{
IList <DBProvinceLovReturn> dbProvinceList = new List <DBProvinceLovReturn>();
foreach (GridViewRow row in ctlGridProvince.Rows)
{
if ((row.RowType == DataControlRowType.DataRow) && ((CheckBox)row.FindControl("ctlSelect")).Checked)
{
short provinceId = UIHelper.ParseShort(ctlGridProvince.DataKeys[row.RowIndex].Value.ToString());
DbProvince province = DbProvinceService.FindByIdentity(provinceId);
Label ctlProvinceNameInGrid = ctlGridProvince.Rows[row.RowIndex].FindControl("ctlLblProvinceName") as Label;
Label ctlRegionNameInGrid = ctlGridProvince.Rows[row.RowIndex].FindControl("ctlLblRegionName") as Label;
DBProvinceLovReturn lovReturn = new DBProvinceLovReturn();
lovReturn.ProvinceID = province.Provinceid;
lovReturn.RegionID = province.Region.Regionid;
lovReturn.ProvinceName = ctlProvinceNameInGrid.Text;
lovReturn.RegionName = ctlRegionNameInGrid.Text;
dbProvinceList.Add(lovReturn);
}
}
CallOnObjectLookUpReturn(dbProvinceList);
Hide();
}
}
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken)
{
var province = new DbProvince {
ProvinceId = request.ProvinceId, RowVersion = request.RowVersion
};
_context.Set <DbProvince>().Attach(province);
_context.Set <DbProvince>().Remove(province);
await _context.SaveChangesAsync(cancellationToken);
return(Unit.Value);
}
protected void ctlGridProvince_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "ProvinceEdit")
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
short ProvinceId = UIHelper.ParseShort(ctlGridProvince.DataKeys[rowIndex].Value.ToString());
ctlGridProvince.EditIndex = rowIndex;
IList <DbProvince> provinceList = new List <DbProvince>();
DbProvince province = DbProvinceService.FindByIdentity(ProvinceId);
provinceList.Add(province);
ctlProvinceFormView.DataSource = provinceList;
ctlProvinceFormView.PageIndex = 0;
ctlProvinceFormView.ChangeMode(FormViewMode.Edit);
ctlProvinceFormView.DataBind();
UpdatePanelProvinceForm.Update();
ctlProvinceModalPopupExtender.Show();
ProvinceLangGridViewFinish();
}
else if (e.CommandName == "Select")
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
short provinceId = UIHelper.ParseShort(ctlGridProvince.DataKeys[rowIndex].Value.ToString());
ctlProvinceLangGrid.DataSource = SsDbQueryProvider.DbProvinceLangQuery.FindByProvinceId(provinceId);
ctlProvinceLangGrid.DataBind();
if (ctlProvinceLangGrid.Rows.Count > 0)
{
ctlSubmit.Visible = true;
ctlCancel.Visible = true;
ctlProvinceLangLangFds.Visible = true;
}
else
{
ctlSubmit.Visible = false;
ctlCancel.Visible = false;
ctlProvinceLangLangFds.Visible = false;
}
ctlProvinceLangUpdatePanel.Update();
}
}
protected void ctlProvinceFormView_DataBound(object sender, EventArgs e)
{
SetCombo();
if (ctlProvinceFormView.CurrentMode.Equals(FormViewMode.Edit))
{
Label ctlLblProvinceIDShow = ctlProvinceFormView.FindControl("ctlLblProvinceIDShow") as Label;
Label ctlLblProvinceNameShow = ctlProvinceFormView.FindControl("ctlLblProvinceNameShow") as Label;
LinkButton ctlProvinceIDInGrid = ctlGridProvince.Rows[ctlGridProvince.EditIndex].FindControl("ctlLinkProvinceId") as LinkButton;
Label ctlProvinceNameInGrid = ctlGridProvince.Rows[ctlGridProvince.EditIndex].FindControl("ctlLblProvinceName") as Label;
ctlLblProvinceIDShow.Text = ctlProvinceIDInGrid.Text;
ctlLblProvinceNameShow.Text = ctlProvinceNameInGrid.Text;
DropDownList ctlCmbRegionId = ctlProvinceFormView.FindControl("ctlCmbRegionId") as DropDownList;
DbProvince dbProvince = DbProvinceService.FindByIdentity(UIHelper.ParseShort(ctlProvinceIDInGrid.Text));
ctlCmbRegionId.SelectedValue = dbProvince.Region.Regionid.ToString();
}
}
protected void ctlBtnDeleteProvince_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in ctlGridProvince.Rows)
{
if ((row.RowType == DataControlRowType.DataRow) && ((CheckBox)row.FindControl("ctlSelect")).Checked)
{
short provinceId = UIHelper.ParseShort(ctlGridProvince.DataKeys[row.RowIndex].Value.ToString());
if (!((CheckBox)row.FindControl("ctlChkActive")).Checked)//ไม่ Active
{
try
{
DbProvince province = DbProvinceService.FindProxyByIdentity(provinceId);
SsDbDaoProvider.DbProvinceLangDao.DeleteAllProvinceLang(provinceId);
DbProvinceService.Delete(province);
UpdatePanelGridView.Update();
ProvinceLangGridViewFinish();
}
catch (Exception ex)
{
if (((System.Data.SqlClient.SqlException)(ex.GetBaseException())).Number == 547)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertInUseData",
"alert('Account ID : " + provinceId.ToString() + " is Active. Can't Delete It');", true);
}
}
}
else//Active
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertActiveData",
"alert('Account ID :" + provinceId.ToString() + " is Active. Can't Delete It');", true);
}
}
}
ctlGridProvince.DataCountAndBind();
}
protected void ctlSubmit_Click(object sender, EventArgs e)
{
IList <DbProvinceLang> provinceLangList = new List <DbProvinceLang>();
DbProvince province = new DbProvince(UIHelper.ParseShort(ctlGridProvince.SelectedValue.ToString()));
foreach (GridViewRow row in ctlProvinceLangGrid.Rows)
{
TextBox ctlProvinceName = (TextBox)ctlProvinceLangGrid.Rows[row.RowIndex].FindControl("ctlProvinceName");
TextBox ctlComment = (TextBox)ctlProvinceLangGrid.Rows[row.RowIndex].FindControl("ctlComment");
CheckBox ctlActive = (CheckBox)ctlProvinceLangGrid.Rows[row.RowIndex].FindControl("ctlActive");
if (!string.IsNullOrEmpty(ctlProvinceName.Text) || !string.IsNullOrEmpty(ctlComment.Text))
{
DbLanguage lang = new DbLanguage(UIHelper.ParseShort(ctlProvinceLangGrid.DataKeys[row.RowIndex].Value.ToString()));
DbProvinceLang provinceLang = new DbProvinceLang();
provinceLang.Language = lang;
provinceLang.Province = province;
provinceLang.ProvinceName = ctlProvinceName.Text;
provinceLang.Comment = ctlComment.Text;
provinceLang.Active = ctlActive.Checked;
provinceLang.CreBy = UserAccount.UserID;
provinceLang.CreDate = DateTime.Now;
provinceLang.UpdBy = UserAccount.UserID;;
provinceLang.UpdDate = DateTime.Now;
provinceLang.UpdPgm = ProgramCode;
provinceLangList.Add(provinceLang);
}
}
DbProvinceLangService.UpdateProvinceLang(provinceLangList);
ctlGridProvince.DataCountAndBind();
UpdatePanelGridView.Update();
ProvinceLangGridViewFinish();
}
protected void ctlGridProvince_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (this.IsMultiSelect == false)
{
if (e.CommandName.Equals("Select"))
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
short provinceId = UIHelper.ParseShort(ctlGridProvince.DataKeys[rowIndex].Value.ToString());
DbProvince province = DbProvinceService.FindByIdentity(provinceId);
Label ctlProvinceNameInGrid = ctlGridProvince.Rows[rowIndex].FindControl("ctlLblProvinceName") as Label;
Label ctlRegionNameInGrid = ctlGridProvince.Rows[rowIndex].FindControl("ctlLblRegionName") as Label;
DBProvinceLovReturn lovReturn = new DBProvinceLovReturn();
lovReturn.ProvinceID = province.Provinceid;
lovReturn.RegionID = province.Region.Regionid;
lovReturn.ProvinceName = ctlProvinceNameInGrid.Text;
lovReturn.RegionName = ctlRegionNameInGrid.Text;
CallOnObjectLookUpReturn(lovReturn);
Hide();
}
}
}
