protected void ddlUser_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
lblStatus.Text = string.Empty;
pnlDetails.Visible = true;
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
if (ddlUser.SelectedIndex == 0)
{
GetUsers(cntx, 0);
return;
}
int UserID = int.Parse(ddlUser.SelectedValue.ToString());
GetUsers(cntx, UserID);
}
}
catch (Exception ex)
{
pnlDetails.Visible = false;
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = ex.Message;
if (ex.InnerException != null)
{
lblStatus.Text = lblStatus.Text + "<br />" + ex.InnerException.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int userID = getCurrentUserID();
if (!IsPostBack)
{
try
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
bool isAdmin = (bool)cntx.Users.Where(f => f.UserID == userID).Select(f => f.IsAdmin).FirstOrDefault();
if (!isAdmin)
{
bool haveRights = PortalUtilities.fnHaveRights(userID, Convert.ToInt32(PortalUtilities.MenuLinks.ManageShipper));
if (!haveRights)
{
Response.Redirect("~/Admin/");
}
}
}
}
catch (Exception)
{
throw;
}
}
}
protected void GetUsers(ERP_CMSEntities cntx, int userID)
{
try
{
var obj = (from d in cntx.Users
where d.IsAdmin == false && d.UserID != userID
orderby d.UserName
select new { d.UserID, d.UserName, d.IsAdmin, d.IsActive }).ToList();
if (obj.Count > 0)
{
ddlUser.DataValueField = "UserID";
ddlUser.DataTextField = "UserName";
ddlUser.DataSource = obj;
ddlUser.DataBind();
ddlUser.Items.Insert(0, new ListItem("-- Select User --", ""));
}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int userID = getCurrentUserID();
if (!IsPostBack)
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
bool isAdmin = (bool)cntx.Users.Where(f => f.UserID == userID).Select(f => f.IsAdmin).FirstOrDefault();
if (!isAdmin)
{
//bool haveAddUserRights = PortalUtilities.fnHaveRights(userID, Convert.ToInt32(PortalUtilities.MenuLinks.AddUser));
var havePageRights = cntx.sp_GetPageRightsByUserAndMenuLinkID(userID, Convert.ToInt32(PortalUtilities.MenuLinks.ManageUsers)).Where(f => f.UserRightID > 0).ToList();
IList listRights = havePageRights.Select(f => f.Title).ToList();
if (havePageRights != null && havePageRights.Count > 0)
{
if (!listRights.Contains("Add User"))
{
Response.Redirect("~/Admin/");
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int userID = getCurrentUserID();
if (!IsPostBack)
{
try
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
bool isAdmin = (bool)cntx.Users.Where(f => f.UserID == userID).Select(f => f.IsAdmin).FirstOrDefault();
if (!isAdmin)
{
bool haveRights = PortalUtilities.fnHaveRights(userID, Convert.ToInt32(PortalUtilities.MenuLinks.ManageAgentType));
if (!haveRights)
{
Response.Redirect("~/Admin/");
}
}
}
}
catch (Exception)
{
throw;
}
//HttpContext.Current("") = userID;
//Server.Transfer("TreeLoader.ashx");
// Server.Transfer("AgentType_Handler.ashx?currentUser="******"AgentType_Handler.ashx?currentUser="******"AgentType_Handler.ashx?currentUser=" + userID);
}
}
protected void grd_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string UserName = e.Row.Cells[0].Text;
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
bool usr = (bool)(from c in cntx.Users
where c.UserName == UserName
select c.IsActive).FirstOrDefault();
//var usr = cntx.Users.Where(f => f.UserName == UserName).Select(f => f.IsActive).FirstOrDefault();
//var usr = cntx.Users.Find(UserName);
Image imgStatus = (Image)e.Row.FindControl("imgStatus");
if (usr)
{
imgStatus.ImageUrl = "~/Admin/images/icoactive.png";
}
else
{
imgStatus.ImageUrl = "~/Admin/images/icoblocked.png";
}
}
}
}
private void editAgentType(HttpContext context, int intID)
{
string output = "";
try
{
var JsonStr = context.Request["models"];
List <clsAgentType> AgentTypes = JsonConvert.DeserializeObject <List <clsAgentType> >(JsonStr);
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
string strName = AgentTypes[0].AgentType1.Trim().ToLower();
int agentTypeID = Convert.ToInt32(AgentTypes[0].AgentTypeID);
var obj = (from tbl in cntx.AgentTypes
where tbl.IsDeleted == false && tbl.AgentTypeID != agentTypeID && tbl.AgentType1.Trim().ToLower() == strName
select tbl).FirstOrDefault();
if (obj == null)
{
var objAgentTypes = cntx.AgentTypes.Where(f => f.AgentTypeID == agentTypeID).ToList().FirstOrDefault();
// Dim objBrands = New PortalModel.Brands With {.BrandID = Brands(0).BrandID}
var objAgentTypesOld = new ERP_CMSEntities().AgentTypes.Where(f => f.AgentTypeID == agentTypeID).ToList().FirstOrDefault();
cntx.AgentTypes.Attach(objAgentTypes);
{
//var withBlock = objBrands;
objAgentTypes.AgentType1 = AgentTypes[0].AgentType1;
}
cntx.SaveChanges();
try
{
// PortalUtilities.fnCompare((object)objBrandsOld, (object)objBrands, objBrands.BrandID, lstEmployeeAndCompanyID(0));
}
catch (Exception ex)
{
}
context.Response.ContentType = "application/json; charset=utf-8";
context.Response.Write(JsonStr);
}
else
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", "Agent Type Already Exist!");
context.Response.Write(objErr.ToString());
}
}
}
catch (Exception ex)
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", ex.Message);
context.Response.Write(objErr.ToString());
}
}
private void addShipper(HttpContext context, int intID)
{
string output = "";
try
{
var JsonStr = context.Request["models"];
List <clsShipper> Shippers = JsonConvert.DeserializeObject <List <clsShipper> >(JsonStr);
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
string shipperContact1 = Shippers[0].Contact1;
var obj = (from tbl in cntx.Shippers
where tbl.IsDeleted == false && tbl.Contact1 == shipperContact1
select tbl).FirstOrDefault();
if (obj == null)
{
var objShipper = new ERP_CMS.DB_Code.Shipper()
{
Shipper_Name = Shippers[0].Shipper_Name,
Shipper_Address = Shippers[0].Shipper_Address,
Shipper_Email = Shippers[0].Shipper_Email,
Contact1 = Shippers[0].Contact1,
Contact2 = Shippers[0].Contact2,
IsDeleted = false,
InsertedDate = DateTime.Now,
InsertedBy = userID
};
cntx.Shippers.Add(objShipper);
cntx.SaveChanges();
context.Response.ContentType = "application/json; charset=utf-8";
context.Response.Write(JsonStr);
}
else
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", "Shipper Already Exists!");
context.Response.Write(objErr.ToString());
}
}
}
catch (Exception ex)
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", ex.Message);
context.Response.Write(objErr.ToString());
}
}
protected void GetRights(ERP_CMSEntities cntx)
{
var assigned = cntx.sp_GetUserAssignedRights(int.Parse(ddlUser.SelectedValue)).ToList();
grdAssignedRights.DataSource = assigned;
grdAssignedRights.DataBind();
var nonassigned = cntx.sp_GetUserNonAssignedRights(int.Parse(ddlUser.SelectedValue)).ToList();
grdNonAssignedRights.DataSource = nonassigned;
grdNonAssignedRights.DataBind();
}
private void addAgentType(HttpContext context, int intID)
{
string output = "";
try
{
var JsonStr = context.Request["models"];
List <clsAgentType> AgentTypes = JsonConvert.DeserializeObject <List <clsAgentType> >(JsonStr);
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
string strName = AgentTypes[0].AgentType1.Trim().ToLower();
var obj = (from tbl in cntx.AgentTypes
where tbl.IsDeleted == false && tbl.AgentType1.Trim().ToLower() == strName
select tbl).FirstOrDefault();
if (obj == null)
{
var objAgentType = new ERP_CMS.DB_Code.AgentType()
{
AgentType1 = AgentTypes[0].AgentType1,
IsDeleted = false,
InsertedDate = DateTime.Now,
InsertedBy = userID
};
cntx.AgentTypes.Add(objAgentType);
cntx.SaveChanges();
context.Response.ContentType = "application/json; charset=utf-8";
context.Response.Write(JsonStr);
}
else
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", "Agent Type Already Exists!");
context.Response.Write(objErr.ToString());
}
}
}
catch (Exception ex)
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", ex.Message);
context.Response.Write(objErr.ToString());
}
}
protected void grdAssignedRights_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
try
{
int intUserID = int.Parse(ddlUser.SelectedValue);
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
// Dim rptInnerRights As Repeater = e.Row.FindControl("rptInnerRights")
GridView grdInnerRights = (GridView)e.Row.FindControl("grdAssignedRightsInner");
int intMenuLinkID = int.Parse(((HiddenField)e.Row.FindControl("hdnMenuLinkID")).Value);
var obj = cntx.sp_GetPageRightsByUserAndMenuLinkID(intUserID, intMenuLinkID).ToList();
if (obj.Count > 0)
{
// rptInnerRights.DataSource = obj
// rptInnerRights.DataBind()
grdInnerRights.DataSource = obj;
grdInnerRights.DataBind();
foreach (GridViewRow row in grdInnerRights.Rows)
{
CheckBox chkInner = (CheckBox)row.FindControl("chkInnerLink");
Label lblMenuLinkTextInner = (Label)row.FindControl("lblMenuLinkTextInner");
int hdnEmpRightID = int.Parse(((HiddenField)row.FindControl("hdnEmpRightID")).Value);
if (hdnEmpRightID > 0)
{
chkInner.Checked = true;
}
else
{
chkInner.Checked = false;
}
}
}
else
{
// rptInnerRights.DataSource = Nothing
// rptInnerRights.DataBind()
grdInnerRights.DataSource = null;
grdInnerRights.DataBind();
}
}
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
int userID = getCurrentUserID();
if (!IsPostBack)
{
//int userID = getCurrentUserID();
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
bool isAdmin = (bool)cntx.Users.Where(f => f.UserID == userID).Select(f => f.IsAdmin).FirstOrDefault();
if (!isAdmin)
{
var havePageRights = cntx.sp_GetPageRightsByUserAndMenuLinkID(userID, Convert.ToInt32(PortalUtilities.MenuLinks.ManageUsers)).Where(f => f.UserRightID > 0).ToList();
IList listRights = havePageRights.Select(f => f.Title).ToList();
if (havePageRights != null && havePageRights.Count > 0)
{
if (!listRights.Contains("List User"))
{
Response.Redirect("~/Admin/");
}
if (!listRights.Contains("Add User"))
{
pnlAdd.Visible = false;
}
}
}
try
{
var obj = (from d in cntx.Users
orderby d.UserName
select new { d.UserID, d.UserName, d.IsAdmin, d.IsActive }).ToList();
ddlUser.DataValueField = "UserID";
ddlUser.DataTextField = "UserName";
ddlUser.DataSource = obj;
ddlUser.DataBind();
ddlUser.Items.Insert(0, new ListItem("-- Select User --", ""));
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
GetUsers(cntx, 0);
}
}
}
protected void grdAssignedRights_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
int id = int.Parse(grdAssignedRights.DataKeys[e.RowIndex].Value.ToString());
int intUserID = int.Parse(ddlUser.SelectedValue);
lblStatus.Text = string.Empty;
lblMsg.Text = string.Empty;
try
{
// Dim obj = New PortalModel.EmpLinks With {.EmpLinkID = id}
var obj = cntx.UserLinks.Where(f => f.UserLinkID == id).ToList().FirstOrDefault();
int intMenuLinkID = (int)obj.MenuLinkID;
cntx.UserLinks.Attach(obj);
cntx.UserLinks.Remove(obj);
var objInner = cntx.sp_GetPageRightsByUserAndMenuLinkID(intUserID, intMenuLinkID).Where(f => f.UserRightID > 0).ToList();
foreach (var o in objInner)
{
var objEmpRights = cntx.UserRights.Where(f => f.PageRightID == o.PageRightID).ToList().FirstOrDefault();
{
cntx.UserRights.Attach(objEmpRights);
cntx.UserRights.Remove(objEmpRights);
}
}
cntx.SaveChanges();
GetRights(cntx);
lblStatus.ForeColor = System.Drawing.Color.DarkGreen;
lblStatus.Text = "Right Deleted Successfully.";
lblMsg.Text = "Right Deleted Successfully.";
}
catch (Exception ex)
{
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = ex.Message;
}
}
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
if (Page.IsValid)
{
bool UserCreated = false;
try
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
string password = EncryptionHelper.Encrypt("ERP_CMS2k18", txtPassword.Text);
var user = new User()
{
UserName = txtLoginName.Text,
Password = password,
IsActive = true,
IsAdmin = false,
IsDeleted = false
};
cntx.Users.Add(user);
cntx.SaveChanges();
UserCreated = true;
}
lblStatus.ForeColor = System.Drawing.Color.DarkGreen;
lblStatus.Text = "User Created Successfully...";
txtLoginName.Text = string.Empty;
txtPassword.Text = string.Empty;
txtConfirmPassword.Text = string.Empty;
}
catch (Exception ex)
{
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = ex.Message;
if (UserCreated)
{
//delete that user
}
}
}
}
protected void btnChangePassword_Click(object sender, System.EventArgs e)
{
try
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
int userID = getCurrentUserID();
var user = cntx.Users.Find(userID);
string resetPassword = EncryptionHelper.Encrypt("ERP_CMS2k18", txtPassword.Text);
user.Password = resetPassword;
cntx.SaveChanges();
lblStatus.Text = "Password changed successfully";
lblStatus.ForeColor = System.Drawing.Color.DarkGreen;
}
}
catch (Exception ex)
{
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = ex.Message;
}
}
protected void grdNonAssignedRights_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
try
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
// Dim rptInnerRights As Repeater = e.Row.FindControl("rptInnerRights")
GridView grdInnerRights = (GridView)e.Row.FindControl("grdNonAssignedRightsInner");
int intMenuLinkID = int.Parse(grdNonAssignedRights.DataKeys[e.Row.RowIndex].Value.ToString());
var obj = cntx.PageRights.Where(f => f.MenuLinkID == intMenuLinkID).ToList();
if (obj.Count > 0)
{
// rptInnerRights.DataSource = obj
// rptInnerRights.DataBind()
grdInnerRights.DataSource = obj;
grdInnerRights.DataBind();
foreach (GridViewRow row in grdInnerRights.Rows)
{
Label lblMenuLinkTextInner = (Label)row.FindControl("lblMenuLinkTextInner");
}
}
else
{
// rptInnerRights.DataSource = Nothing
// rptInnerRights.DataBind()
grdInnerRights.DataSource = null;
grdInnerRights.DataBind();
}
}
}
}
catch (Exception ex)
{
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
string userName = txtUserName.Text;
string password = txtPassword.Text;
string key = "ERP_CMS2k18";
//string encryptedUserName = EncryptionHelper.Encrypt(key, userName);
string encryptedPassword = EncryptionHelper.Encrypt(key, password);
ERP_CMSEntities db = new ERP_CMSEntities();
var obj = (from c in db.Users
where c.UserName == userName && c.Password == encryptedPassword && c.IsDeleted == false
select new { c.UserID, c.IsActive }).FirstOrDefault();
if (obj != null)
{
if (obj.UserID != 0)
{
if (obj.IsActive == false)
{
ErrorMessage.Visible = true;
FailureText.Text = "This User is Blocked";
return;
}
Session["userID"] = obj.UserID;
ErrorMessage.Visible = false;
Response.Redirect("~/Admin/Default.aspx");
}
}
else
{
ErrorMessage.Visible = true;
FailureText.Text = "Invalid User Name or Password";
}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int userID = getCurrentUserID();
if (!IsPostBack)
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
bool isAdmin = (bool)cntx.Users.Where(f => f.UserID == userID).Select(f => f.IsAdmin).FirstOrDefault();
if (!isAdmin)
{
bool haveRights = PortalUtilities.fnHaveRights(userID, Convert.ToInt32(PortalUtilities.MenuLinks.ChangePassword));
if (!haveRights)
{
Response.Redirect("~/Admin/");
}
}
var user = cntx.Users.Where(f => f.UserID == userID).Select(f => f.UserName).FirstOrDefault();
if (user == null && user.Equals(null))
{
lblUserName.Text = "-- Invalid User --";
btnChangePassword.Enabled = false;
txtPassword.Enabled = false;
txtConfirmPassword.Enabled = false;
}
else
{
lblUserName.Text = user;
//txtEmailAddress.Text = user.Email
//lblUserRole.Text = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(Roles.GetRolesForUser(strUserName)(0))
//strRole = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(Roles.GetRolesForUser(strUserName)(0))
//Dim objEmployee = cntx.Employees.Where(Function(f) f.EmployeeID = intEmpID).ToList().FirstOrDefault()
//txtEmailAddress.Text = objEmployee.Email
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int userID = getCurrentUserID();
try
{
if (!IsPostBack)
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
bool isAdmin = (bool)cntx.Users.Where(f => f.UserID == userID).Select(f => f.IsAdmin).FirstOrDefault();
if (!isAdmin)
{
bool haveManageUserRights = PortalUtilities.fnHaveRights(userID, Convert.ToInt32(PortalUtilities.MenuLinks.ManageUsers));
bool haveManageRights = PortalUtilities.fnHaveRights(userID, Convert.ToInt32(PortalUtilities.MenuLinks.ManageRights));
bool haveChangePasswordRights = PortalUtilities.fnHaveRights(userID, Convert.ToInt32(PortalUtilities.MenuLinks.ChangePassword));
if (!haveManageUserRights)
{
divManageUsersDashboard.Visible = false;
}
if (!haveManageRights)
{
divManageRightsDashboard.Visible = false;
}
if (!haveChangePasswordRights)
{
divChangePasswordDashboard.Visible = false;
}
}
}
}
}
catch (Exception ex)
{
//lblStatus.Text = ex.Message;
}
}
private void deleteAgentType(HttpContext context, int intID)
{
string output = "";
try
{
var JsonStr = context.Request["models"];
List <clsAgentType> AgentTypes = JsonConvert.DeserializeObject <List <clsAgentType> >(JsonStr);
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
var objAgentTypes = new ERP_CMS.DB_Code.AgentType()
{
AgentTypeID = Convert.ToInt32(AgentTypes[0].AgentTypeID)
};
//objAgentTypes.DeletedBy = userID;
// Dim objBrands = New PortalModel.Brands With {.BrandID = intID}
cntx.AgentTypes.Attach(objAgentTypes);
objAgentTypes.IsDeleted = true;
objAgentTypes.DeletedBy = userID;
objAgentTypes.DeletedDate = DateTime.Now;
// cntx.Brands.DeleteObject(objBrands)
cntx.SaveChanges();
}
context.Response.ContentType = "application/json; charset=utf-8";
context.Response.Write(JsonStr);
}
catch (Exception ex)
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", ex.Message);
context.Response.Write(objErr.ToString());
}
}
protected void rptrMenus_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
int userID = getCurrentUserID();
int intID = (int)DataBinder.Eval(e.Item.DataItem, "MenuID");
Repeater rptrMenuLinks = (Repeater)e.Item.FindControl("rptrMenuLinks");
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
bool isAdmin = PortalUtilities.isUserAdmin(cntx, userID);
if (isAdmin)
{
Label lblID = (Label)e.Item.FindControl("lblID");
int menuID = Convert.ToInt32(lblID.Text.ToString());
var objMenuLinks = (from ml in cntx.MenuLinks
where ml.MenuID == menuID
orderby ml.DisplayOrder
select new { ml.MenuLinkText, ml.PageURL }).ToList();
rptrMenuLinks.DataSource = objMenuLinks;
rptrMenuLinks.DataBind();
}
else
{
var objMenuLinks = (from el in cntx.UserLinks
join usr in cntx.Users on el.UserID equals usr.UserID
join ml in cntx.MenuLinks on el.MenuLinkID equals ml.MenuLinkID
join m in cntx.Menus on ml.MenuID equals m.MenuID
where usr.UserID == userID & m.MenuID == intID
select new { ml.MenuLinkText, ml.PageURL, ml.DisplayOrder }).Distinct().OrderBy(f => f.DisplayOrder).ToList();
rptrMenuLinks.DataSource = objMenuLinks;
rptrMenuLinks.DataBind();
}
}
}
}
protected void GetUsers(ERP_CMSEntities cntx, int UserID)
{
var obj = (from d in cntx.Users
orderby d.UserName
select new { d.UserID, d.UserName, d.IsAdmin, d.IsActive }).ToList();
if (UserID > 0)
{
obj = obj.Where(f => f.UserID == UserID).ToList();
}
grd.DataSource = obj;
grd.DataBind();
if (obj.Count > 0)
{
grd.DataSource = obj;
grd.DataBind();
}
else
{
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = "0 records found in selected user!";
}
}
private void getAgentTypeList(HttpContext context)
{
try
{
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
var obj = (from b in cntx.AgentTypes
where b.IsDeleted == false
orderby b.AgentType1
select new { b.AgentTypeID, b.AgentType1 }).ToList();
string JsonStr = JsonConvert.SerializeObject(new { agentTypeList = obj });
context.Response.ContentType = "application/json; charset=utf-8";
context.Response.Write(JsonStr);
}
}
catch (Exception ex)
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", ex.Message);
context.Response.Write(objErr.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (!string.IsNullOrEmpty(Session["isAdmin"] as string))
//{
// string isAdmin = Session["isAdmin"].ToString();
// if (!isAdmin.Equals("True"))
// {
// Response.Redirect("~/Account/Login.aspx");
// }
//}
//else
//{
// Response.Redirect("~/Account/Login.aspx");
//}
if (!IsPostBack)
{
Page.Header.DataBind();
int userID = getCurrentUserID();
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
bool isAdmin = PortalUtilities.isUserAdmin(cntx, userID);
if (isAdmin)
{
var objPanels = (from p in cntx.MenuPanels
orderby p.DisplayOrder
select new { p.PanelID, p.PanelTitle }).ToList();
rptrMenuPanels.DataSource = objPanels;
rptrMenuPanels.DataBind();
}
else
{
var objPanels = (from el in cntx.UserLinks
join usr in cntx.Users on el.UserID equals usr.UserID
join ml in cntx.MenuLinks on el.MenuLinkID equals ml.MenuLinkID
join m in cntx.Menus on ml.MenuID equals m.MenuID
join mp in cntx.MenuPanels on m.PanelID equals mp.PanelID
where usr.UserID == userID
select new { mp.PanelID, mp.PanelTitle, mp.DisplayOrder }).Distinct().OrderBy(f => f.DisplayOrder).ToList();
rptrMenuPanels.DataSource = objPanels;
rptrMenuPanels.DataBind();
}
bool haveChangePassword = PortalUtilities.fnHaveRights(userID, Convert.ToInt32(PortalUtilities.MenuLinks.ChangePassword));
if (haveChangePassword)
{
sideMenuLinkPassword.Visible = true;
sideMenuDivider.Visible = true;
}
var objUserRights = cntx.sp_GetPageRightsByUserAndMenuLinkID(userID, Convert.ToInt32(PortalUtilities.MenuLinks.Profile)).Where(f => f.UserRightID > 0).ToList();
IList lstRights = objUserRights.Select(f => f.Title).ToList();
bool haveProfile = PortalUtilities.fnHaveRights(userID, Convert.ToInt32(PortalUtilities.MenuLinks.Profile));
if (objUserRights.Count > 0 && haveProfile == true && (lstRights.Contains("View Self") || lstRights.Contains("Edit Self")))
{
sideMenuLinkProfile.Visible = true;
sideMenuDivider.Visible = true;
}
try
{
var objUser = cntx.Users.Where(f => f.UserID == userID).ToList().FirstOrDefault();
lblLnkSideProfile.Text = objUser.UserName;
}
catch (Exception)
{
throw;
}
}
}
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
try
{
lblStatus.Text = "";
lblMsg.Text = "";
int intUserId = int.Parse(ddlUser.SelectedValue);
int intMenuLinkID;
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
foreach (GridViewRow row in grdNonAssignedRights.Rows)
{
CheckBox chk = (CheckBox)row.FindControl("chkLink");
if (chk.Checked == true)
{
intMenuLinkID = int.Parse(grdNonAssignedRights.DataKeys[row.RowIndex].Value.ToString());
var objUserLinks = new UserLink()
{
UserID = intUserId,
MenuLinkID = intMenuLinkID
//UserID = intUserId,
//objUserLinks.MenuLinkID = intMenuLinkID;
};
cntx.UserLinks.Add(objUserLinks);
cntx.SaveChanges();
// Dim rptInnerRights As Repeater = row.FindControl("rptInnerRights")
// For Each rptItem As RepeaterItem In rptInnerRights.Items
// Dim chkInner As CheckBox = rptItem.FindControl("chkInnerLink")
// If chkInner.Checked Then
// Dim objEmpRights As New PortalModel.EmpRights
// Dim intPageRightID As Integer = DirectCast(rptItem.FindControl("hdnPageRightID"), HiddenField).Value
// With objEmpRights
// .EmployeeID = intUserID
// .PageRightID = intPageRightID
// End With
// cntx.EmpRights.AddObject(objEmpRights)
// End If
// Next
GridView grdInnerRights = (GridView)row.FindControl("grdNonAssignedRightsInner");
foreach (GridViewRow rptItem in grdInnerRights.Rows)
{
try
{
CheckBox chkInner = (CheckBox)rptItem.FindControl("chkInnerLink");
int intPageRightID = int.Parse(((HiddenField)rptItem.FindControl("hdnPageRightID")).Value);
if (chkInner.Checked)
{
var objUserRights = new UserRight();
{
//var withBlock = objEmpRights;
objUserRights.UserID = intUserId;
objUserRights.PageRightID = intPageRightID;
}
cntx.UserRights.Add(objUserRights);
}
else
{
var objExisting = cntx.UserRights.Where(f => f.UserID == intUserId && f.PageRightID == intPageRightID).ToList().FirstOrDefault();
if (objExisting != null)
{
cntx.UserRights.Remove(objExisting);
}
}
}
catch (Exception ex)
{
}
}
}
}
foreach (GridViewRow rowParent in grdAssignedRights.Rows)
{
GridView grdInner = (GridView)rowParent.FindControl("grdAssignedRightsInner");
int MenuLinkID = int.Parse(((HiddenField)rowParent.FindControl("hdnMenuLinkID")).Value);
foreach (GridViewRow row in grdInner.Rows)
{
CheckBox chkInner = (CheckBox)row.FindControl("chkInnerLink");
try
{
int intPageRightID = int.Parse(((HiddenField)row.FindControl("hdnPageRightID")).Value);
var objExistingList = cntx.UserRights.Where(f => f.UserID == intUserId && f.PageRightID == intPageRightID).ToList();
foreach (var objExisting in objExistingList)
{
cntx.UserRights.Remove(objExisting);
cntx.SaveChanges();
}
if (chkInner.Checked)
{
var objUserRights = new UserRight();
{
objUserRights.UserID = intUserId;
objUserRights.PageRightID = intPageRightID;
}
cntx.UserRights.Add(objUserRights);
}
}
catch (Exception ex)
{
}
}
}
cntx.SaveChanges();
GetRights(cntx);
lblMsg.ForeColor = System.Drawing.Color.DarkGreen;
lblMsg.Text = "Rights updated successfully...";
}
}
catch (Exception ex)
{
}
}
private void editShipper(HttpContext context, int intID)
{
string output = "";
try
{
var JsonStr = context.Request["models"];
List <clsShipper> Shippers = JsonConvert.DeserializeObject <List <clsShipper> >(JsonStr);
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
string shipperContact1 = Shippers[0].Contact1;
int shipperID = Convert.ToInt32(Shippers[0].ShipperID);
var obj = (from tbl in cntx.Shippers
where tbl.IsDeleted == false && tbl.ShipperID != shipperID && tbl.Contact1 == shipperContact1
select tbl).FirstOrDefault();
if (obj == null)
{
var objShipper = cntx.Shippers.Where(f => f.ShipperID == shipperID).ToList().FirstOrDefault();
// Dim objBrands = New PortalModel.Brands With {.BrandID = Brands(0).BrandID}
var objShipperOld = new ERP_CMSEntities().Shippers.Where(f => f.ShipperID == shipperID).ToList().FirstOrDefault();
cntx.Shippers.Attach(objShipper);
{
//var withBlock = objBrands;
objShipper.Shipper_Name = Shippers[0].Shipper_Name;
objShipper.Shipper_Address = Shippers[0].Shipper_Address;
objShipper.Shipper_Email = Shippers[0].Shipper_Email;
objShipper.Contact1 = Shippers[0].Contact1;
objShipper.Contact2 = Shippers[0].Contact2;
}
cntx.SaveChanges();
try
{
// PortalUtilities.fnCompare((object)objBrandsOld, (object)objBrands, objBrands.BrandID, lstEmployeeAndCompanyID(0));
}
catch (Exception ex)
{
}
context.Response.ContentType = "application/json; charset=utf-8";
context.Response.Write(JsonStr);
}
else
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", "Shipper Already Exist!");
context.Response.Write(objErr.ToString());
}
}
}
catch (Exception ex)
{
context.Response.ContentType = "application/json; charset=utf-8";
Newtonsoft.Json.Linq.JObject objErr = new Newtonsoft.Json.Linq.JObject();
objErr.Add("Errors", ex.Message);
context.Response.Write(objErr.ToString());
}
}
protected void grd_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
{
if (e.CommandName == "chngStatus")
{
try
{
int RowIndex = int.Parse(e.CommandArgument.ToString());
int UserID = int.Parse(grd.DataKeys[RowIndex]["UserID"].ToString());
string UserName = grd.Rows[RowIndex].Cells[0].Text;
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
//var usr = cntx.Users.Where(f => f.UserName == UserName).Select(f => f.UserName).FirstOrDefault();
var usr = cntx.Users.Find(UserID);
if (UserName == "admin")
{
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = "admin user can not be blocked.";
}
else
{
usr.IsActive = !usr.IsActive;
cntx.SaveChanges();
lblStatus.ForeColor = System.Drawing.Color.DarkGreen;
lblStatus.Text = "User status has been updated.";
GetUsers(cntx, UserID);
}
}
//MembershipUser usr = Membership.GetUser(UserName);
}
catch (Exception ex)
{
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = ex.Message;
}
}
else if (e.CommandName == "chngPwd")
{
try
{
int RowIndex = int.Parse(e.CommandArgument.ToString());
int UserID = int.Parse(grd.DataKeys[RowIndex]["UserID"].ToString());
string UserName = grd.Rows[RowIndex].Cells[0].Text;
//MembershipUser usr = Membership.GetUser(UserName);
using (ERP_CMSEntities cntx = new ERP_CMSEntities())
{
//var usr = cntx.Users.Where(f => f.UserName == UserName).Select(f => f.UserName).FirstOrDefault();
string newPassword = PortalUtilities.resetPassword(cntx, UserID);
}
lblStatus.Text = "Password updated with: " + UserName + "@12345";
lblStatus.ForeColor = System.Drawing.Color.DarkGreen;
}
catch (Exception ex)
{
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = ex.Message;
}
}
}
