public int UpdateProblemSeverity(Model.clsProblemSeverity objProblemSeverity) { SqlParameter[] objParam = new SqlParameter[3]; objParam[0] = new SqlParameter("@ProblemSeverityID", SqlDbType.Int); objParam[0].Value = objProblemSeverity.ProblemSeverityID; objParam[1] = new SqlParameter("@ProblemSeverity", SqlDbType.VarChar, 100); objParam[1].Value = objProblemSeverity.ProblemSeverityName; objParam[2] = new SqlParameter("@isActive", SqlDbType.Bit, 1); objParam[2].Value = objProblemSeverity.isActive; int recaffected1; try { recaffected1 = Convert.ToInt32(SqlHelper.ExecuteScalar(sqlConn, CommandType.StoredProcedure, "sp_UpdateProblemSeverity", objParam)); return(recaffected1); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLProblemSeverity.cs", "UpdateProblemSeverity", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public void dgProblemSeverity_Delete(object Sender, DataGridCommandEventArgs e) { try { lblSuccessMsgs.Text = ""; pnlAddEditProblemSeverity.Visible = false; objProblemSeverity = new Model.clsProblemSeverity(); objBLProblemSeverity = new BusinessLayer.clsBLProblemSeverity(); int intProblemSeverityID = Convert.ToInt32((dgProblemSeverity.DataKeys[e.Item.ItemIndex]).ToString()); objProblemSeverity.ProblemSeverityID = intProblemSeverityID; recordcount = objBLProblemSeverity.DeleteProblemSeverity(objProblemSeverity); if (recordcount <= 0) { Page.RegisterStartupScript("key", "<script>alert('Cannot delete this Problem Severity as issues found');</script>"); } else { dgProblemSeverity.EditItemIndex = -1; } GetProblemSeverityList(); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "ProblemSeverityMaster.aspx", "dgProblemSeverity_Delete", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public bool AddNewProblemSeverity(Model.clsProblemSeverity objProblemSeverity) { DataSet dsProblemSeverityList; dsProblemSeverityList = new DataSet(); SqlParameter[] objParam = new SqlParameter[2]; objParam[0] = new SqlParameter("@ProblemSeverity", SqlDbType.VarChar, 100); objParam[0].Value = objProblemSeverity.ProblemSeverityName; objParam[1] = new SqlParameter("@isActive", SqlDbType.Bit, 1); objParam[1].Value = objProblemSeverity.isActive; int recaffected1; try { recaffected1 = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "sp_AddNewProblemSeverity", objParam); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLProblemSeverity.cs", "AddNewProblemSeverity", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } return(true); }
public DataSet IsDuplicateProblemSeverity(Model.clsProblemSeverity objProblemSeverity) { DataSet dsDuplicateProblemSeverity; SqlParameter[] objParam = new SqlParameter[2]; objParam[0] = new SqlParameter("@ProblemSeverityID", SqlDbType.Int); objParam[0].Value = objProblemSeverity.ProblemSeverityID; objParam[1] = new SqlParameter("@ProblemSeverity", SqlDbType.VarChar, 100); objParam[1].Value = objProblemSeverity.ProblemSeverityName; try { dsDuplicateProblemSeverity = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_IsDuplicateProblemSeverity", objParam); return(dsDuplicateProblemSeverity); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLProblemSeverity.cs", "IsDuplicateProblemSeverity", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public int DeleteProblemSeverity(Model.clsProblemSeverity objProblemSeverity) { SqlParameter[] objParam = new SqlParameter[1]; objParam[0] = new SqlParameter("@ProblemSeverityID", SqlDbType.Int); objParam[0].Value = objProblemSeverity.ProblemSeverityID; int recaffected1; try { recaffected1 = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "sp_DeleteProblemSeverity", objParam); return(recaffected1); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLProblemSeverity.cs", "DeleteProblemSeverity", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public bool AddNewProblemSeverity(Model.clsProblemSeverity objProblemSeverity) { try { if (objDLProblemSeverity.AddNewProblemSeverity(objProblemSeverity)) { return(true); } else { return(false); } } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLProblemSeverity.cs", "AddNewProblemSeverity", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
protected void btnSubmit_Click(object sender, System.EventArgs e) { try { objProblemSeverity = new Model.clsProblemSeverity(); objBLProblemSeverity = new BusinessLayer.clsBLProblemSeverity(); DataSet dsDuplicateProblemSeverity = new DataSet(); objProblemSeverity.ProblemSeverityName = Server.HtmlEncode(Convert.ToString(txtProblemSeverity.Text.Trim())); objProblemSeverity.isActive = Convert.ToInt32(ddlisActive.SelectedItem.Value); dsDuplicateProblemSeverity = objBLProblemSeverity.IsDuplicateProblemSeverity(objProblemSeverity); if (dsDuplicateProblemSeverity.Tables[0].Rows.Count > 0) { lblDuplicateProblemSeverity.Text = "Duplicate problem severity"; GetProblemSeverityList(); } else { lblDuplicateProblemSeverity.Text = ""; recordfound = objBLProblemSeverity.AddNewProblemSeverity(objProblemSeverity); if (recordfound) { lblMsg.Visible = true; lblMsg.CssClass = "success"; lblMsg.Text = "Record inserted successfully"; pnlAddEditProblemSeverity.Visible = false; GetProblemSeverityList(); } else { lblMsg.Visible = true; lblMsg.Text = "Error while inserting record"; GetProblemSeverityList(); } } } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "ProblemSeverityMaster.aspx", "btnSubmit_Click", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public int UpdateProblemSeverity(Model.clsProblemSeverity objProblemSeverity) { try { return(objDLProblemSeverity.UpdateProblemSeverity(objProblemSeverity)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLProblemSeverity.cs", "UpdateProblemSeverity", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public void dgProblemSeverity_Update(object Sender, DataGridCommandEventArgs e) { try { objProblemSeverity = new Model.clsProblemSeverity(); objBLProblemSeverity = new BusinessLayer.clsBLProblemSeverity(); DataSet dsDuplicateProblemSeverity = new DataSet(); int intProblemSeverityID = Convert.ToInt32((dgProblemSeverity.DataKeys[e.Item.ItemIndex]).ToString()); TextBox strNewProblemSeverity = (TextBox)e.Item.FindControl("txtNewProblemSeverity"); int strIsActive = ((DropDownList)e.Item.FindControl("ddlisActive1")).SelectedIndex; objProblemSeverity.ProblemSeverityID = intProblemSeverityID; objProblemSeverity.ProblemSeverityName = Server.HtmlEncode(Convert.ToString(strNewProblemSeverity.Text.Trim())); objProblemSeverity.isActive = strIsActive; if (objProblemSeverity.ProblemSeverityName == "") { lblMsg.Visible = true; lblMsg.Text = "Please enter a problem severity"; GetProblemSeverityList(); } else { dsDuplicateProblemSeverity = objBLProblemSeverity.IsDuplicateProblemSeverity(objProblemSeverity); if (dsDuplicateProblemSeverity.Tables[0].Rows.Count > 0) { lblMsg.Visible = true; lblMsg.Text = "Duplicate problem severity"; GetProblemSeverityList(); } else { recordcount = objBLProblemSeverity.UpdateProblemSeverity(objProblemSeverity); if (recordcount > 0) { if (strIsActive == 0) { Page.RegisterStartupScript("key", "<script>alert('Cannot edit this Problem Severity Status as issues found');</script>"); } } else { dgProblemSeverity.EditItemIndex = -1; GetProblemSeverityList(); } } dgProblemSeverity.EditItemIndex = -1; GetProblemSeverityList(); lblSuccessMsgs.Visible = true; lblSuccessMsgs.Text = "Details updated successfully"; } } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "ProblemSeverityMaster.aspx", "dgProblemSeverity_Update", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }