public int DeleteUser(UserProfileFormUI userProfileFormUI, int id) { int result = 0; result = userProfileFormDAL.DeleteUser(userProfileFormUI, id); return(result); }
public int AddUser(UserProfileFormUI userProfileFormUI, ref int newUserId) { int result = 0; result = userProfileFormDAL.AddUser(userProfileFormUI, ref newUserId); return(result); }
public int DeleteUser(UserProfileFormUI userProfileFormUI, int id) { int result = 0; try { using (SqlConnection SupportCon = new SqlConnection(connectionString)) { SupportCon.Open(); SqlCommand sqlCmd = new SqlCommand("prSystemNewUserDelete", SupportCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandTimeout = commandTimeout; sqlCmd.Parameters.Add("@IsDeleted", SqlDbType.Int); sqlCmd.Parameters["@IsDeleted"].Value = userProfileFormUI.IsDeleted; sqlCmd.Parameters.Add("@DeletedOnDate", SqlDbType.DateTime); sqlCmd.Parameters["@DeletedOnDate"].Value = userProfileFormUI.DeletedOn; sqlCmd.Parameters.Add("@SystemUser", SqlDbType.Int); sqlCmd.Parameters["@SystemUser"].Value = id; result = sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); SupportCon.Close(); } } catch (Exception exp) { logExcpUIobj.MethodName = "DeleteUser()"; logExcpUIobj.ResourceName = "UserProfileFormDAL.CS"; logExcpUIobj.RecordId = ""; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[UserProfileFormDAL : DeleteUser] An error occured in the processing of Record. Details : [" + exp.ToString() + "]"); } return(result); }
public int AddUser(UserProfileFormUI userProfileFormUI, ref int newUserId) { int result = 0; try { using (SqlConnection SupportCon = new SqlConnection(connectionString)) { SupportCon.Open(); SqlCommand sqlCmd = new SqlCommand("prSystemNewUserInsert", SupportCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandTimeout = commandTimeout; sqlCmd.Parameters.Add("@IsActive", SqlDbType.Int); sqlCmd.Parameters["@IsActive"].Value = userProfileFormUI.IsActive; sqlCmd.Parameters.Add("@IsLocked", SqlDbType.Int); sqlCmd.Parameters["@IsLocked"].Value = userProfileFormUI.IsLocked; sqlCmd.Parameters.Add("@IsDeleted", SqlDbType.Int); sqlCmd.Parameters["@IsDeleted"].Value = userProfileFormUI.IsDeleted; sqlCmd.Parameters.Add("@FailedLoginCount", SqlDbType.Int); sqlCmd.Parameters["@FailedLoginCount"].Value = userProfileFormUI.FailedLoginCount; sqlCmd.Parameters.Add("@UserId", SqlDbType.VarChar, 50); sqlCmd.Parameters["@UserId"].Value = userProfileFormUI.UserId; sqlCmd.Parameters.Add("@Password", SqlDbType.VarChar, 50); sqlCmd.Parameters["@Password"].Value = userProfileFormUI.Password; sqlCmd.Parameters.Add("@EmailAddress", SqlDbType.VarChar, 50); sqlCmd.Parameters["@EmailAddress"].Value = userProfileFormUI.Email; sqlCmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 50); sqlCmd.Parameters["@FirstName"].Value = userProfileFormUI.FirstName; sqlCmd.Parameters.Add("@LastName", SqlDbType.VarChar, 50); sqlCmd.Parameters["@LastName"].Value = userProfileFormUI.LastName; sqlCmd.Parameters.Add("@Phone", SqlDbType.VarChar, 20); sqlCmd.Parameters["@Phone"].Value = userProfileFormUI.Phone; sqlCmd.Parameters.Add("@OrgCode", SqlDbType.Int); sqlCmd.Parameters["@OrgCode"].Value = userProfileFormUI.OrganizationCode; sqlCmd.Parameters.Add("@Department", SqlDbType.Int); sqlCmd.Parameters["@Department"].Value = userProfileFormUI.Department; sqlCmd.Parameters.Add("@DateOfBirth", SqlDbType.VarChar, 10); sqlCmd.Parameters["@DateOfBirth"].Value = userProfileFormUI.DateofBirth; sqlCmd.Parameters.Add("@DateOfJoining", SqlDbType.DateTime); sqlCmd.Parameters["@DateOfJoining"].Value = userProfileFormUI.DateofJoining; sqlCmd.Parameters.Add("@PermanentAddress", SqlDbType.VarChar, 150); sqlCmd.Parameters["@PermanentAddress"].Value = userProfileFormUI.PermanentAddress; sqlCmd.Parameters.Add("@CorrespondanceAddress", SqlDbType.VarChar, 150); sqlCmd.Parameters["@CorrespondanceAddress"].Value = userProfileFormUI.CorrespondenceAddress; sqlCmd.Parameters.Add("@EducationQaulification", SqlDbType.VarChar, 50); sqlCmd.Parameters["@EducationQaulification"].Value = userProfileFormUI.EducationQualification; sqlCmd.Parameters.Add("@Designation", SqlDbType.Int); sqlCmd.Parameters["@Designation"].Value = userProfileFormUI.Designation; sqlCmd.Parameters.Add("@CreatedBySystemUser", SqlDbType.Int); sqlCmd.Parameters["@CreatedBySystemUser"].Value = userProfileFormUI.CreatedBySystemUser; sqlCmd.Parameters.Add("@CreatedOnDate", SqlDbType.DateTime); sqlCmd.Parameters["@CreatedOnDate"].Value = userProfileFormUI.CreatedOn; sqlCmd.Parameters.Add("@UpdatedOnDate", SqlDbType.DateTime); sqlCmd.Parameters["@UpdatedOnDate"].Value = userProfileFormUI.UpdatedOn; sqlCmd.Parameters.Add("@SystemUser", SqlDbType.Int); sqlCmd.Parameters["@SystemUser"].Direction = ParameterDirection.Output; result = sqlCmd.ExecuteNonQuery(); if (result == -1) { newUserId = Convert.ToInt32(sqlCmd.Parameters["@SystemUser"].Value.ToString()); } sqlCmd.Dispose(); SupportCon.Close(); } } catch (Exception exp) { logExcpUIobj.MethodName = "AddUser()"; logExcpUIobj.ResourceName = "UserProfileFormDAL.CS"; logExcpUIobj.RecordId = ""; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[UserProfileFormDAL : AddUser] An error occured in the processing of Record. Details : [" + exp.ToString() + "]"); } return(result); }