public DataSet IsDuplicateResolution(clsResolutionTime objclsResolutionTime) { try { DataSet dsIsDuplicateResolution; SqlParameter [] sqlparam = new SqlParameter[4]; sqlparam[0] = new SqlParameter("@subCategoryID", SqlDbType.Int); sqlparam[0].Value = objclsResolutionTime.SubCategoryID; sqlparam[1] = new SqlParameter("@problemSeverityid", SqlDbType.Int); sqlparam[1].Value = objclsResolutionTime.ProblemSeverityId; sqlparam[2] = new SqlParameter("@categoryid", SqlDbType.Int); sqlparam[2].Value = objclsResolutionTime.CategoryID; sqlparam[3] = new SqlParameter("@resolutionid", SqlDbType.Int); sqlparam[3].Value = objclsResolutionTime.ResolutionID; dsIsDuplicateResolution = SqlHelper.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "get_IsDuplicateResolution", sqlparam); return(dsIsDuplicateResolution); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLResolutionTime.cs", "IsDuplicateResolution", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public int addResolutionTime(clsResolutionTime objclsResolutionTime) { try { return(objclsDLResolutionTime.addResolutionTime(objclsResolutionTime)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLResolutionTime.cs", "addResolutionTime", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public DataSet IsDuplicateResolution(clsResolutionTime objclsResolutionTime) { try { return(objclsDLResolutionTime.IsDuplicateResolution(objclsResolutionTime)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLResolutionTime.cs", "IsDuplicateResolution", ex.StackTrace); throw new V2Exceptions(); } }
public DataSet getSubCategory(clsResolutionTime objclsResolutionTime) { try { return(objclsDLResolutionTime.getSubCategory(objclsResolutionTime)); //return objclsDLResolutionTime.getSubCategory(); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLResolutionTime.cs", "getSubCategory", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public int updateResolutionTime(clsResolutionTime objclsResolutionTime) { try { int rowsReturned = 0; SqlParameter [] sqlparam = new SqlParameter[6]; sqlparam[0] = new SqlParameter("@categoryid", SqlDbType.Int); sqlparam[0].Value = objclsResolutionTime.CategoryID; sqlparam[1] = new SqlParameter("@subCategoryid", SqlDbType.Int); sqlparam[1].Value = objclsResolutionTime.SubCategoryID; sqlparam[2] = new SqlParameter("@problemSeverityid", SqlDbType.Int); sqlparam [2].Value = objclsResolutionTime.ProblemSeverityId; sqlparam [3] = new SqlParameter("@resolutionForGreen", SqlDbType.Int); sqlparam[3].Value = objclsResolutionTime.ResolutionForGreen; sqlparam[4] = new SqlParameter("@resolutionForAmber", SqlDbType.Int); sqlparam[4].Value = objclsResolutionTime.ResolutionForAmber; sqlparam[5] = new SqlParameter("@resolutionid", SqlDbType.Int); sqlparam[5].Value = objclsResolutionTime.ResolutionID; rowsReturned = SqlHelper.ExecuteNonQuery(strConnectionString, CommandType.StoredProcedure, "sp_UpdateResolutionTime", sqlparam); return(rowsReturned); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLResolutionTime.cs", "updateResolutionTime", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public DataSet getSubCategory(clsResolutionTime objclsResolutionTime) { try { SqlParameter[] sqlparam = new SqlParameter [1]; sqlparam [0] = new SqlParameter("@Categoryid", SqlDbType.Int); sqlparam [0].Value = objclsResolutionTime.CategoryID; DataSet dsSubCategory = SqlHelper.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "sp_getSubCategoryMaster", sqlparam); return(dsSubCategory); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLResolutionTime.cs", "getSubCategory", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public int deleteResolutionTime(clsResolutionTime objclsResolutionTime) { try { int rowsReturned = 0; SqlParameter [] sqlparam = new SqlParameter[1]; sqlparam[0] = new SqlParameter("@resolutionID", SqlDbType.Int); sqlparam[0].Value = objclsResolutionTime.ResolutionID; rowsReturned = SqlHelper.ExecuteNonQuery(strConnectionString, CommandType.StoredProcedure, "sp_DeleteResoltuionTime", sqlparam); return(rowsReturned); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLResolutionTime.cs", "deleteResolutionTime", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }