//public ActionResult SecurityPersonnelDetails(String securitypersonnelid, String communityid) //{ // if (CommunityIDSanctityCheck(communityid)) // { // if (SecurityPersonnelIDSanctityCheck(securitypersonnelid)) // { // securityPersonnel = new SecurityPersonnelsModel(); // securityPersonnel.CommunityID = outCommunityID; // securityPersonnel.SecurityPersonnelID = Convert.ToInt64(securitypersonnelid); // return PartialView("Partials/Users/SecurityPersonnels/SecurityPersonnelDetails", securityPersonnelsDAL.SecurityPersonnelDetails(securityPersonnel)); // } // else // return AjaxParamError("SecurityPersonnel"); // } // else // return AjaxParamError("Community"); //} public ActionResult EditSecurityPersonnel(String securitypersonnelid, String communityid) { if (CommunityIDSanctityCheck(communityid)) { if (SecurityPersonnelIDSanctityCheck(securitypersonnelid)) { editSecurityPersonnel = new EditSecurityPersonnelModel(); editSecurityPersonnel.CommunityID = outCommunityID; editSecurityPersonnel.SecurityPersonnelID = outSecurityPersonnelID; return PartialView("Partials/Users/SecurityPersonnels/EditSecurityPersonnel", securityPersonnelsDAL.EditSecurityPersonnel(editSecurityPersonnel)); } else return AjaxParamError("SecurityPersonnel"); } else return AjaxParamError("Community"); }
internal Object UpdateSecurityPerson(EditSecurityPersonnelModel editsecuritypersonnel) { AddParameter("@securitypersonnelid", editsecuritypersonnel.SecurityPersonnelID); AddParameter("@communityid", editsecuritypersonnel.CommunityID); AddParameter("@password", editsecuritypersonnel.Password); AddParameter("@hintquestionid", editsecuritypersonnel.SP_HintQuestionID); AddParameter("@hint", editsecuritypersonnel.SP_Hint); AddParameter("@firstname", editsecuritypersonnel.SP_FirstName); AddParameter("@middlename", editsecuritypersonnel.SP_MiddleName); AddParameter("@lastname", editsecuritypersonnel.SP_LastName); AddParameter("@mobile", editsecuritypersonnel.SP_Mobile); AddParameter("@homephone", editsecuritypersonnel.SP_HomePhone); AddParameter("@workphone", editsecuritypersonnel.SP_WorkPhone); AddParameter("@address1", editsecuritypersonnel.SP_Address1); AddParameter("@address2", editsecuritypersonnel.SP_Address2); AddParameter("@modifieduserid", editsecuritypersonnel.SP_ModifiedUserID); AddParameter("@modifiedroleid", editsecuritypersonnel.SP_ModifiedRoleID); AddParameter("@modifiedon", editsecuritypersonnel.SP_ModifiedOn); return this.ExecuteScalar("usp_UpdateSecurityPersonnel"); }
public ActionResult UpdateSecurityPersonnel(EditSecurityPersonnelModel editsecuritypersonnel) { if (this.ModelState.IsValid) { editsecuritypersonnel.CommunityID = outCommunityID; editsecuritypersonnel.SP_ModifiedOn = Convert.ToDateTime(DateTime.Now.ToShortDateString()); editsecuritypersonnel.SP_ModifiedUserID = Convert.ToInt64(useMyCookie["UserID"].ToString()); editsecuritypersonnel.SP_ModifiedRoleID = Convert.ToByte(useMyCookie["RoleID"].ToString()); return Json(securityPersonnelsDAL.UpdateSecurityPerson(editsecuritypersonnel)); } else return AjaxDataError("SecurityPersonnel"); }
internal EditSecurityPersonnelModel EditSecurityPersonnel(EditSecurityPersonnelModel editsecuritypersonnel) { AddParameter("@securitypersonnelid", editsecuritypersonnel.SecurityPersonnelID); AddParameter("@communityid", editsecuritypersonnel.CommunityID); DataTable Dt_SecurityPersonnelDetails = this.GetDataTable("usp_GetSecurityPersonnelDetails"); if (Dt_SecurityPersonnelDetails.Rows.Count > 0) { foreach (DataRow dr in Dt_SecurityPersonnelDetails.Rows) { editsecuritypersonnel = new EditSecurityPersonnelModel(); editsecuritypersonnel.SecurityPersonnelID = Convert.ToInt64(dr["SecurityPersonnelID"].ToString()); editsecuritypersonnel.CommunityID = Convert.ToInt16(dr["CommunityID"].ToString()); editsecuritypersonnel.EmailID = dr["UserName"].ToString(); editsecuritypersonnel.SP_HintQuestionID = Convert.ToByte(dr["HintQuestionID"].ToString()); editsecuritypersonnel.SP_HintQuestion = dr["HintQuestion"].ToString(); editsecuritypersonnel.SP_Hint = dr["Hint"].ToString(); editsecuritypersonnel.CurrentPassword = dr["Password"].ToString(); editsecuritypersonnel.SP_FirstName = dr["FirstName"].ToString(); editsecuritypersonnel.SP_MiddleName = dr["MiddleName"].ToString(); editsecuritypersonnel.SP_LastName = dr["LastName"].ToString(); editsecuritypersonnel.SP_Mobile = dr["Mobile"].ToString(); editsecuritypersonnel.SP_HomePhone = dr["HomePhone"].ToString(); editsecuritypersonnel.SP_WorkPhone = dr["WorkPhone"].ToString(); editsecuritypersonnel.SP_Address1 = dr["Address1"].ToString(); editsecuritypersonnel.SP_Address2 = dr["Address2"].ToString(); if (!String.IsNullOrEmpty(dr["ModifiedOn"].ToString())) { editsecuritypersonnel.SP_ModifiedOn = Convert.ToDateTime(dr["ModifiedOn"].ToString()); editsecuritypersonnel.SP_ModifiedUserID = Convert.ToInt64(dr["ModifiedUserID"].ToString()); editsecuritypersonnel.SP_ModifiedRoleID = Convert.ToByte(dr["ModifiedRoleID"].ToString()); } } } return editsecuritypersonnel; }