/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ImgExpExcel_Click(object sender, EventArgs e)
{
try
{
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dt = objBLL.CRUD_School("", "R", 0, 0, txtfilter.Text != "" ? txtfilter.Text : null, sortbycoloumn, sortdirection, null, null, ref rowcount, ref Result);
string[] HeaderCaptions = { "School" };
string[] DataColumnsName = { "School" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "School", "School", "");
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
private void BindGrid()
{
BLL_Crew_Admin obj = new BLL_Crew_Admin();
DataTable dt = obj.Get_Manning_Report();
grdManning.DataSource = dt;
grdManning.DataBind();
}
protected void LoadInterviewSheet(int RankId)
{
ddlInterviewSheet.Items.Clear();
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
ddlInterviewSheet.DataSource = objCrewAdmin.Get_InterviewSheets(RankId, "Interview");
ddlInterviewSheet.DataBind();
ddlInterviewSheet.Items.Insert(0, new ListItem("-Select-", "0"));
}
public void Load_RankList()
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
ddlRank.DataSource = objCrewAdmin.Get_RankList();
ddlRank.DataTextField = "Rank_Short_Name";
ddlRank.DataValueField = "ID";
ddlRank.DataBind();
ddlRank.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
}
protected void Load_Rank_Category()
{
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
ddlRankCategory.DataSource = objBLL.Get_RankCategories();
ddlRankCategory.DataTextField = "category_name";
ddlRankCategory.DataValueField = "id";
ddlRankCategory.DataBind();
ddlRankCategory.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
}
public void Load_RankList()
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dt = objCrewAdmin.Get_RankList();
DDLRank.DataSource = dt;
DDLRank.DataTextField = "Rank_Short_Name";
DDLRank.DataValueField = "ID";
DDLRank.DataBind();
}
public void Load_RankList()
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dt = objCrewAdmin.Get_RankList();
ddlCrewInvloveRank.DataSource = dt;
ddlCrewInvloveRank.DataTextField = "Rank_Short_Name";
ddlCrewInvloveRank.DataValueField = "ID";
ddlCrewInvloveRank.DataBind();
ddlCrewInvloveRank.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
ddlCrewInvloveRank.SelectedIndex = 0;
}
/// <summary>
/// Method to load cre ranks drop down
/// </summary>
protected void BindRanks()
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dt = objCrewAdmin.Get_RankList();
ddlRank.DataSource = dt;
ddlRank.DataTextField = "Rank_Short_Name";
ddlRank.DataValueField = "ID";
ddlRank.DataBind();
ddlRank.Items.Insert(0, new ListItem("--Select--", "0"));
}
protected void btnSaveUnionBranch_OnClick(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
int rowcount = 0;
if (Convert.ToInt32(hdnUnionBranchID.Value) > 0)
{
if (hdnAddressType.Value == "1")
{
dt = objBLL.CRUD_UnionBranchUS(txtUnionBranch.Text.Trim(), Convert.ToInt32(hdnUnionBranchID.Value), Convert.ToInt32(drpUnion.SelectedValue), txtAddress.Text.Trim(), Convert.ToInt32(drpCountry.SelectedValue), txtPhoneNumber.Text.Trim(), txtEmail.Text.Trim(), "U", GetSessionUserID(), "", "", null, null, null, ref rowcount, ref Result).Tables[0];
}
else
{
dt = objBLL.CRUD_UnionBranch(txtUnionBranch.Text.Trim(), Convert.ToInt32(hdnUnionBranchID.Value), Convert.ToInt32(drpUnion.SelectedValue), txtAddressLine1.Text.Trim(), txtAddressLine2.Text.Trim(), txtCity.Text.Trim(), txtState.Text, Convert.ToInt32(drpCountry.SelectedValue), txtZipCode.Text.Trim(), txtPhoneNumber.Text.Trim(), txtEmail.Text.Trim(), "U", GetSessionUserID(), "", "", null, null, null, ref rowcount, ref Result).Tables[0];
}
if (Result > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/UpdateMessage") + "');hideModal('divAddUnionBranch');", true);
}
}
else
{
if (hdnAddressType.Value == "1")
{
dt = objBLL.CRUD_UnionBranchUS(txtUnionBranch.Text.Trim(), 0, Convert.ToInt32(drpUnion.SelectedValue), txtAddress.Text.Trim(), Convert.ToInt32(drpCountry.SelectedValue), txtPhoneNumber.Text.Trim(), txtEmail.Text.Trim(), "I", GetSessionUserID(), "", "", null, null, null, ref rowcount, ref Result).Tables[0];
}
else
{
dt = objBLL.CRUD_UnionBranch(txtUnionBranch.Text.Trim(), 0, Convert.ToInt32(drpUnion.SelectedValue), txtAddressLine1.Text.Trim(), txtAddressLine2.Text.Trim(), txtCity.Text.Trim(), txtState.Text, Convert.ToInt32(drpCountry.SelectedValue), txtZipCode.Text.Trim(), txtPhoneNumber.Text.Trim(), txtEmail.Text.Trim(), "I", GetSessionUserID(), "", "", null, null, null, ref rowcount, ref Result).Tables[0];
}
if (Result > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/SaveMessage") + "');hideModal('divAddUnionBranch');", true);
}
}
if (Result < 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('The selected Union Branch already exist in the system');showModal('divAddUnionBranch', false);", true);
}
BindUnionBranch();
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
public void Load_RankList(DropDownList ddlRank)
{
if (ddlRank.Items.Count == 0)
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dt = objCrewAdmin.Get_RankList();
ddlRank.DataSource = dt;
ddlRank.DataTextField = "Rank_Short_Name";
ddlRank.DataValueField = "ID";
ddlRank.DataBind();
ddlRank.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
}
protected void LoadInterviewSheet(int RankId)
{
(frmInterviewDetails.FindControl("ddlInterviewSheet") as DropDownList).Items.Clear();
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dt = objCrewAdmin.Get_InterviewSheets(RankId, "Interview");
(frmInterviewDetails.FindControl("ddlInterviewSheet") as DropDownList).DataSource = dt;
(frmInterviewDetails.FindControl("ddlInterviewSheet") as DropDownList).DataTextField = "INTERVIEW_NAME";
(frmInterviewDetails.FindControl("ddlInterviewSheet") as DropDownList).DataValueField = "ID";
(frmInterviewDetails.FindControl("ddlInterviewSheet") as DropDownList).DataBind();
(frmInterviewDetails.FindControl("ddlInterviewSheet") as DropDownList).Items.Insert(0, new ListItem("-SELECT-", "0"));
(frmInterviewDetails.FindControl("ddlInterviewSheet") as DropDownList).SelectedIndex = 0;
}
public void BindRank()
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dt = objCrewAdmin.Get_RankList();
chkRank1.DataSource = dt;
chkRank1.DataTextField = "Rank_Name";
chkRank1.DataValueField = "ID";
chkRank1.DataBind();
chkRank2.DataSource = dt;
chkRank2.DataTextField = "Rank_Name";
chkRank2.DataValueField = "ID";
chkRank2.DataBind();
}
/// <summary>
/// Delete Oil Major
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void onDeleteUnionBook(object source, CommandEventArgs e)
{
try
{
int rowcount = 0;
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dt = objBLL.CRUD_UnionBook("", "D", GetSessionUserID(), Convert.ToInt32(e.CommandArgument.ToString()), null, "", null, null, null, ref rowcount, ref Result);
if (Result > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "ShowMessage", "alert('Record deleted successfully')", true);
}
BindUnionBook();
}
catch (Exception ex) { UDFLib.WriteExceptionLog(ex); }
}
protected void btnSavePermanent_Click(object sender, EventArgs e)
{
int Result = 1;
try
{
if (Convert.ToInt32(hdnStatusID.Value) > 0)
{
int rowcount = 0;
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dt = objBLL.CRUD_PermanentStatus(txtPermanent.Text.Trim(), "U", GetSessionUserID(), Convert.ToInt32(hdnStatusID.Value), "", "", null, null, null, ref rowcount, ref Result).Tables[0];
///Result == 2 Already exists
if (Result < 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('The selected status already exist in the system');showModal('divAddStatus', false);", true);
}
else if (Result > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/UpdateMessage") + "');hideModal('divAddStatus');", true);
BindPermamnentStatus();
}
}
else
{
int rowcount = 0;
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dt = objBLL.CRUD_PermanentStatus(txtPermanent.Text.Trim(), "I", GetSessionUserID(), 0, "", "", null, null, null, ref rowcount, ref Result).Tables[0];
///Result == 2 Already exists
if (Result < 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('The selected status already exist in the system');showModal('divAddStatus', false);", true);
}
else if (Result > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/SaveMessage") + "');hideModal('divAddStatus');", true);
BindPermamnentStatus();
}
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
public void BindRank()
{
try
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dt = objCrewAdmin.Get_RankList();
chkRank.DataSource = dt;
chkRank.DataTextField = "Rank_Name";
chkRank.DataValueField = "ID";
chkRank.DataBind();
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
private void BindRankDDL()
{
try
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dtRank = new DataTable();
dtRank = objCrewAdmin.Get_RankList();
ddlRank.DataSource = dtRank;
ddlRank.DataTextField = "Rank_Short_Name";
ddlRank.DataValueField = "ID";
ddlRank.DataBind();
ddlRank.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
}
catch
{
}
}
protected void BindPermamnentStatus()
{
try
{
int rowcount = ucCustomPagerPermanent.isCountRecord;
int Result = 1;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataSet dt = objBLL.CRUD_PermanentStatus("", "R", 0, 0, txtPermanentFilter.Text != "" ? txtPermanentFilter.Text : null, sortbycoloumn, sortdirection
, ucCustomPagerPermanent.CurrentPageIndex, ucCustomPagerPermanent.PageSize, ref rowcount, ref Result);
if (dt != null)
{
if (ucCustomPagerPermanent.isCountRecord == 1)
{
ucCustomPagerPermanent.CountTotalRec = rowcount.ToString();
ucCustomPagerPermanent.BuildPager();
}
if (dt.Tables[0].Rows.Count > 0)
{
gvPermanentStatus.DataSource = dt.Tables[0];
gvPermanentStatus.DataBind();
}
else
{
gvPermanentStatus.DataSource = null;
gvPermanentStatus.DataBind();
}
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
/// <summary>
/// Bind School
/// </summary>
public void BindUnionBook()
{
try
{
int rowcount = ucCustomPager1UnionBook.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN_UNIONBOOK"] == null) ? null : (ViewState["SORTBYCOLOUMN_UNIONBOOK"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION_UNIONBOOK"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION_UNIONBOOK"].ToString());
}
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dt = objBLL.CRUD_UnionBook("", "R", 0, 0, txtUnionBookFilter.Text != "" ? txtUnionBookFilter.Text : null, sortbycoloumn, sortdirection
, ucCustomPager1UnionBook.CurrentPageIndex, ucCustomPager1UnionBook.PageSize, ref rowcount, ref Result);
if (ucCustomPager1UnionBook.isCountRecord == 1)
{
ucCustomPager1UnionBook.CountTotalRec = rowcount.ToString();
ucCustomPager1UnionBook.BuildPager();
}
if (dt.Rows.Count > 0)
{
gvUnionBook.DataSource = dt;
gvUnionBook.DataBind();
ImgBtnExportUnionBook.Visible = true;
}
else
{
gvUnionBook.DataSource = null;
gvUnionBook.DataBind();
ImgBtnExportUnionBook.Visible = false;
}
}
catch (Exception ex) { UDFLib.WriteExceptionLog(ex); }
}
private void BindVeteranStatus()
{
try
{
int rowcount = ucCustomPagerItemsVeteranStatus.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN_VS"] == null) ? null : (ViewState["SORTBYCOLOUMN_VS"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION_VS"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION_VS"].ToString());
}
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dt = objBLL.CRUD_VeteranStatus("", "R", 0, 0, txtVeteranStatusFilter.Text != "" ? txtVeteranStatusFilter.Text : null, sortbycoloumn, sortdirection
, ucCustomPagerItemsVeteranStatus.CurrentPageIndex, ucCustomPagerItemsVeteranStatus.PageSize, ref rowcount, ref Result);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItemsVeteranStatus.CountTotalRec = rowcount.ToString();
ucCustomPagerItemsVeteranStatus.BuildPager();
}
if (dt.Rows.Count > 0)
{
gvVeteranStatus.DataSource = dt;
gvVeteranStatus.DataBind();
ImgExpExcelVeteran.Visible = true;
}
else
{
gvVeteranStatus.DataSource = null;
gvVeteranStatus.DataBind();
ImgExpExcelVeteran.Visible = false;
}
}
catch (Exception ex) { UDFLib.WriteExceptionLog(ex); }
}
protected void rdblstAppType_SelectedIndexChanged(object sender, EventArgs e)
{
if (hfType.Value != null && hfType.Value.ToString() != "")
{
if (hfType.Value.ToString() == "1")
{
pnlOffice.Visible = true;
pnlVessel.Visible = false;
rdblstAppType.SelectedIndex = 0;
}
else
{
pnlOffice.Visible = false;
pnlVessel.Visible = true;
rdblstAppType.SelectedIndex = 1;
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dt = objCrewAdmin.Get_RankList();
gvRankList.DataSource = dt;
gvRankList.DataBind();
}
}
//if (rdblstAppType.SelectedValue == "1")
//{
// pnlOffice.Visible = true;
// pnlVessel.Visible = false;
// ViewState["Mode"] = "1";
//}
//else
//{
// pnlOffice.Visible = false;
// pnlVessel.Visible = true;
// ViewState["Mode"] = "0";
//}
//BindApprovar( Work_Categ_ID,"RD");
}
/// <summary>
/// Bind Oil Majors
/// </summary>
public void BindOilMajors()
{
try
{
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dt = objBLL.CRUD_OilMajors("", "", "R", 0, 0, txtfilter.Text != "" ? txtfilter.Text.Trim() : null, sortbycoloumn, sortdirection
, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, txtRemarks.Text, 0, "", ref rowcount, ref Result);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
gvOilMajors.DataSource = dt;
gvOilMajors.DataBind();
if (dt.Rows.Count > 0)
{
ImgExpExcel.Visible = true;
}
else
{
ImgExpExcel.Visible = false;
}
}
catch (Exception ex) { UDFLib.WriteExceptionLog(ex); }
}
/// <summary>
/// Method is used to bind Oil major dropdown
/// </summary>
public void FillOilMajorDropdown()
{
try
{
DataSet dsOilMajor = new DataSet();
BLL_Crew_Admin objCrew = new BLL_Crew_Admin();
dsOilMajor = objCrew.GetOilMajor();
if (dsOilMajor.Tables.Count > 0)
{
if (dsOilMajor.Tables[0].Rows.Count > 0)
{
ddlOilMajor.DataSource = dsOilMajor.Tables[0];
ddlOilMajor.DataTextField = dsOilMajor.Tables[0].Columns["Display_Name"].ToString();
ddlOilMajor.DataValueField = dsOilMajor.Tables[0].Columns["ID"].ToString();
ddlOilMajor.DataBind();
ddlOilMajor.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
/// <summary>
/// Bind Union
/// </summary>
public void BindUnion()
{
try
{
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataSet dt = objBLL.CRUD_Union("", "R", 0, 0, txtfilter.Text != "" ? txtfilter.Text : null, sortbycoloumn, sortdirection
, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount, ref Result);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (dt.Tables[0].Rows.Count > 0)
{
gvUnion.DataSource = dt.Tables[0];
gvUnion.DataBind();
drpUnion.DataSource = dt.Tables[0];
drpUnion.DataTextField = "UnionName";
drpUnion.DataValueField = "ID";
drpUnion.DataBind();
drpUnion.Items.Insert(0, new ListItem()
{
Text = "-Select-", Value = "0"
});
divBranch.Visible = false;
gvUnionBranch.DataSource = null;
gvUnionBranch.DataBind();
}
else
{
gvUnion.DataSource = null;
gvUnion.DataBind();
}
if (dt.Tables[1].Rows.Count > 0)
{
drpCountry.DataSource = dt.Tables[1];
drpCountry.DataTextField = "Country_Name";
drpCountry.DataValueField = "ID";
drpCountry.DataBind();
drpCountry.Items.Insert(0, new ListItem()
{
Text = "-Select-", Value = "0"
});
dt.Tables[1].DefaultView.RowFilter = "";
dt.Tables[1].DefaultView.RowFilter = "ISO_Code='US'";
if (dt.Tables[1].DefaultView.Count > 0)
{
hdnUSCountryID.Value = Convert.ToString(dt.Tables[1].DefaultView[0]["ID"]);
}
}
if (dt.Tables[2].Rows.Count > 0)
{
///0- US Client
///1- International Client
if (Convert.ToInt32(dt.Tables[2].Rows[0]["Value"]) == 0)
{
hdnAddressType.Value = "0";
trUSAddress.Visible = true;
trInternationAddress.Visible = false;
}
else
{
hdnAddressType.Value = "1";
trInternationAddress.Visible = true;
trUSAddress.Visible = false;
}
}
}
catch (Exception ex) { UDFLib.WriteExceptionLog(ex); }
}
/// <summary>
/// To save or update oil major
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnsave_OnClick(object sender, EventArgs e)
{
string path = "";
int ActiveStatus = 0;
if (chkIsActive.Checked == true)
{
ActiveStatus = 1;
}
else
{
ActiveStatus = 0;
}
try
{
if (hdnUploadFileName.Value != "")
{
FileInfo fn = new FileInfo(hdnUploadFileName.Value);
Guid gid = Guid.NewGuid();
string filename = "OLM_" + gid + fn.Extension;
path = "~/Uploads/OilMajorLogo/" + filename;
FileUpload1.SaveAs(Server.MapPath("~/Uploads/OilMajorLogo/" + filename));
}
if (txtDisplayName.Text == "")
{
txtDisplayName.Text = txtOilMajorName.Text.Trim();
}
if (Convert.ToInt32(hdnOilMajorID.Value) > 0)
{
OperationMode = "Add/Edit Oil Major";
int rowcount = 0;
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dt = objBLL.CRUD_OilMajors(txtOilMajorName.Text.Trim(), txtDisplayName.Text.Trim(), "U", GetSessionUserID(), Convert.ToInt32(hdnOilMajorID.Value), null, "", null, null, null, txtRemarks.Text, ActiveStatus, path, ref rowcount, ref Result);
///Result == 2 Already exists
if (Result < 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("InformationMessage/DataExists") + "');showModal('divadd', false);", true);
}
if (Result > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/UpdateMessage") + "');hideModal('divadd');", true);
hdnUploadFileName.Value = "";
BindOilMajors();
}
}
else
{
OperationMode = "Add Oil Major";
int rowcount = 0;
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dt = objBLL.CRUD_OilMajors(txtOilMajorName.Text.Trim(), txtDisplayName.Text.Trim(), "I", GetSessionUserID(), 0, null, "", null, null, null, txtRemarks.Text, ActiveStatus, path, ref rowcount, ref Result);
///Result == 2 Already exists
if (Result < 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("InformationMessage/DataExists") + "');showModal('divadd', false);", true);
}
if (Result > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/SaveMessage") + "');hideModal('divadd');", true);
BindOilMajors();
}
}
// it will clear all the values and avoid adding the Duplicate records !Desc:- when one intend to page refreseh ,javascript alert msg raise, says it will perform the same action again,so value might gets duplicate , so we can avoid this by below code
//Response.Redirect(Request.Url.AbsoluteUri);
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void lnkEditInterviewPlanning_Click()
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
BLL_Crew_CrewDetails objCrewBLL = new BLL_Crew_CrewDetails();
BLL_Infra_TimeZones objTimeZone = new BLL_Infra_TimeZones();
try
{
int CrewID = int.Parse(hdnCrewID.Value);
int CurrentRankId = 0;
if (objCrewBLL.Get_CrewPersonalDetailsByID(CrewID, "CurrentRankID") != null && objCrewBLL.Get_CrewPersonalDetailsByID(CrewID, "CurrentRankID") != "")
{
CurrentRankId = int.Parse(objCrewBLL.Get_CrewPersonalDetailsByID(CrewID, "CurrentRankID"));
}
LoadInterviewSheet(CurrentRankId);
ddlPlanRank.DataSource = objCrewAdmin.Get_RankList();
ddlPlanRank.DataBind();
ddlPlanRank.Enabled = false;
ddlInterviewRank.DataSource = objCrewAdmin.Get_RankList();
ddlInterviewRank.DataBind();
DataTable dt = objTimeZone.Get_TimeZoneList();
ddlTimeZone.DataSource = dt;
ddlTimeZone.DataTextField = "DisplayName";
ddlTimeZone.DataValueField = "TimeZone";
ddlTimeZone.DataBind();
try
{
DataRow[] dr = dt.Select("DefaultTimeZone=1");
if (dr.Length > 0)
{
ddlTimeZone.SelectedValue = dr[0]["TimeZone"].ToString();
}
}
catch { }
string rank = objCrewBLL.Get_CrewPersonalDetailsByID(CrewID, "CurrentRankID");
if (rank != "")
{
ddlPlanRank.SelectedValue = rank;
ddlInterviewRank.SelectedValue = rank;
}
else
{
ddlPlanRank.SelectedIndex = 0;
}
int IsMandatoryDocumentsUploaded = objCrewBLL.IsMandatoryDocumentsUploaded(CrewID);
if (IsMandatoryDocumentsUploaded == 0)
{
lblMessage.Text = "Interview can not be planned for the crew. The necessery documents are not yet uploaded!!";
return;
}
}
catch { }
pnlEdit_InterviewPlanning.Visible = true;
pnlView_InterviewPlanning.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
// show office portage only if office portage bill has been considered for any joining type//
string arg = Request.QueryString["arg"].ToString();
string[] arr;
if (arg != null && arg.Length > 0)
{
arr = arg.Split('~');
ViewState["Vessel_ID"] = UDFLib.ConvertToInteger(arr[0]);
ViewState["PBDt"] = DateTime.Parse(arr[1]);
ViewState["Vessel_Name"] = arr[2];
}
if (UDFLib.ConvertToInteger(ViewState["Vessel_ID"]) > 0)
{
BLL_Crew_Admin objAdm = new BLL_Crew_Admin();
DataTable dtJtype = objAdm.Get_JoiningType_List(null);
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVsl = objVsl.GetVesselDetails_ByID(Convert.ToInt32(ViewState["Vessel_ID"]));
if (dtJtype.Rows.Count > 0 && dtVsl.Rows.Count > 0)
{
// for office vessel only
if (dtJtype.Select("OfficePortageBillConsidered=1").Length > 0 && UDFLib.ConvertToInteger(dtVsl.Rows[0]["ISVESSEL"]) == 0)
{
btnGeneratePortageBill.Visible = true;
btnFinalizePortageBill.Visible = true;
DataTable dtOPPbill = BLL_PB_PortageBill.Get_Open_PortageBill();
if (dtOPPbill.Rows.Count > 0 && Convert.ToString(dtOPPbill.Rows[0]["GENERATE_PB"]).Trim().Length > 1)
{
ViewState["Open_PB_Month"] = Convert.ToDateTime(dtOPPbill.Rows[0]["PB_GEN_DATE"]).Month;
ViewState["Open_PB_Year"] = Convert.ToDateTime(dtOPPbill.Rows[0]["PB_GEN_DATE"]).Year;
}
// if open pbill is same as requested then generate pbill //
if (int.Parse(ViewState["Open_PB_Month"].ToString()) == DateTime.Parse(ViewState["PBDt"].ToString()).Month&& int.Parse(ViewState["Open_PB_Year"].ToString()) == DateTime.Parse(ViewState["PBDt"].ToString()).Year)
{
BLL_PB_PortageBill.Upd_Generate_PortageBill(ViewState["Open_PB_Month"].ToString(), ViewState["Open_PB_Year"].ToString(), Convert.ToInt32(ViewState["Vessel_ID"]), Convert.ToInt32(Session["USERID"]), null);
}
else
{
btnGeneratePortageBill.Visible = false;
btnFinalizePortageBill.Visible = false;
}
}
else
{
btnGeneratePortageBill.Visible = false;
btnFinalizePortageBill.Visible = false;
}
}
Load_PortageBill();
}
UserAccessValidation();
}
public string ValidateUSAddress(string AddressLine1, string AddressLine2, string City, string State, string ZipCode, string Country, string Type, string CrewName, string ClientName, string Mode, string StaffCode, string DOB, string AppliedRank)
{
StringBuilder Return = new StringBuilder();
BLL_Crew_Admin objBLL_Crew_Admin = new BLL_Crew_Admin();
DataTable dt = objBLL_Crew_Admin.CRW_LIB_AddressValidationSetting();
string Url = "", Username = "", Password = "", ToEmailId = "", FromEmailId = "", EmailBody = "";
try
{
var requestXml = new XmlDocument();
StringBuilder strURLParamter = new StringBuilder();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
dt.DefaultView.RowFilter = "key='USPSUrl'";
Url = Convert.ToString(dt.DefaultView[0]["Value"]).Trim();
dt.DefaultView.RowFilter = "";
dt.DefaultView.RowFilter = "key='Username'";
Username = Convert.ToString(dt.DefaultView[0]["Value"]).Trim();
dt.DefaultView.RowFilter = "";
dt.DefaultView.RowFilter = "key='Password'";
Password = Convert.ToString(dt.DefaultView[0]["Value"]).Trim();
dt.DefaultView.RowFilter = "";
dt.DefaultView.RowFilter = "key='ToEmailId'";
ToEmailId = Convert.ToString(dt.DefaultView[0]["Value"]).Trim();
dt.DefaultView.RowFilter = "";
dt.DefaultView.RowFilter = "key='FromEmailId'";
FromEmailId = Convert.ToString(dt.DefaultView[0]["Value"]).Trim();
dt.DefaultView.RowFilter = "";
dt.DefaultView.RowFilter = "key='EmailBody'";
EmailBody = Convert.ToString(dt.DefaultView[0]["Value"]).Trim();
if (Url != "" && Username != "" && Password != "")
{
strURLParamter.Append("<AddressValidateRequest USERID=\"" + Username + "\">");
strURLParamter.Append("<Address ID=\"0\">");
strURLParamter.Append("<FirmName />");
strURLParamter.Append("<Address1>" + AddressLine1.Trim() + "</Address1>");
strURLParamter.Append("<Address2>" + AddressLine2.Trim() + "</Address2>");
strURLParamter.Append("<City>" + City.Trim() + "</City>");
strURLParamter.Append("<State>" + State.Trim() + "</State>");
strURLParamter.Append("<Zip5>" + ZipCode.Trim() + "</Zip5>");
strURLParamter.Append("<Zip4></Zip4>");
strURLParamter.Append("</Address>");
strURLParamter.Append("</AddressValidateRequest>");
// build XML request
var httpRequest = HttpWebRequest.Create(Url + "?API=Verify&XML=" + strURLParamter.ToString());
httpRequest.Method = "POST";
httpRequest.ContentType = "text/xml";
// set appropriate headers
using (var requestStream = httpRequest.GetRequestStream())
{
requestXml.Save(requestStream);
}
using (var response = (HttpWebResponse)httpRequest.GetResponse())
using (var responseStream = response.GetResponseStream())
{
// may want to check response.StatusCode to
// see if the request was successful
var responseXml = new XmlDocument();
responseXml.Load(responseStream);
if (responseXml.SelectSingleNode("//Error") != null)
{
XmlNodeList objXmlNode = responseXml.SelectNodes("AddressValidateResponse/Address/Error");
if (objXmlNode != null)
{
foreach (XmlNode item in objXmlNode)
{
Return.Append("Result:Invalid,");
Return.Append("ErrorMessage: " + item["Description"].InnerText);
}
}
}
else
{
XmlNodeList objXmlNode = responseXml.SelectNodes("AddressValidateResponse/Address");
if (objXmlNode != null)
{
foreach (XmlNode item in objXmlNode)
{
string Address1 = "", Address2 = "";
if (item["Address1"] != null)
{
Address1 = item["Address1"].InnerText;
if (item["Address1"].InnerText.Contains("#"))
{
AddressLine1 = "# " + AddressLine1;
}
}
if (item["Address2"] != null)
{
Address2 = item["Address2"].InnerText;
if (item["Address2"].InnerText.Contains("#"))
{
AddressLine2 = "# " + AddressLine2;
}
}
if (AddressLine1.ToLower() != Address1.ToLower() || AddressLine2.ToLower() != Address2.ToLower() || City.ToLower() != item["City"].InnerText.ToLower() || State.ToLower() != item["State"].InnerText.ToLower() || ZipCode.ToLower() != item["Zip5"].InnerText.ToLower())
{
Return.Append("Result:ValidAddress,");
Return.Append("Address Line 1: " + Address2 + ",");
Return.Append("Address Line 2: " + Address1 + ",");
Return.Append("City: " + item["City"].InnerText + ",");
Return.Append("State: " + item["State"].InnerText + ",");
Return.Append("ZipCode: " + item["Zip5"].InnerText);
}
else
{
Return.Append("Result:Valid");
}
}
}
}
}
}
else
{
Return.Append("Result:No Settings");//No setting exists in DB
}
}
else
{
Return.Append("Result:No Settings");
}
}
else
{
Return.Append("Result:No Settings");
}
}
catch (Exception ex)
{
if (Type == "Crew")
{
if (!ex.ToString().ToLower().Contains(":line"))
{
BLL_Crew_CrewDetails objCrew = new BLL_Crew_CrewDetails();
EmailBody = EmailBody.Replace("$$Client$$", ClientName);
EmailBody = EmailBody.Replace("$$CrewName$$", CrewName);
EmailBody = EmailBody.Replace("$$Date$$", DateTime.Now.ToString());
EmailBody = EmailBody.Replace("$$Status$$", ex.ToString());
EmailBody = StaffCode == "" ? EmailBody.Replace("$$StaffCode$$", "-") : EmailBody.Replace("$$StaffCode$$", StaffCode);
EmailBody = DOB == "" ? EmailBody.Replace("$$DOB$$", "-") : EmailBody.Replace("$$DOB$$", DOB);
EmailBody = AppliedRank == "" ? EmailBody.Replace("$$AppliedRank$$", "-") : EmailBody.Replace("$$AppliedRank$$", AppliedRank);
if (Mode == "Add")
{
EmailBody = EmailBody.Replace("$$Remark$$", "USPS service is down/not responding while adding the crew.");
}
else if (Mode == "Edit")
{
EmailBody = EmailBody.Replace("$$Remark$$", "USPS service is down/not responding while updating the crew.");
}
objCrew.Send_CrewNotification(0, 0, 0, 0, ToEmailId, "", "", ClientName + "- USPS Service Error", EmailBody, "", "MAIL", "", 1, "READY");
}
}
Return.Append("Result:Error"); //-- Error
}
return(Return.ToString());
}
public void BindApprovar(int Work_Categ_ID)
{
DataSet ds = new DataSet();
ds = BLL_JRA_Hazards.Get_Approvar(Work_Categ_ID);
lblWC.Text = hfIDName.Value;
//if (ds.Tables[0].Rows.Count>0)
// lblWC.Text = ds.Tables[0].Rows[0]["Work_Categ_ID_Name"].ToString()+" :- ";
if (ds.Tables[1].Rows.Count > 0)
{
ViewState["TotalApprovalLevel"] = ds.Tables[1].Rows[0]["LevelCount"].ToString();
}
else
{
ViewState["TotalApprovalLevel"] = 1;
}
if (hfType.Value == "0")
{
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
DataTable dt = objCrewAdmin.Get_RankList();
gvRankList.DataSource = dt;
gvRankList.DataBind();
pnlOffice.Visible = false;
pnlVessel.Visible = true;
rdblstAppType.SelectedIndex = 1;
}
else
{
grdLevel.DataSource = null;
grdLevel.DataBind();
grdLevel.DataSource = ds.Tables[0];
grdLevel.DataBind();
pnlOffice.Visible = true;
pnlVessel.Visible = false;
rdblstAppType.SelectedIndex = 0;
}
//if (ds.Tables[2].Rows[0]["Type"].ToString() == "1" && (hfType.Value == "0" ))
//{
// BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
// DataTable dt = objCrewAdmin.Get_RankList();
// gvRankList.DataSource = dt;
// gvRankList.DataBind();
// pnlOffice.Visible = true;
// pnlVessel.Visible = false;
//}
//else
//{
// grdLevel.DataSource = null;
// grdLevel.DataBind();
// grdLevel.DataSource = ds.Tables[0];
// grdLevel.DataBind();
// pnlOffice.Visible = true;
// pnlVessel.Visible = false;
//}
//if (ds.Tables[2].Rows[0]["Type"].ToString() == "0")
//{
// lblWorkCateg.Text = ds.Tables[2].Rows[0]["Work_Category_Name"].ToString();
// try
// {
// ddlRank.SelectedValue = ds.Tables[3].Rows[0]["Approvar_Detail_ID"].ToString();
// }
// catch (Exception)
// {
// ddlRank.SelectedIndex = 0;
// }
// pnlOffice.Visible = false;
// rdblstAppType.SelectedValue = "0";
//}
//else
//{
// //GridViewHelper helper = new GridViewHelper(grdLevel);
// //helper.RegisterGroup("Approval_Level", true, true);
// //helper.GroupHeader += new GroupEvent(helper_GroupHeader);
// grdLevel.DataSource = null;
// grdLevel.DataBind();
// grdLevel.DataSource = ds.Tables[0];
// grdLevel.DataBind();
// pnlOffice.Visible = true;
// pnlVessel.Visible = false;
// rdblstAppType.SelectedValue = "1";
//}
}
/// <summary>
/// Description: Method to create the dynamic list of categorywise graph
/// Baseed on Crew rank category, graph will be creted
/// </summary>
private void GenearteDiv()
{
try
{
hdnRanks.Value = "";
hdnYears.Value = "";
DataTable dtRank = ddlRank.SelectedValues;
DataTable dtYear = ddlYear.SelectedValues;
foreach (DataRow dr in dtRank.Rows)
{
hdnRanks.Value = hdnRanks.Value + "," + dr["SelectedValue"].ToString();
}
hdnRanks.Value = hdnRanks.Value.Trim(',');
foreach (DataRow dr in dtYear.Rows)
{
hdnYears.Value = hdnYears.Value + "," + dr["SelectedValue"].ToString();;
}
hdnYears.Value = hdnYears.Value.Trim(',');
string sContainer = "chartContainer_";
string sGContainer = "gridContainer_";
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
PlaceHolder1.Controls.Clear();
int rowcount = 0;
DataTable dt = objCrewAdmin.Get_RankCategories();
rowcount = dt.Rows.Count;
string shdnCategoryID = "";
string shdnCategory = "";
hdnCategoryID.Value = shdnCategoryID;
hdnCategory.Value = shdnCategory;
foreach (DataRow dr in dt.Rows)
{
if (hdnCategoryID.Value == "")
{
hdnCategory.Value = dr["Category_Name"].ToString();
hdnCategoryID.Value = dr["ID"].ToString();
}
else
{
hdnCategory.Value = hdnCategory.Value + "," + dr["Category_Name"].ToString();
hdnCategoryID.Value = hdnCategoryID.Value + "," + dr["ID"].ToString();
}
}
hdnCategory.Value = hdnCategory.Value.Trim(',');
hdnCategoryID.Value = hdnCategoryID.Value.Trim(',');
int totalCategories = dt.Rows.Count;
int tblRows = 1;
int tblCols = 2;//--do--
//int tblCols = 1;//--do--
if (totalCategories > 1)
{
if (totalCategories < 3)
{
tblRows = 1;
}
else if (totalCategories < 5)
{
tblRows = 2;
}
else
{
tblRows = (int)Math.Ceiling((double)totalCategories / 2);
}
}
Table tbl = new Table();
tbl.Attributes.Add("align", "center");
int catindex = 0;
string CategoryId = "";
string CategoyName = "";
PlaceHolder1.Controls.Add(tbl);
string sURL;
//TableRow tr = new TableRow();
int iCount = 0;
//for (int i = 0; i < tblRows; i++)
for (int i = 0; i < totalCategories; i++)
{
TableRow tr = new TableRow();
//for (int j = 0; j < tblCols; j++)
//{
if (iCount < rowcount)
{
TableCell tc = new TableCell();
CategoryId = dt.Rows[iCount]["ID"].ToString();
CategoyName = dt.Rows[iCount]["Category_Name"].ToString();
catindex++;
iCount++;
HtmlGenericControl newControl = new HtmlGenericControl("div");
HiddenField hdnCatId = new HiddenField();
HiddenField hdnCatName = new HiddenField();
//hdnCatId.ID = "hdnID_" + i + j;
//hdnCatName.ID = "hdnName_" + i + j;
hdnCatId.ID = "hdnID_" + i;
hdnCatName.ID = "hdnName_" + i;
//newControl.ID = sContainer + i + "_" + j;
newControl.ID = sContainer + i;
newControl.Attributes.Add("Style", "Height:300px;width:700px;float:left; padding-right:20px; padding-bottom:50px;");
//newControl.Attributes.Add("onclick", "openDetail('" + CategoryId + "','" + CategoyName + "')");
newControl.InnerHtml = "";
tc.Controls.Add(newControl);
HtmlGenericControl newGridControl = new HtmlGenericControl("div");
//hdnCatId.ID = "hdnID_" + i + j;
//hdnCatName.ID = "hdnName_" + i + j;
//newGridControl.ID = sGContainer + i + "_" + j;
hdnCatId.ID = "hdnID_" + i;
hdnCatName.ID = "hdnName_" + i;
newGridControl.ID = sGContainer + i;
newGridControl.Attributes.Add("Style", "Height:300px;width:700px;float:left;");
newGridControl.InnerHtml = "";
tc.Controls.Add(newGridControl);
hdnCatId.Value = CategoryId;
hdnCatName.Value = CategoyName;
tc.Controls.Add(hdnCatId);
tc.Controls.Add(hdnCatName);
tr.Cells.Add(tc);
}
TableRow tr1 = new TableRow();
TableCell td = new TableCell();
HtmlGenericControl labelControl1 = new HtmlGenericControl("div");
labelControl1.ID = "header_" + i;
labelControl1.InnerHtml = "Retention Rate - " + CategoyName;
labelControl1.Attributes.Add("Style", "Height:50px;width:850px;float:right; font-weight:bold;font-size: 14px;");
td.Controls.Add(labelControl1);
tr1.Cells.Add(td);
//}
tbl.Rows.Add(tr1);
tbl.Rows.Add(tr);
}
hiddenCount.Value = tblRows.ToString();
hiddenCount1.Value = tblCols.ToString();
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
/// <summary>
/// Description: Method to create the dynamic list of categorywise graph
/// @author:Bhairab
/// </summary>
private void GenearteDiv()
{
try
{
hdnRanks.Value = "";
hdnYears.Value = "";
DataTable dtRank = ddlRank.SelectedValues;
DataTable dtYear = ddlYear.SelectedValues;
foreach (DataRow dr in dtRank.Rows)
{
hdnRanks.Value = hdnRanks.Value + "," + dr["SelectedValue"].ToString();
}
hdnRanks.Value = hdnRanks.Value.Trim(',');
foreach (DataRow dr in dtYear.Rows)
{
hdnYears.Value = hdnYears.Value + "," + dr["SelectedValue"].ToString();;
}
hdnYears.Value = hdnYears.Value.Trim(',');
string sContainer = "chartContainer_";
BLL_Crew_Admin objCrewAdmin = new BLL_Crew_Admin();
PlaceHolder1.Controls.Clear();
int rowcount = 0;
DataTable dt = objCrewAdmin.Get_RankCategories();
rowcount = dt.Rows.Count;
string shdnCategoryID = "0";
string shdnCategory = "Selected Ranks";
hdnCategoryID.Value = shdnCategoryID;
hdnCategory.Value = shdnCategory;
foreach (DataRow dr in dt.Rows)
{
hdnCategory.Value = hdnCategory.Value + "," + dr["Category_Name"].ToString();
hdnCategoryID.Value = hdnCategoryID.Value + "," + dr["ID"].ToString();
}
hdnCategory.Value = hdnCategory.Value.Trim(',');
hdnCategoryID.Value = hdnCategoryID.Value.Trim(',');
int totalCategories = dt.Rows.Count + 1;
int tblRows = 1;
int tblCols = 2;//--do--
if (totalCategories > 1)
{
if (totalCategories < 3)
{
tblRows = 1;
}
else if (totalCategories < 5)
{
tblRows = 2;
}
else
{
tblRows = (int)Math.Ceiling((double)totalCategories / 2);
}
}
Table tbl = new Table();
tbl.Attributes.Add("align", "center");
int catindex = 0;
string CategoryId = "";
string CategoyName = "";
PlaceHolder1.Controls.Add(tbl);
string sURL;
//TableRow tr = new TableRow();
int iCount = 0;
for (int i = 0; i < tblRows; i++)
{
TableRow tr = new TableRow();
for (int j = 0; j < tblCols; j++)
{
if (iCount < rowcount)
{
TableCell tc = new TableCell();
if (i == 0 && j == 0)
{
CategoryId = "0";
CategoyName = "Selected Ranks";
}
else
{
CategoryId = dt.Rows[iCount]["ID"].ToString();
CategoyName = dt.Rows[iCount]["Category_Name"].ToString();
catindex++;
}
HtmlGenericControl newControl = new HtmlGenericControl("div");
HiddenField hdnCatId = new HiddenField();
HiddenField hdnCatName = new HiddenField();
hdnCatId.ID = "hdnID_" + i + j;
hdnCatName.ID = "hdnName_" + i + j;
newControl.ID = sContainer + i + j;
newControl.Attributes.Add("Style", "Height:300px;width:700px;float:left");
newControl.Attributes.Add("onclick", "openDetail('" + CategoryId + "','" + CategoyName + "')");
newControl.InnerHtml = "";
tc.Controls.Add(newControl);
hdnCatId.Value = CategoryId;
hdnCatName.Value = CategoyName;
tc.Controls.Add(hdnCatId);
tc.Controls.Add(hdnCatName);
tr.Cells.Add(tc);
iCount++;
}
}
tbl.Rows.Add(tr);
}
hiddenCount.Value = tblRows.ToString();
hiddenCount1.Value = tblCols.ToString();
}
catch (Exception ex)
{
}
}
