public int UpdateProblemPriority(clsProblemPriority objProblemPriority) { try { return(objDLProblemPriority.UpdateProblemPriority(objProblemPriority)); // try // { // if (objDLProblemPriority.UpdateProblemPriority(objProblemPriority)) // { // return true; // } // else // { // return false; // } // } // catch (Exception ex) // { // throw ex; // } } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLProblemPriority.cs", "UpdateProblemPriority", ex.StackTrace); throw new V2Exceptions(); } }
public int CheckBeforeDeletingProblemPriority(clsProblemPriority objProblemPriority) { SqlParameter[] objParam = new SqlParameter[1]; objParam[0] = new SqlParameter("ProblemPriorityID", SqlDbType.Int); objParam[0].Value = objProblemPriority.ProblemPriorityID; int recaffected1; try { recaffected1 = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "sp_CheckBeforeDeletingProblemPriority", objParam); return(recaffected1); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLProblemPriority.cs", "CheckBeforeDeletingProblemPriority", ex.StackTrace); throw new V2Exceptions(); } }
public bool AddNewProblemPriority(clsProblemPriority objProblemPriority) { try { if (objDLProblemPriority.AddNewProblemPriority(objProblemPriority)) { return(true); } else { return(false); } } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLProblemPriority.cs", "AddNewProblemPriority", ex.StackTrace); throw new V2Exceptions(); } }
public DataSet IsDuplicateProblemPriority(clsProblemPriority objProblemPriority) { DataSet dsDuplicateProblemPriority; SqlParameter[] objParam = new SqlParameter[2]; objParam[0] = new SqlParameter("@ProblemPriorityID", SqlDbType.Int); objParam[0].Value = objProblemPriority.ProblemPriorityID; objParam[1] = new SqlParameter("@ProblemPriority", SqlDbType.VarChar, 100); objParam[1].Value = objProblemPriority.ProblemPriorityName; try { dsDuplicateProblemPriority = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_IsDuplicateProblemPriority", objParam); return(dsDuplicateProblemPriority); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLProblemPriority.cs", "IsDuplicateProblemPriority", ex.StackTrace); throw new V2Exceptions(); } }
public int CheckBeforeDeletingProblemPriority(clsProblemPriority objProblemPriority) { try { return(objDLProblemPriority.CheckBeforeDeletingProblemPriority(objProblemPriority)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLProblemPriority.cs", "CheckBeforeDeletingProblemPriority", ex.StackTrace); throw new V2Exceptions(); } }
public DataSet IsDuplicateProblemPriority(clsProblemPriority objProblemPriority) { try { return(objDLProblemPriority.IsDuplicateProblemPriority(objProblemPriority)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLProblemPriority.cs", "IsDuplicateProblemPriority", ex.StackTrace); throw new V2Exceptions(); } }
public bool AddNewProblemPriority(clsProblemPriority objProblemPriority) { DataSet dsProblemPriorityList; dsProblemPriorityList = new DataSet(); SqlParameter[] objParam = new SqlParameter[4]; objParam[0] = new SqlParameter("@ProblemPriority", SqlDbType.VarChar, 100); objParam[0].Value = objProblemPriority.ProblemPriorityName; objParam[1] = new SqlParameter("@isActive", SqlDbType.Bit, 1); objParam[1].Value = objProblemPriority.isActive; objParam[2] = new SqlParameter("@GreenResolutionHours", SqlDbType.Int); objParam[2].Value = objProblemPriority.GreenResolutionHours; objParam[3] = new SqlParameter("@AmberResolutionHours", SqlDbType.Int); objParam[3].Value = objProblemPriority.AmberResolutionHours; int recaffected1; try { recaffected1 = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "sp_AddNewProblemPriority", objParam); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLProblemPriority.cs", "AddNewProblemPriority", ex.StackTrace); throw new V2Exceptions(); } return(true); }
public int UpdateProblemPriority(clsProblemPriority objProblemPriority) { SqlParameter[] objParam = new SqlParameter[5]; objParam[0] = new SqlParameter("@ProblemPriorityID", SqlDbType.Int); objParam[0].Value = objProblemPriority.ProblemPriorityID; objParam[1] = new SqlParameter("@ProblemPriority", SqlDbType.VarChar, 100); objParam[1].Value = objProblemPriority.ProblemPriorityName; objParam[2] = new SqlParameter("@isActive", SqlDbType.Bit, 1); objParam[2].Value = objProblemPriority.isActive; objParam[3] = new SqlParameter("@GreenResolutionHours", SqlDbType.Int); objParam[3].Value = objProblemPriority.GreenResolutionHours; objParam[4] = new SqlParameter("@AmberResolutionHours", SqlDbType.Int); objParam[4].Value = objProblemPriority.AmberResolutionHours; int recaffected1; try { recaffected1 = Convert.ToInt32(SqlHelper.ExecuteScalar(sqlConn, CommandType.StoredProcedure, "sp_UpdateProblemPriority", objParam)); return(recaffected1); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLProblemPriority.cs", "UpdateProblemPriority", ex.StackTrace); throw new V2Exceptions(); } }