//Get Data From Organization Table By OrgId public List<UserProfileModel> GetUsersByOrgId(credentialModel mymodel) { List<UserProfileModel> model = new List<UserProfileModel>(); try { cmd = new SqlCommand("GetUsersByOrgId_Sp", con); cmd.Parameters.Add("@OrgId", SqlDbType.BigInt).Value = mymodel.OrgId; cmd.Parameters.Add("@UserId", SqlDbType.BigInt).Value = mymodel.UserId; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } dr = cmd.ExecuteReader(); while (dr.Read()) { model.Add(new UserProfileModel { OrgId = Convert.ToInt32(dr["Org_OrgId"]), OrgName = dr["Org_Name"].ToString(), OrgStreet = dr["Org_Street"].ToString(), OrgCity = dr["Org_CityName"].ToString(), OrgState = dr["Org_StateName"].ToString(), RegisteredAs = dr["Org_RegisteredAs"].ToString(), Logo = dr["Org_Logo"].ToString(), Org_IsActive = Convert.ToBoolean(dr["Org_IsActive"]), Org_IsDelete = Convert.ToBoolean(dr["Org_IsDelete"]), UserId = Convert.ToInt32(dr["User_UserId"]), UserFirstName = dr["User_FirstName"].ToString(), UserLastName = dr["User_LastName"].ToString(), UserStreet = dr["User_Street"].ToString(), UserCityId = Convert.ToInt32(dr["User_CityId"]), UserStateId = Convert.ToInt32(dr["User_StateId"]), ProfilePhoto = dr["User_ProfilePhoto"].ToString(), RoleId = Convert.ToInt32(dr["User_RoleId"]), RoleName = dr["User_RoleName"].ToString(), UserName = dr["User_UserName"].ToString(), UserEmailId = dr["User_EmailId"].ToString(), UserMobileNo = dr["User_MobileNo"].ToString(), Password = PasswordSecurity.Decrypt(dr["User_Password"].ToString()),//Password Decryption CreatedBy = Convert.ToInt32(dr["User_CreatedBy"]), CreatedOn = Convert.ToDateTime(dr["User_CreatedOn"]), ModifiedBy = Convert.ToInt32(dr["User_ModifiedBy"]), ModifiedOn = Convert.ToDateTime(dr["User_ModifiedOn"]), IsActive = Convert.ToBoolean(dr["User_IsActive"]), IsDelete = Convert.ToBoolean(dr["User_IsDelete"]), }); } if (con.State == ConnectionState.Open) con.Close(); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } return model; }
public List<PermissionModel> GetPermissionsByUserRoleOrUserId(credentialModel mymodel) { List<PermissionModel> model = new List<PermissionModel>(); try { SqlCommand cmd = new SqlCommand("GetPermissionsByUserRoleOrUserId_Sp", con); cmd.Parameters.Add("@Org_Id", SqlDbType.BigInt).Value = mymodel.OrgId; cmd.Parameters.Add("@U_RoleId", SqlDbType.BigInt).Value = mymodel.RoleId; cmd.Parameters.Add("@UserId", SqlDbType.BigInt).Value = mymodel.UserId; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { model.Add(new PermissionModel { Org_Id = Convert.ToInt32(dr["Org_Id"]), U_RoleId = Convert.ToInt32(dr["U_RoleId"]), UserId = Convert.ToInt32(dr["UserId"]), ModuleId = Convert.ToInt32(dr["ModuleId"]), All = Convert.ToBoolean((dr["All"])), Add = Convert.ToBoolean((dr["Add"])), Edit = Convert.ToBoolean((dr["Edit"])), Delete = Convert.ToBoolean((dr["Delete"])), View = Convert.ToBoolean((dr["View"])), ReActivate = Convert.ToBoolean((dr["ReActivate"])), Print = Convert.ToBoolean((dr["Print"])), Finalize = Convert.ToBoolean((dr["Finalize"])), ModifiedBy = Convert.ToInt32(dr["ModifiedBy"]), ModifiedOn = Convert.ToDateTime(dr["Modifiedon"]) }); } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } return model; }
public List<UserInRole> GetUsersByOrgIdAndRoleId(credentialModel model) { List<UserInRole> UserInRole = new List<UserInRole>(); try { cmd = new SqlCommand("GetUsersByOrgIdAndRoleId_Sp", con); cmd.Parameters.Add("@OrgId", SqlDbType.BigInt).Value = model.OrgId; cmd.Parameters.Add("@RoleId", SqlDbType.BigInt).Value = model.RoleId; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } dr = cmd.ExecuteReader(); while (dr.Read()) { UserInRole.Add(new UserInRole { UserId = Convert.ToInt32(dr["UserId"]), OrgId = Convert.ToInt32(dr["OrgId"]), FirstName = dr["FirstName"].ToString(), LastName = dr["LastName"].ToString(), EmailId = dr["EmailId"].ToString() }); } if (con.State == ConnectionState.Open) con.Close(); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } obj.Response = ret; return UserInRole; }
public ResponseModel SendRequestToReactiveUser(credentialModel model) { try { MailHelper obj = new MailHelper(); obj.SendEmail("","To Reactivate User",""); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } obj.Response = ret; return obj; }
public ResponseModel ReactiveUser(credentialModel model) { try { cmd = new SqlCommand("ReactiveUser_Sp", con); cmd.Parameters.Add("@OrgId", SqlDbType.BigInt).Value = model.OrgId; cmd.Parameters.Add("@EmailId", SqlDbType.VarChar).Value = model.EmailId; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } dr = cmd.ExecuteReader(); if (con.State == ConnectionState.Open) con.Close(); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } obj.Response = ret; return obj; }
public List<UserProfileModel> GetUsersByOrgId(credentialModel model) { return obj.GetUsersByOrgId(model); }
public ResponseModel InActiveUser(credentialModel model) { UserInfo_Sp_Class obj = new UserInfo_Sp_Class(); return obj.InActiveUser(model); }
public PermissionModel GetModuleAccessPermissions(credentialModel mymodel) { PermissionModel model = new PermissionModel(); try { SqlCommand cmd = new SqlCommand("GetModuleAccessPermissions_Sp", con); cmd.Parameters.Add("@Org_Id", SqlDbType.BigInt).Value = mymodel.OrgId; cmd.Parameters.Add("@U_RoleId", SqlDbType.BigInt).Value = mymodel.RoleId; cmd.Parameters.Add("@UserID", SqlDbType.BigInt).Value = mymodel.UserId; cmd.Parameters.Add("@ModuleId", SqlDbType.BigInt).Value = mymodel.ModuleId; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { model.All = Convert.ToBoolean((dr["All"])); model.Add = Convert.ToBoolean((dr["Add"])); model.Edit = Convert.ToBoolean((dr["Edit"])); model.Delete = Convert.ToBoolean((dr["Delete"])); model.View = Convert.ToBoolean((dr["View"])); model.ReActivate = Convert.ToBoolean((dr["ReActivate"])); model.Print = Convert.ToBoolean((dr["Print"])); model.Finalize = Convert.ToBoolean((dr["Finalize"])); } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } return model; }
public ResponseModel ActiveUserInfo(credentialModel model) { try { cmd = new SqlCommand("ActiveUserInfo_Sp", con); cmd.Parameters.Add("@UserId", SqlDbType.BigInt).Value = model.UserId; cmd.Parameters.Add("@ModifiedBy", SqlDbType.BigInt).Value = model.UserId; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } ret = cmd.ExecuteNonQuery(); if (con.State == ConnectionState.Open) con.Close(); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } obj.Response = ret; return obj; }
public List<PermissionModel> GetPermissionsByUserRoleOrUserId(credentialModel model) { UserPermissions_Sp_Class obj = new UserPermissions_Sp_Class(); return obj.GetPermissionsByUserRoleOrUserId(model); }
//Unique Email Address Check in UserInfo Table public ResponseModel CheckUniqueEmailAddress(credentialModel model) { try { cmd = new SqlCommand("CheckUniqueEmailAddress_Sp", con); cmd.Parameters.Add("@EmailId", SqlDbType.NVarChar, 150).Value = model.EmailId; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } dr = cmd.ExecuteReader(); if (dr.Read()) { ret = 0; if (Convert.ToInt32(dr["OrgId"]) == model.OrgId && Convert.ToBoolean(dr["IsActive"]) == true) { obj.Message = "User with this Email Address already exists in your Organization."; } else if (Convert.ToInt32(dr["OrgId"]) == model.OrgId && Convert.ToBoolean(dr["IsActive"]) == false) { obj.Message = "User with this Email Address already exists.\n Do you want to reactive that user?"; } else if (Convert.ToInt32(dr["OrgId"]) != model.OrgId && Convert.ToBoolean(dr["IsActive"]) == true) { obj.Message = "User with this Email Address already exists in other organization. \n Please select different Email."; } else if (Convert.ToInt32(dr["OrgId"]) != model.OrgId && Convert.ToBoolean(dr["IsActive"]) == false) { obj.Message = "User with this Email Address already exists in other organization. \n To reactive that user,Please send request to SuperAdmin."; } } else { ret = 1; } if (con.State == ConnectionState.Open) con.Close(); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } obj.Response = ret; return obj; }
public ResponseModel ActiveUserInfo(credentialModel model) { return obj.ActiveUserInfo(model); }
public ResponseModel ActiveOrganization(credentialModel model) { return obj.ActiveOrganization(model); }
public List<RoleModel> GetRoleByOrgId(credentialModel model) { return obj.GetRoleByOrgId(model); }
public PermissionModel DashBoardAccessibility(credentialModel model) { UserPermissions_Sp_Class obj = new UserPermissions_Sp_Class(); return obj.DashBoardAccessibility(model); }
public List<UserInRole> GetUsersByOrgIdAndRoleId(credentialModel model) { UserInfo_Sp_Class obj = new UserInfo_Sp_Class(); return obj.GetUsersByOrgIdAndRoleId(model); }
//User Get By UserName/EmailId and Paswword public List<UserProfileModel> GetUserInfoByUserNamePassword(credentialModel mymodel) { List<UserProfileModel> model = new List<UserProfileModel>(); int intValue = 0; try { cmd = new SqlCommand("GetUserInfoByUserNamePassword_Sp", con); cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 200).Value = mymodel.UserName; cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 150).Value = PasswordSecurity.Encrypt(mymodel.Password);//Password Encryption cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) con.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { model.Add(new UserProfileModel { UserId = Convert.ToInt32(dr["User_UserId"]), OrgId = Convert.ToInt32(dr["User_OrgId"]), UserFirstName = dr["User_FirstName"].ToString(), UserLastName = dr["User_LastName"].ToString(), UserStreet = dr["User_Street"].ToString(), UserStateId = Convert.ToInt32(dr["User_StateId"]), UserState = dr["User_StateName"].ToString(), UserCityId = Convert.ToInt32(dr["User_CityId"]), UserCity = dr["User_CityName"].ToString(), ProfilePhoto = dr["User_ProfilePhoto"].ToString(), RoleId = Convert.ToInt32(dr["User_RoleId"]), RoleName = dr["User_RoleName"].ToString(), UserName = dr["User_UserName"].ToString(), UserEmailId = dr["User_EmailId"].ToString(), UserMobileNo = dr["User_MobileNo"].ToString(), Password = PasswordSecurity.Decrypt(dr["User_Password"].ToString()),//Password Decryption CreatedBy = Convert.ToInt32(dr["User_CreatedBy"]), CreatedOn = Convert.ToDateTime(dr["User_CreatedOn"]), ModifiedBy = Convert.ToInt32(dr["User_ModifiedBy"]), ModifiedOn = Convert.ToDateTime(dr["User_ModifiedOn"]), IsActive = Convert.ToBoolean(dr["User_IsActive"]), IsDelete = Convert.ToBoolean(dr["User_IsDelete"]), OrgName = dr["Org_Name"].ToString(), OrgStreet = dr["Org_Street"].ToString(), OrgCityId = Convert.ToInt32(dr["Org_CityId"]), OrgCity = dr["Org_CityName"].ToString(), OrgStateId = Convert.ToInt32(dr["Org_StateId"]), OrgState = dr["Org_StateName"].ToString(), RegisteredAs = dr["Org_RegisteredAs"].ToString(), Logo = dr["Org_Logo"].ToString(), OrgCreatedBy = Convert.ToInt32(dr["Org_CreatedBy"]), OrgCreatedOn = Convert.ToDateTime(dr["Org_CreatedOn"]), OrgModifiedBy = Convert.ToInt32(dr["Org_ModifiedBy"]), OrgModifiedOn = Convert.ToDateTime(dr["Org_ModifiedOn"]), Org_IsActive = Convert.ToBoolean(dr["Org_IsActive"]), Org_IsDelete = Convert.ToBoolean(dr["Org_IsDelete"]), }); intValue = Convert.ToInt32(dr["User_UserId"]); } Organization_Sp_Class objOrg = new Organization_Sp_Class(); LoginDetailModel loginmodel = new LoginDetailModel(); loginmodel.UserId = intValue; objOrg.InsertLoginDetail(loginmodel); if (con.State == ConnectionState.Open) con.Close(); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } return model; }
public ResponseModel DeleteOrganizaton(credentialModel model) { return obj.DeleteOrganizaton(model); }
public ResponseModel SendRequestToReactiveUser(credentialModel model) { UserInfo_Sp_Class obj = new UserInfo_Sp_Class(); return obj.SendRequestToReactiveUser(model); }
//Unique UserName Check in UserInfo Table public ResponseModel CheckUniqueUserName(credentialModel model) { try { cmd = new SqlCommand("CheckUniqueUserName_Sp", con); cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 200).Value = model.UserName; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) con.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { if (Convert.ToInt32(dr["IsUnique"]) >= 1) { ret = 0; } else { ret = 1; } } if (con.State == ConnectionState.Open) con.Close(); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } obj.Response = ret; return obj; }
public ResponseModel DeleteUserInfo(credentialModel model) { return obj.DeleteUserInfo(model); }
public List<RoleModel> GetRoleByOrgId(credentialModel mymodel) { List<RoleModel> model = new List<RoleModel>(); try { SqlCommand cmd = new SqlCommand("GetRoleByOrgId_Sp", con); cmd.Parameters.Add("@OrgId", SqlDbType.BigInt).Value = mymodel.Id; cmd.Parameters.Add("@RoleName", SqlDbType.VarChar).Value = mymodel.RoleName; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { model.Add(new RoleModel { RoleId = Convert.ToInt32(dr["RoleId"]), RoleName = dr["RoleName"].ToString(), CreatedByOrg_Id = Convert.ToInt64(dr["OrgId"]) }); } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } return model; }
public ResponseModel CheckUniqueEmailAddress(credentialModel model) { return obj.CheckUniqueEmailAddress(model); }
public PermissionModel DashBoardAccessibility(credentialModel model) { PermissionModel Modules = new PermissionModel(); SqlCommand cmd = new SqlCommand("DashboardAccessibility_Sp", con); cmd.CommandType = CommandType.StoredProcedure; try { cmd.Parameters.Add("@U_RoleId", SqlDbType.BigInt).Value = model.RoleId; cmd.Parameters.Add("@Org_Id", SqlDbType.BigInt).Value = model.OrgId; cmd.Parameters.Add("@UserId", SqlDbType.BigInt).Value = model.UserId; if (con.State == ConnectionState.Closed) { con.Open(); } dr = cmd.ExecuteReader(); while (dr.Read()) { if (dr["Module_Name"].ToString() == "User Management" && (Convert.ToBoolean(dr["All"]) == true || Convert.ToBoolean(dr["View"]) == true)) Modules.UserManagement = true; if (dr["Module_Name"].ToString() == "Property Level" && (Convert.ToBoolean(dr["All"]) == true || Convert.ToBoolean(dr["View"]) == true)) Modules.PropertyLevel = true; if (dr["Module_Name"].ToString() == "Company Level" && (Convert.ToBoolean(dr["All"]) == true || Convert.ToBoolean(dr["View"]) == true)) Modules.CompanyLevel = true; if (dr["Module_Name"].ToString() == "Tally Marketing" && (Convert.ToBoolean(dr["All"]) == true || Convert.ToBoolean(dr["View"]) == true)) Modules.TallyMarketing = true; if (dr["Module_Name"].ToString() == "Capital Project" && (Convert.ToBoolean(dr["All"]) == true || Convert.ToBoolean(dr["View"]) == true)) Modules.CapitalProject = true; if (dr["Module_Name"].ToString() == "Work Order" && (Convert.ToBoolean(dr["All"]) == true || Convert.ToBoolean(dr["View"]) == true)) Modules.WorkOrder = true; } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } return Modules; }
public ResponseModel CheckUniqueUserName(credentialModel model) { return obj.CheckUniqueUserName(model); }
public List<UserProfileModel> GetUserInfoByUserNamePassword(credentialModel model) { return obj.GetUserInfoByUserNamePassword(model); }
public PermissionModel GetModuleAccessPermissions(credentialModel model) { UserPermissions_Sp_Class obj = new UserPermissions_Sp_Class(); return obj.GetModuleAccessPermissions(model); }