protected void ddlParentWorkCateg_SelectedIndexChanged(object sender, EventArgs e)
{
JRA_Lib lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = UDFLib.ConvertToInteger(ddlParentWorkCateg.SelectedValue);
lObjWC.Mode = 1;
DataTable dtChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
DataView dv = dtChilds.DefaultView;
DataTable dtChildsCloned = dtChilds.Clone();
dtChildsCloned.Columns["Work_Categ_Value"].DataType = typeof(float);
foreach (DataRow row in dtChilds.Rows)
{
dtChildsCloned.ImportRow(row);
}
dv = dtChildsCloned.DefaultView;
dv.Sort = "Work_Categ_Value";
dtChilds = dv.ToTable();
ddlChildWorkCateg.DataSource = dtChilds;
ddlChildWorkCateg.DataTextField = "Work_Category_Display";
ddlChildWorkCateg.DataValueField = "Work_Categ_ID";
ddlChildWorkCateg.DataBind();
ddlChildWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
}
protected void ClearFilter()
{
JRA_Lib lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = null;
lObjWC.Mode = 3;
DataTable dtAllChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
DataTable dtAllChildsCloned = dtAllChilds.Clone();
dtAllChildsCloned.Columns["Work_Categ_Value"].DataType = typeof(float);
foreach (DataRow row in dtAllChilds.Rows)
{
dtAllChildsCloned.ImportRow(row);
}
DataView dv = dtAllChildsCloned.DefaultView;
dv.Sort = "Work_Categ_Value";
dtAllChilds = dv.ToTable();
ddlChildWorkCateg.DataSource = dtAllChilds;
ddlChildWorkCateg.DataTextField = "Work_Category_Display";
ddlChildWorkCateg.DataValueField = "Work_Categ_ID";
ddlChildWorkCateg.DataBind();
ddlChildWorkCateg.Items.Insert(0, new ListItem("-Select All-", "0"));
ddlParentWorkCateg.SelectedIndex = 0;
ddlChildWorkCateg.SelectedIndex = 0;
}
protected void BindCombos()
{
JRA_Lib lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = null;
lObjWC.Mode = 0;
DataTable dt = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
DataView dv = dt.DefaultView;
DataTable dtCloned = dt.Clone();
dtCloned.Columns["Work_Categ_Value"].DataType = typeof(float);
foreach (DataRow row in dt.Rows)
{
dtCloned.ImportRow(row);
}
dv = dtCloned.DefaultView;
dv.Sort = "Work_Categ_Value";
dt = dv.ToTable();
ddlParentWorkCateg.DataSource = dt;
ddlParentWorkCateg.DataTextField = "Work_Category_Display";
ddlParentWorkCateg.DataValueField = "Work_Categ_ID";
ddlParentWorkCateg.DataBind();
ddlParentWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = null;
lObjWC.Mode = 3;
DataTable dtAllChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
DataTable dtAllChildsCloned = dtAllChilds.Clone();
dtAllChildsCloned.Columns["Work_Categ_Value"].DataType = typeof(float);
foreach (DataRow row in dtAllChilds.Rows)
{
dtAllChildsCloned.ImportRow(row);
}
dv = dtAllChildsCloned.DefaultView;
dv.Sort = "Work_Categ_Value";
dtAllChilds = dv.ToTable();
ddlChildWorkCateg.DataSource = dtAllChilds;
ddlChildWorkCateg.DataTextField = "Work_Category_Display";
ddlChildWorkCateg.DataValueField = "Work_Categ_ID";
ddlChildWorkCateg.DataBind();
ddlChildWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVessel.DataSource = dtVessel;
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataBind();
DDLVessel.Items.Insert(0, new ListItem("--SELECT ALL--", null));
}
public void LoadCombos()
{
JRA_Lib lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = null;
lObjWC.Mode = 3;
DataTable dtW = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
ddlParentWorkCateg.DataSource = dtW;
ddlParentWorkCateg.DataTextField = "Work_Category_Display";
ddlParentWorkCateg.DataValueField = "Work_Categ_ID_TYPE";
ddlParentWorkCateg.DataBind();
ddlParentWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
ddlCTWorkCategory.DataSource = dtW;
ddlCTWorkCategory.DataTextField = "Work_Category_Display";
ddlCTWorkCategory.DataValueField = "Work_Categ_ID";
ddlCTWorkCategory.DataBind();
ddlParentWorkCateg.SelectedIndex = 0;
}
protected void Load_CategoryList(int?ParentCateID, int Mode)
{
JRA_Lib ObjJRALib = new JRA_Lib();
ObjJRALib.Mode = Mode;
ObjJRALib.Work_Categ_Parent_ID = ParentCateID;
DataTable dt = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(ObjJRALib);
ddlParentCat.DataSource = dt;
ddlParentCat.DataTextField = Convert.ToString(dt.Columns["Work_Category_Name"]);
ddlParentCat.DataValueField = Convert.ToString(dt.Columns["Work_Categ_ID"]);
ddlParentCat.DataBind();
ddlParentCat.Items.Insert(0, new ListItem("-Select-", "0"));
ddlFiter.DataSource = dt;
ddlFiter.DataTextField = Convert.ToString(dt.Columns["Work_Category_Name"]);
ddlFiter.DataValueField = Convert.ToString(dt.Columns["Work_Categ_ID"]);
ddlFiter.DataBind();
ddlFiter.Items.Insert(0, new ListItem("-Select-", "0"));
}
protected void ClearFilter()
{
JRA_Lib lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = null;
lObjWC.Mode = 3;
DataTable dtAllChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
ddlChildWorkCateg.DataSource = dtAllChilds;
ddlChildWorkCateg.DataTextField = "Work_Category_Display";
ddlChildWorkCateg.DataValueField = "Work_Categ_ID";
ddlChildWorkCateg.DataBind();
ddlChildWorkCateg.Items.Insert(0, new ListItem("-Select All-", "0"));
ddlParentWorkCateg.SelectedIndex = 0;
ddlChildWorkCateg.SelectedIndex = 0;
ddlParentWorkCateg.SelectedIndex = 0;
ddlAssessmentStatus.SelectedIndex = 0;
txtFromDate.Text = "";
txtToDate.Text = "";
DDLVessel.SelectedIndex = 0;
}
protected void BindCombos()
{
JRA_Lib lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = null;
lObjWC.Mode = 0;
DataTable dt = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
DataView dv = dt.DefaultView;
DataTable dtCloned = dt.Clone();
dtCloned.Columns["Work_Categ_Value"].DataType = typeof(float);
foreach (DataRow row in dt.Rows)
{
dtCloned.ImportRow(row);
}
dv = dtCloned.DefaultView;
dv.Sort = "Work_Categ_Value";
dt = dv.ToTable();
ddlParentWorkCateg.DataSource = dt;
ddlParentWorkCateg.DataTextField = "Work_Category_Display";
ddlParentWorkCateg.DataValueField = "Work_Categ_ID";
ddlParentWorkCateg.DataBind();
ddlParentWorkCateg.Items.Insert(0, new ListItem("-Select All-", "0"));
lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = null;
lObjWC.Mode = 3;
DataTable dtAllChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
DataTable dtAllChildsCloned = dtAllChilds.Clone();
dtAllChildsCloned.Columns["Work_Categ_Value"].DataType = typeof(float);
foreach (DataRow row in dtAllChilds.Rows)
{
dtAllChildsCloned.ImportRow(row);
}
dv = dtAllChildsCloned.DefaultView;
dv.Sort = "Work_Categ_Value";
dtAllChilds = dv.ToTable();
ddlChildWorkCateg.DataSource = dtAllChilds;
ddlChildWorkCateg.DataTextField = "Work_Category_Display";
ddlChildWorkCateg.DataValueField = "Work_Categ_ID";
ddlChildWorkCateg.DataBind();
ddlChildWorkCateg.Items.Insert(0, new ListItem("-Select All-", "0"));
ddlParentWorkCateg.SelectedIndex = 0;
ddlChildWorkCateg.SelectedIndex = 0;
ddlWorkCategory.DataSource = dtAllChilds;
ddlWorkCategory.DataTextField = "Work_Category_Display";
ddlWorkCategory.DataValueField = "Work_Categ_ID";
ddlWorkCategory.DataBind();
ddlWorkCategory.Items.Insert(0, new ListItem("-Select All-", "0"));
ddlWorkCategory.SelectedIndex = 0;
DataSet dsSev = BLL_JRA_Hazards.GET_TYPE("Severity");
ddlSeverity.DataSource = dsSev.Tables[0];
ddlSeverity.DataTextField = "Type_Display_Text";
ddlSeverity.DataValueField = "Type_ID";
ddlSeverity.DataBind();
ddlSeverity.Items.Insert(0, new ListItem("-Select All-", "0"));
DataSet dsLkhd = BLL_JRA_Hazards.GET_TYPE("Likelihood");
ddlLikelihood.DataSource = dsLkhd.Tables[0];
ddlLikelihood.DataTextField = "Type_Display_Text";
ddlLikelihood.DataValueField = "Type_ID";
ddlLikelihood.DataBind();
ddlLikelihood.Items.Insert(0, new ListItem("-Select All-", "0"));
DataSet dsModRis = BLL_JRA_Hazards.JRA_GET_MODIFIED_RISKS();
ddlModifiedRisk.DataSource = dsModRis.Tables[0];
ddlModifiedRisk.DataTextField = "Type_Display_Text";
ddlModifiedRisk.DataValueField = "Type_ID";
ddlModifiedRisk.DataBind();
ddlModifiedRisk.Items.Insert(0, new ListItem("-Select All-", "0"));
}
private bool ValidateCategory(string CatVal, string CatName)
{
string js = "";
bool Validate = true;
float testfloat;
try
{
if (CatVal.Trim() == "")
{
js = "alert('Enter Category Code');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true);
Validate = false;
}
if (float.TryParse(CatVal.Trim(), out testfloat) == false)
{
js = "alert('Category Code not valid');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true);
Validate = false;
}
if (CatName.Trim() == "")
{
js = "alert('Enter Category Name');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true);
Validate = false;
}
if (ddlParentCat.SelectedIndex == 0)
{
int testInt;
bool res = int.TryParse(CatVal.Trim(), out testInt);
if (!(res && testInt > 0))
{
js = "alert('Category Code not valid');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true);
Validate = false;
}
else
{
JRA_Lib ObjJRALib = new JRA_Lib();
ObjJRALib.Mode = 0;
ObjJRALib.Work_Categ_Parent_ID = null;
DataTable dt = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(ObjJRALib);
if (dt.Select("Work_Categ_Value='" + CatVal.Trim() + "'").Length > 0)
{
js = "alert('Category value already exists');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true);
Validate = false;
}
}
}
else
{
if (!CatVal.Contains('.'))
{
js = "alert('Category Code not valid');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true);
Validate = false;
}
JRA_Lib ObjJRALib = new JRA_Lib();
ObjJRALib.Mode = 0;
ObjJRALib.Work_Categ_Parent_ID = null;
DataTable dt = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(ObjJRALib);
string parentcatvalue = dt.Select("Work_Categ_ID=" + ddlParentCat.SelectedValue.ToString())[0]["Work_Categ_Value"].ToString();
if (Math.Truncate(testfloat).ToString() != parentcatvalue)
{
js = "alert('Category Code not valid');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true);
Validate = false;
}
if (CatVal.Trim().Contains('.'))
{
if (Convert.ToInt32(CatVal.Trim().Split('.')[1]) == 0)
{
js = "alert('Category Code not valid');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true);
Validate = false;
}
}
ObjJRALib = new JRA_Lib();
ObjJRALib.Mode = 1;
ObjJRALib.Work_Categ_Parent_ID = Convert.ToInt32(ddlParentCat.SelectedValue);
DataTable dt1 = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(ObjJRALib);
if (dt1.Select("Work_Categ_Value='" + CatVal.Trim() + "'").Length > 0)
{
js = "alert('Category value already exists');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true);
Validate = false;
}
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
return(Validate);
}
