protected void Page_Load(object sender, EventArgs e) { if (Session["USERID"] == null) { Response.Redirect("~/account/Login.aspx"); } UserAccessValidation(); if (!IsPostBack) { int Vessel_Flag = UDFLib.ConvertToInteger(getQueryString("flag")); int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString()); DataTable dtFlag = objVessel.Get_VesselFlagDetails(Vessel_Flag, UserCompanyID); if (dtFlag.Rows.Count > 0) { txtTemplateName.Text = dtFlag.Rows[0]["flag_name"].ToString(); } txtTemplateBody.Height = 445; //DataTable dt = objBLLCrew.Get_ContractTemplate(Vessel_Flag, UserCompanyID); // Updated Method by passing ContractId int ContractId = 0; DataTable dt = objBLLCrew.Get_ContractTemplate(ContractId); if (dt.Rows.Count > 0) { txtTemplateBody.Text = dt.Rows[0]["template_text"].ToString(); } else { string filePath = Server.MapPath("template.txt"); StreamReader streamReader = new StreamReader(filePath); string text = streamReader.ReadToEnd(); streamReader.Close(); txtTemplateBody.Text = text; } } }