//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);
}
