public int AddUser(UserLoginFormUI userLoginFormUI) { int result = 0; result = objUserLoginInsertDAL.CreateLogForUserLogin(userLoginFormUI); return(result); }
public DataTable GetUser(UserLoginFormUI userLoginFormUI) { DataTable dtb = new DataTable(); dtb = userLoginFormDAL.GetUser(userLoginFormUI); return(dtb); }
public int CreateLogForUserLogin(UserLoginFormUI userLoginFormUI) { int result = 0; try { using (SqlConnection SupportCon = new SqlConnection(connectionString)) { SupportCon.Open(); SqlCommand sqlCmd = new SqlCommand("prSystemUserLoginAuditInsert", SupportCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandTimeout = commandTimeout; sqlCmd.Parameters.Add("@SystemUser", SqlDbType.Int); sqlCmd.Parameters["@SystemUser"].Value = userLoginFormUI.SystemUser; sqlCmd.Parameters.Add("@UserId", SqlDbType.VarChar, 50); sqlCmd.Parameters["@UserId"].Value = userLoginFormUI.UserId; sqlCmd.Parameters.Add("@UserGuid", SqlDbType.NVarChar, 50); sqlCmd.Parameters["@UserGuid"].Value = userLoginFormUI.UserGuid; sqlCmd.Parameters.Add("@UserBrowser", SqlDbType.VarChar, 50); sqlCmd.Parameters["@UserBrowser"].Value = userLoginFormUI.UserBrowser; sqlCmd.Parameters.Add("@UserIP", SqlDbType.VarChar, 50); sqlCmd.Parameters["@UserIP"].Value = userLoginFormUI.UserIP; result = sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); SupportCon.Close(); } } catch (Exception exp) { logExcpUIobj.MethodName = "CreateLogForUserLogin()"; logExcpUIobj.ResourceName = "UserLoginInsertDAL.CS"; logExcpUIobj.RecordId = ""; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[UserLoginInsertDAL : CreateLogForUserLogin] An error occured in the processing of Record. Details : [" + exp.ToString() + "]"); } return(result); }
public DataTable GetUser(UserLoginFormUI userLoginFormUI) { DataSet ds = new DataSet(); DataTable dtbl = new DataTable(); try { using (SqlConnection SupportCon = new SqlConnection(connectionString)) { SqlCommand sqlCmd = new SqlCommand("PrSystemNewUserLogin", SupportCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandTimeout = commandTimeout; sqlCmd.Parameters.Add("@UserId", SqlDbType.VarChar, 50); sqlCmd.Parameters["@UserId"].Value = userLoginFormUI.UserId; sqlCmd.Parameters.Add("@Password", SqlDbType.VarChar, 50); sqlCmd.Parameters["@Password"].Value = userLoginFormUI.Password; using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd)) { adapter.Fill(ds); } } if (ds.Tables.Count > 0) { dtbl = ds.Tables[0]; } } catch (Exception exp) { logExcpUIobj.MethodName = "getUser()"; logExcpUIobj.ResourceName = "UserLoginFormDAL.CS"; logExcpUIobj.RecordId = ""; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[UserLoginFormDAL : getUser] An error occured in the processing of Record. Details : [" + exp.ToString() + "]"); } finally { ds.Dispose(); } return(dtbl); }