public EditSecurityManagerModel EditSecurityManager(EditSecurityManagerModel editsecuritymanager)
        {
            AddParameter("@securitymanagerid", editsecuritymanager.SecurityManagerID);
            AddParameter("@communityid", editsecuritymanager.CommunityID);

            DataTable Dt_SecurityManagerDetails = this.GetDataTable("usp_GetSecurityManagerDetails");

            if (Dt_SecurityManagerDetails.Rows.Count > 0)
            {
                foreach (DataRow dr in Dt_SecurityManagerDetails.Rows)
                {
                    editSecurityManager = new EditSecurityManagerModel();

                    editSecurityManager.SecurityManagerID = Convert.ToInt64(dr["SecurityManagerID"].ToString());

                    editSecurityManager.CommunityID = Convert.ToInt16(dr["CommunityID"].ToString());

                    editSecurityManager.EmailID = dr["UserName"].ToString();
                    editSecurityManager.SM_HintQuestionID = Convert.ToByte(dr["HintQuestionID"].ToString());
                    editSecurityManager.SM_HintQuestion = dr["HintQuestion"].ToString();
                    editSecurityManager.SM_Hint = dr["Hint"].ToString();

                    editSecurityManager.CurrentPassword = dr["Password"].ToString();
                    editSecurityManager.SM_FirstName = dr["FirstName"].ToString();
                    editSecurityManager.SM_MiddleName = dr["MiddleName"].ToString();
                    editSecurityManager.SM_LastName = dr["LastName"].ToString();
                    editSecurityManager.SM_Mobile = dr["Mobile"].ToString();
                    editSecurityManager.SM_HomePhone = dr["HomePhone"].ToString();
                    editSecurityManager.SM_WorkPhone = dr["WorkPhone"].ToString();
                    editSecurityManager.SM_Address1 = dr["Address1"].ToString();
                    editSecurityManager.SM_Address2 = dr["Address2"].ToString();

                    if (!String.IsNullOrEmpty(dr["ModifiedOn"].ToString()))
                    {
                        editSecurityManager.SM_ModifiedOn = Convert.ToDateTime(dr["ModifiedOn"].ToString());
                        editSecurityManager.SM_ModifiedUserID = Convert.ToInt64(dr["ModifiedUserID"].ToString());
                        editSecurityManager.SM_ModifiedRoleID = Convert.ToByte(dr["ModifiedRoleID"].ToString());
                    }
                }
            }
            return editSecurityManager;
        }
        public ActionResult EditSecurityManager(String securitymanagerid, String communityid)
        {
            if (CommunityIDSanctityCheck(communityid))
            {
                if (SecurityManagerIDSanctityCheck(securitymanagerid))
                {
                    editSecurityManager = new EditSecurityManagerModel();
                    editSecurityManager.CommunityID = outCommunityID;
                    editSecurityManager.SecurityManagerID = outSecurityManagerID;

                    return PartialView("Partials/Users/SecurityManagers/EditSecurityManager", securityManagersDAL.EditSecurityManager(editSecurityManager));
                }
                else
                    return AjaxParamError("SecurityManager");
            }
            else
                return AjaxParamError("Community");
        }
 public ActionResult UpdateSecurityManager(EditSecurityManagerModel editsecuritymanager)
 {
     if (this.ModelState.IsValid)
     {
         editsecuritymanager.CommunityID = outCommunityID;
         editsecuritymanager.SM_ModifiedUserID = Convert.ToInt64(useMyCookie["UserID"].ToString());
         editsecuritymanager.SM_ModifiedOn = Convert.ToDateTime(DateTime.Now.ToShortDateString());
         return Json(securityManagersDAL.UpdateSecurityManager(editsecuritymanager).ToString());
     }
     else
         return AjaxDataError("SecurityManager");
 }
        public object UpdateSecurityManager(EditSecurityManagerModel editsecuritymanager)
        {
            AddParameter("@securitymanagerid", editsecuritymanager.SecurityManagerID);
            AddParameter("@communityid", editsecuritymanager.CommunityID);
            AddParameter("@password", editsecuritymanager.Password);
            AddParameter("@hintquestionid", editsecuritymanager.SM_HintQuestionID);
            AddParameter("@hint", editsecuritymanager.SM_Hint);

            AddParameter("@firstname", editsecuritymanager.SM_FirstName);
            AddParameter("@middlename", editsecuritymanager.SM_MiddleName);
            AddParameter("@lastname", editsecuritymanager.SM_LastName);
            AddParameter("@mobile", editsecuritymanager.SM_Mobile);
            AddParameter("@homephone", editsecuritymanager.SM_HomePhone);
            AddParameter("@workphone", editsecuritymanager.SM_WorkPhone);
            AddParameter("@address1", editsecuritymanager.SM_Address1);
            AddParameter("@address2", editsecuritymanager.SM_Address2);

            AddParameter("@modifiedon", editsecuritymanager.SM_ModifiedOn);
            AddParameter("@modifieduserid", editsecuritymanager.SM_ModifiedUserID);
            AddParameter("@modifiedroleid", editsecuritymanager.SM_ModifiedRoleID);

            return this.ExecuteScalar("usp_UpdateSecurityManager");
        }