protected void gvUsers_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
GridView gv = (GridView)sender;
GridViewRow gvr = (GridViewRow)gv.Rows[e.RowIndex];
Label lblSystemUserID = (Label)gvr.FindControl("lblSystemUserIDEdit");
int id = Convert.ToInt32(lblSystemUserID.Text);
int userRoleID = Convert.ToInt32(((DropDownList)gvr.FindControl("ddlUserRoleEdit")).SelectedValue);
Boolean invMgmt = Convert.ToBoolean(((CheckBox)gvr.FindControl("cbInventoryManagementEdit")).Checked);
using (FormContext ctx = new FormContext())
{
var systemUser = ctx.SystemUsers.Where(su => su.SystemUserID == id).FirstOrDefault();
systemUser.DisplayName = ((TextBox)gvr.FindControl("txtDisplayNameEdit")).Text;
systemUser.EmailAddress = ((TextBox)gvr.FindControl("txtEmailAddressEdit")).Text;
systemUser.Status = Convert.ToInt16(((RadioButtonList)gvr.FindControl("rblUserStatusEdit")).SelectedValue);
systemUser.UserRole = ctx.UserRoles.Where(ur => ur.UserRoleId == userRoleID).FirstOrDefault();
systemUser.InventoryApprovalUser = invMgmt;
ctx.SystemUsers.Attach(systemUser);
ctx.Entry(systemUser).State = EntityState.Modified;
ctx.SaveChanges();
gvUsers.DataBind();
lblUserMessage.Text = "";
}
}
catch (Exception ex)
{
lblUserMessage.Text = "Unable to update user. Please contact your system administrator.";
}
}
protected void gvSkus_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblAddSkuMessage = (Label)fvReport.FindControl("lblAddSkuMessage");
try
{
GridView gv = (GridView)sender;
GridViewRow gvr = (GridViewRow)gv.Rows[e.RowIndex];
Label lblRecordIdEdit = (Label)gvr.FindControl("lblRecordIdEdit");
int id = Convert.ToInt32(lblRecordIdEdit.Text);
using (FormContext ctx = new FormContext())
{
var sku = ctx.SkuQuantityItems.FirstOrDefault(x => x.RecordId == id);
sku.Completed = ((CheckBox)gvr.FindControl("cbCompletedEdit")).Checked;
sku.MaterialSku = ((TextBox)gvr.FindControl("txtMaterialSkuEdit")).Text;
sku.Quantity = ((TextBox)gvr.FindControl("txtQuantityEdit")).Text;
ctx.SkuQuantityItems.Attach(sku);
ctx.Entry(sku).State = EntityState.Modified;
ctx.SaveChanges();
gv.DataBind();
lblAddSkuMessage.Text = "";
}
}
catch (Exception ex)
{
lblAddSkuMessage.Text = "Unable to update Material SKU# and/or Quantity. Please contact your system administrator.";
}
}
protected void gvEmailList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
GridView gv = (GridView)sender;
GridViewRow gvr = (GridViewRow)gv.Rows[e.RowIndex];
Label lblEmailAddressID = (Label)gvr.FindControl("lblEmailAddressIDEdit");
int id = Convert.ToInt32(lblEmailAddressID.Text);
using (FormContext ctx = new FormContext())
{
var emailAddress = ctx.EmailAddresses.Where(ea => ea.EmailAddressID == id).FirstOrDefault();
emailAddress.Name = ((TextBox)gvr.FindControl("txtNameEdit")).Text;
emailAddress.Address = ((TextBox)gvr.FindControl("txtAddressEdit")).Text;
emailAddress.Status = Convert.ToInt16(((RadioButtonList)gvr.FindControl("rblStatusEdit")).SelectedValue);
emailAddress.Company = ((DropDownList)gvr.FindControl("ddlCompanyEdit")).SelectedValue;
ctx.EmailAddresses.Attach(emailAddress);
ctx.Entry(emailAddress).State = EntityState.Modified;
ctx.SaveChanges();
gvEmailList.DataBind();
lblEmailMessage.Text = "";
}
}
catch (Exception ex)
{
lblEmailMessage.Text = "Unable to update Email Address. Please contact your system administrator.";
}
}