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