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