public Object DeleteSecurityManager(SecurityManagersModel securitymanager)
{
AddParameter("@securitymanagerid", securitymanager.SecurityManagerID);
AddParameter("@communityid", securitymanager.CommunityID);
AddParameter("@modifiedon", securitymanager.SM_ModifiedOn);
AddParameter("@modifieduserid", securitymanager.SM_ModifiedUserID);
AddParameter("@modifiedroleid", securitymanager.SM_ModifiedRoleID);
return ExecuteScalar("usp_DeleteSecurityManager");
}
public object AddSecurityManager(SecurityManagersModel securitymanager)
{
AddParameter("@communityid", securitymanager.CommunityID);
AddParameter("@username", securitymanager.EmailID);
AddParameter("@password", securitymanager.Password);
AddParameter("@hintquestionid", securitymanager.SM_HintQuestionID);
AddParameter("@hint", securitymanager.SM_Hint);
AddParameter("@firstname", securitymanager.SM_FirstName);
AddParameter("@middlename", securitymanager.SM_MiddleName);
AddParameter("@lastname", securitymanager.SM_LastName);
AddParameter("@mobile", securitymanager.SM_Mobile);
AddParameter("@homephone", securitymanager.SM_HomePhone);
AddParameter("@workphone", securitymanager.SM_WorkPhone);
AddParameter("@address1", securitymanager.SM_Address1);
AddParameter("@address2", securitymanager.SM_Address2);
AddParameter("@createdon", DateTime.Now.ToString());
AddParameter("@createduserid", securitymanager.SM_CreatedUserID);
AddParameter("@createdroleid", securitymanager.SM_CreatedRoleID);
return this.ExecuteScalar("usp_AddSecurityManager");
}
public ActionResult SecurityManagersListTable()
{
securityManager = new SecurityManagersModel();
securityManager.CommunityID = myCommunityID;
ViewBag.SecurityManagersList = securityManagersDAL.SecurityManagersList(securityManager);
return PartialView("Partials/Users/SecurityManagers/SecurityManagersListTable");
}
public ActionResult SecurityManagerDetails(String securitymanagerid)
{
if (SecurityManagerIDSanctityCheck(securitymanagerid))
{
securityManager = new SecurityManagersModel();
securityManager.CommunityID = myCommunityID;
securityManager.SecurityManagerID = outSecurityManagerID;
return PartialView("Partials/Users/SecurityManagers/SecurityManagerDetails", securityManagersDAL.SecurityManagerDetails(securityManager));
}
else
return AjaxParamError("SecurityManager");
}
public ActionResult RegistrationPartial(String roleid)
{
if (RoleIDSanctityCheck(roleid))
{
String partial = null;
ViewBag.CommunityID = myCommunityID;
Object loadModel = null;
switch (roleid)
{
case "2": partial = "Administrators/NewAdministrator";
administrator = new AdministratorsModel();
administrator.CommunityID = myCommunityID;
loadModel = administrator;
break;
case "3": partial = "SecurityManagers/NewSecurityManager";
securityManager = new SecurityManagersModel();
securityManager.CommunityID = myCommunityID;
loadModel = securityManager;
break;
case "4": partial = "SecurityPersonnels/NewSecurityPerson";
securityPersonnel = new SecurityPersonnelsModel();
securityPersonnel.CommunityID = myCommunityID;
loadModel = securityPersonnel;
break;
case "5": partial = "HomeOwners/NewHomeOwner";
homeOwner = new HomeOwnersModel();
homeOwner.CommunityID = myCommunityID;
loadModel = homeOwner;
break;
case "6": partial = "ServiceProviders/NewServiceProvider";
serviceProvider = new ServiceProvidersModel();
serviceProvider.CommunityID = myCommunityID;
loadModel = serviceProvider;
break;
}
return PartialView("Partials/Users/" + partial, loadModel);
}
else
return AjaxParamError("Role");
}
public ActionResult NewSecurityManager(SecurityManagersModel securityManager)
{
if (this.ModelState.IsValid)
{
securityManager.SM_CreatedOn = Convert.ToDateTime(DateTime.Now.ToString());
securityManager.SM_CreatedUserID = Convert.ToInt64(useMyCookie["UserID"].ToString());
securityManager.SM_CreatedRoleID = Convert.ToByte(useMyCookie["RoleID"].ToString());
return Json(securityManagersDAL.AddSecurityManager(securityManager));
}
else
return AjaxDataError("SecurityManager");
}
public ActionResult DeleteSecurityManager(String securitymanagerid)
{
if (SecurityManagerIDSanctityCheck(securitymanagerid))
{
securityManager = new SecurityManagersModel();
securityManager.CommunityID = myCommunityID;
securityManager.SecurityManagerID = outSecurityManagerID;
securityManager.SM_ModifiedUserID = Convert.ToInt64(useMyCookie["UserID"].ToString());
securityManager.SM_ModifiedOn = Convert.ToDateTime(DateTime.Now.ToShortDateString());
return Json(securityManagersDAL.DeleteSecurityManager(securityManager).ToString());
}
else return AjaxParamError("SecurityManager");
}
private void SecurityManagersList()
{
securityManager = new SecurityManagersModel();
securityManager.CommunityID = myCommunityID;
ViewBag.SecurityManagersList = securityManagersDAL.SecurityManagersList(securityManager);
}
public ActionResult UpdateSecurityManager(SecurityManagersModel securityManager)
{
if (this.ModelState.IsValid)
{
securityManager.CommunityID = myCommunityID;
securityManager.SM_ModifiedUserID = Convert.ToInt64(useMyCookie["UserID"].ToString());
securityManager.SM_ModifiedOn = Convert.ToDateTime(DateTime.Now.ToShortDateString());
return Json(securityManagersDAL.UpdateSecurityManager(securityManager).ToString());
}
else
return AjaxDataError("SecurityManager");
}
private void NewSecurityManagerCommunity(ref SecurityManagersModel newsecuritymanager)
{
securityManagersDAL.NewSecurityManagerCommunity(ref newsecuritymanager);
}
public ActionResult SecurityManagersListTable(String communityid)
{
if (CommunityIDSanctityCheck(communityid))
{
securityManager = new SecurityManagersModel();
securityManager.CommunityID = outCommunityID;;
return PartialView("Partials/Users/SecurityManagers/SecurityManagersListTable", securityManagersDAL.SecurityManagersList(securityManager));
}
else
return AjaxParamError("Community");
}
public List<SecurityManagersModel> SecurityManagersList(SecurityManagersModel securitymanager)
{
AddParameter("@communityid", securitymanager.CommunityID);
DataTable Dt_SecurityManagersList = GetDataTable("usp_GetSecurityManagersList");
securityManagersList = new List<SecurityManagersModel>();
if (Dt_SecurityManagersList.Rows.Count > 0)
{
foreach (DataRow dr in Dt_SecurityManagersList.Rows)
{
securityManagerObj = new SecurityManagersModel();
securityManagerObj.SecurityManagerID = Convert.ToInt64(dr["SecurityManagerID"].ToString());
securityManagerObj.CommunityID = Convert.ToInt16(dr["CommunityID"].ToString());
securityManagerObj.CommunityName = dr["CommunityName"].ToString();
securityManagerObj.CommunityAddress = dr["CommunityAddress"].ToString();
securityManagerObj.City = dr["City"].ToString();
securityManagerObj.Zip = dr["Zip"].ToString();
securityManagerObj.State = dr["State"].ToString();
securityManagerObj.Country = dr["Country"].ToString();
securityManagerObj.CommunityPhone1 = dr["CommunityPhone1"].ToString();
securityManagerObj.CommunityPhone2 = dr["CommunityPhone2"].ToString();
securityManagerObj.CommunityEmail = dr["CommunityEmail"].ToString();
securityManagerObj.TotalUnits = Convert.ToByte(dr["TotalUnits"].ToString());
securityManagerObj.MaxGates = Convert.ToByte(dr["MaxGates"].ToString());
securityManagerObj.MenuOptions = dr["MenuOptions"].ToString();
securityManagerObj.EmailID = dr["UserName"].ToString();
securityManagerObj.SM_HintQuestionID = Convert.ToByte(dr["HintQuestionID"].ToString());
securityManagerObj.SM_HintQuestion = dr["HintQuestion"].ToString();
securityManagerObj.SM_Hint = dr["Hint"].ToString();
securityManagerObj.VFCode = dr["VFCode"].ToString();
securityManagerObj.UserStatus = Convert.ToChar(dr["Status"]);
securityManagerObj.UserID = securityManagerObj.SecurityManagerID;
securityManagerObj.Password = dr["Password"].ToString();
securityManagerObj.RoleID = Convert.ToByte(dr["RoleID"].ToString());
securityManagerObj.Role = dr["Role"].ToString();
securityManagerObj.SM_FirstName = dr["FirstName"].ToString();
securityManagerObj.SM_MiddleName = dr["MiddleName"].ToString();
securityManagerObj.SM_LastName = dr["LastName"].ToString();
securityManagerObj.SM_Mobile = dr["Mobile"].ToString();
securityManagerObj.SM_HomePhone = dr["HomePhone"].ToString();
securityManagerObj.SM_WorkPhone = dr["WorkPhone"].ToString();
securityManagerObj.SM_Address1 = dr["Address1"].ToString();
securityManagerObj.SM_Address2 = dr["Address2"].ToString();
securityManagerObj.SM_CreatedOn = Convert.ToDateTime(dr["CreatedOn"].ToString());
securityManagerObj.SM_CreatedUserID = Convert.ToInt64(dr["CreatedUserID"].ToString());
securityManagerObj.SM_CreatedRoleID = Convert.ToByte(dr["CreatedRoleID"].ToString());
if (!String.IsNullOrEmpty(dr["ModifiedOn"].ToString()))
{
securityManagerObj.SM_ModifiedOn = Convert.ToDateTime(dr["ModifiedOn"].ToString());
securityManagerObj.SM_ModifiedUserID = Convert.ToInt64(dr["ModifiedUserID"].ToString());
securityManagerObj.SM_ModifiedRoleID = Convert.ToByte(dr["ModifiedRoleID"].ToString());
}
securityManagersList.Add(securityManagerObj);
}
}
return securityManagersList;
}
public void NewSecurityManagerCommunity(ref SecurityManagersModel securitymanager)
{
CommunitiesModel community = new CommunitiesModel();
CommunitiesModel communityDetails = new CommunitiesModel();
community.CommunityID = securitymanager.CommunityID;
CommunitiesDAL communitiesDAL = new CommunitiesDAL();
communityDetails = communitiesDAL.CommunityDetails(community);
securitymanager.CommunityName = communityDetails.CommunityName;
securitymanager.CommunityAddress = communityDetails.CommunityAddress;
securitymanager.City = communityDetails.City;
securitymanager.Zip = communityDetails.Zip;
securitymanager.State = communityDetails.State;
securitymanager.Country = communityDetails.Country;
}
