public DataSet IsDuplicateProblemPriority(Model.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(ex.ToString(), ex);
}
}
public int CheckBeforeDeletingProblemPriority(Model.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(ex.ToString(), ex);
}
}
public int UpdateProblemPriority(Model.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(ex.ToString(), ex);
}
}
public bool AddNewProblemPriority(Model.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(ex.ToString(), ex);
}
}
public void dgProblemPriority_Delete(object Sender, DataGridCommandEventArgs e)
{
try
{
objProblemPriority = new Model.clsProblemPriority();
objBLProblemPriority = new BusinessLayer.clsBLProblemPriority();
int intProblemPriorityID = Convert.ToInt32((dgProblemPriority.DataKeys[e.Item.ItemIndex]).ToString());
objProblemPriority.ProblemPriorityID = intProblemPriorityID;
recordcount = objBLProblemPriority.DeleteProblemPriority(objProblemPriority);
if (recordcount <= 0)
{
Page.RegisterStartupScript("key", "<script>alert('Cannot delete this Problem Priority as issues found.');</script>");
}
else
{
dgProblemPriority.EditItemIndex = -1;
}
GetProblemPriorityList();
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ProblemPriorityMaster.aspx", "dgProblemPriority_Delete", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
protected void btnSubmit_Click(object sender, System.EventArgs e)
{
objProblemPriority = new Model.clsProblemPriority();
objBLProblemPriority = new BusinessLayer.clsBLProblemPriority();
objProblemPriority.ProblemPriorityName = Server.HtmlEncode(Convert.ToString(txtProblemPriority.Text.Trim()));
objProblemPriority.isActive = Convert.ToInt32(ddlisActive.SelectedItem.Value);
objProblemPriority.GreenResolutionHours = Convert.ToInt32(txtGreenResolutionHours.Text.Trim());
objProblemPriority.AmberResolutionHours = Convert.ToInt32(txtAmberResolutionHours.Text.Trim());
// DataSet dsDuplicateProblemPriority = new DataSet();
try
{
// if(txtProblemPriority.Text.Trim()=="")
// {
// lblDuplicateProblemPriority.Visible=true;
// lblDuplicateProblemPriority.Text="Please enter a problem priority";
// GetProblemPriorityList();
// }
// else
// {
// int dsDuplicateProblemPriority;
dsDuplicateProblemPriority = objBLProblemPriority.IsDuplicateProblemPriority(objProblemPriority);
if (dsDuplicateProblemPriority.Tables[0].Rows.Count > 0)
{
// lblDuplicateProblemPriority.Visible=true;
lblDuplicateProblemPriority.Text = "Duplicate problem priority";
GetProblemPriorityList();
}
else
{
lblDuplicateProblemPriority.Text = "";
pnlAddEditProblemPriority.Visible = false;
recordfound = objBLProblemPriority.AddNewProblemPriority(objProblemPriority);
if (recordfound)
{
lblMsg.Visible = true;
lblMsg.CssClass = "success";
lblMsg.Text = "Record inserted successfully";
GetProblemPriorityList();
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "Error while inserting record";
GetProblemPriorityList();
}
}
// }
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ProblemPriorityMaster.aspx", "btnSubmit_Click", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public int CheckBeforeDeletingProblemPriority(Model.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(ex.ToString(), ex);
}
}
public bool AddNewProblemPriority(Model.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(ex.ToString(), ex);
}
return(true);
}
public int UpdateProblemPriority(Model.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(ex.ToString(), ex);
}
}
public void dgProblemPriority_Update(object Sender, DataGridCommandEventArgs e)
{
try
{
objProblemPriority = new Model.clsProblemPriority();
objBLProblemPriority = new BusinessLayer.clsBLProblemPriority();
int intProblemPriorityID = Convert.ToInt32((dgProblemPriority.DataKeys[e.Item.ItemIndex]).ToString());
TextBox strNewProblemPriority = (TextBox)e.Item.FindControl("txtNewProblemPriority");
TextBox strNewGreenResolutionHours = (TextBox)e.Item.FindControl("txtNewGreenResolutionHours");
TextBox strNewAmberResolutionHours = (TextBox)e.Item.FindControl("txtNewAmberResolutionHours");
int strIsActive = ((DropDownList)e.Item.FindControl("ddlisActive1")).SelectedIndex;
objProblemPriority.ProblemPriorityID = intProblemPriorityID;
objProblemPriority.isActive = strIsActive;
if (strNewProblemPriority.Text.Trim() == "")
{
lblMsg.Text = "Please enter a problem priority";
GetProblemPriorityList();
}
else if (strNewProblemPriority.Text.Trim() != "")
{
objProblemPriority.ProblemPriorityName = Server.HtmlEncode(Convert.ToString(strNewProblemPriority.Text.Trim().Replace("&", "&")));
dsDuplicateProblemPriority = objBLProblemPriority.IsDuplicateProblemPriority(objProblemPriority);
if (dsDuplicateProblemPriority.Tables[0].Rows.Count > 0)
{
lblMsg.Text = "Duplicate problem priority";
GetProblemPriorityList();
}
else
{
objProblemPriority.ProblemPriorityName = Server.HtmlEncode(Convert.ToString(strNewProblemPriority.Text.Trim()));
if (strNewGreenResolutionHours.Text.Trim() == "")
{
lblMsg.Text = "Please enter an integer value for Green Resolution Hours";
GetProblemPriorityList();
}
else if (strNewGreenResolutionHours.Text.Trim() != "")
{
string strNewGreenResolution = strNewGreenResolutionHours.Text.Trim();
if (strNewGreenResolution.StartsWith("0") || strNewGreenResolution.StartsWith("1") ||
strNewGreenResolution.StartsWith("2") || strNewGreenResolution.StartsWith("3") ||
strNewGreenResolution.StartsWith("4") || strNewGreenResolution.StartsWith("5") ||
strNewGreenResolution.StartsWith("6") || strNewGreenResolution.StartsWith("7") ||
strNewGreenResolution.StartsWith("8") || strNewGreenResolution.StartsWith("9"))
{
objProblemPriority.GreenResolutionHours = Convert.ToInt32(strNewGreenResolution);
if (strNewAmberResolutionHours.Text.Trim() == "")
{
lblMsg.Text = "Please enter an integer value for Amber Resolution Hours";
GetProblemPriorityList();
}
else if (strNewAmberResolutionHours.Text.Trim() != "")
{
string strNewAmberResolution = strNewAmberResolutionHours.Text.Trim();
if (strNewAmberResolution.StartsWith("0") || strNewAmberResolution.StartsWith("1") ||
strNewAmberResolution.StartsWith("2") || strNewAmberResolution.StartsWith("3") ||
strNewAmberResolution.StartsWith("4") || strNewAmberResolution.StartsWith("5") ||
strNewAmberResolution.StartsWith("6") || strNewAmberResolution.StartsWith("7") ||
strNewAmberResolution.StartsWith("8") || strNewAmberResolution.StartsWith("9"))
{
objProblemPriority.AmberResolutionHours = Convert.ToInt32(strNewAmberResolution);
recordcount = objBLProblemPriority.UpdateProblemPriority(objProblemPriority);
if (recordcount > 0)
{
if (strIsActive == 0)
{
Page.RegisterStartupScript("key", "<script>alert('Cannot edit this Problem Priority as issues found.');</script>");
}
else
{
dgProblemPriority.EditItemIndex = -1;
lblMsg.Text = "";
GetProblemPriorityList();
}
}
else
{
dgProblemPriority.EditItemIndex = -1;
lblMsg.Text = "";
GetProblemPriorityList();
}
}
else
{
lblMsg.Text = "Please enter an integer value for Amber Resolution Hours";
GetProblemPriorityList();
}
}
/*dgProblemPriority.EditItemIndex = -1;
* lblMsg.Text="";
* GetProblemPriorityList();*/
}
else
{
lblMsg.Text = "Please enter an integer value for Green Resolution Hours";
GetProblemPriorityList();
}
}
}
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ProblemPriorityMaster.aspx", "dgProblemPriority_Update", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
