private void fillAllInfo()
{
objEnt = packageObj.readerForPackageDetailByNo(txtPackageNo.Text);
if (objEnt.PackageNumber != null)
{
txtPackageNo.Text = objEnt.PackageNumber;
txtPackageName.Text = objEnt.PackageName;
if (objEnt.StartDate != null)
{
if (objEnt.StartDate != "")
{
DateTime dtstartdate = DateTime.Parse(objEnt.StartDate);
txtStartDate.Text = dtstartdate.ToString(clsConstant.DATE_FORMAT);
}
}
else
{
txtStartDate.Text = "";
}
if (objEnt.EndDate != null)
{
if (objEnt.EndDate != "")
{
DateTime dtenddate = DateTime.Parse(objEnt.EndDate);
txtEndDate.Text = dtenddate.ToString(clsConstant.DATE_FORMAT);
}
}
drpLoanNumber.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_LOAN, null);
drpLoanNumber.DataTextField = "DisplayFieldText";
drpLoanNumber.DataValueField = "ValueFieldText";
drpLoanNumber.DataBind();
drpLoanNumber.SelectedValue = objEnt.LoanID.ToString();
if (objEnt.PackageNumber != null)
{
btnCancel.Visible = true;
btnSubmit.Visible = true;
lblMessage.ForeColor = System.Drawing.Color.Black;
DataSet ds = new DataSet();
ds.ReadXml(HostingEnvironment.ApplicationPhysicalPath + "XML Files\\Message.xml");
lblMessage.Text = ds.Tables[0].Rows[11][1].ToString();
}
btnUpdate.Visible = true;
btnSubmit.Visible = false;
}
else
{
btnUpdate.Visible = false;
btnSubmit.Visible = true;
btnCancel.Visible = true;
lblMessage.Text = "";
}
}
/// <summary>
///
/// </summary>
/// <param name="packageID"></param>
/// <returns></returns>
public clsEntPackageDetails readerForPackageDetail(string packageID)
{
clsEntPackageDetails objEnt = new clsEntPackageDetails();
SqlDataReader reader;
try
{
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@packageID", packageID) };
reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_PACKAGE_DETAILS_CHECK, CommandType.StoredProcedure, param);
while (reader.Read())
{
objEnt.PackageID = Convert.ToInt32(reader.GetValue(0));
objEnt.PackageNumber = reader.GetValue(1).ToString();
objEnt.PackageName = reader.GetValue(2).ToString();
string dtStartDate = reader.GetValue(3).ToString();
string dtEndDate = reader.GetValue(4).ToString();
if (dtStartDate == "" || dtStartDate == "01 Jan 1900")
{
objEnt.StartDate = "";
}
else
{
objEnt.StartDate = dtStartDate;
}
if (dtEndDate == "" || dtEndDate == "01 Jan 1900")
{
objEnt.EndDate = "";
}
else
{
objEnt.EndDate = dtEndDate;
}
objEnt.LoanID = Convert.ToInt32(reader.GetValue(5));
}
return(objEnt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
ds.ReadXml(HostingEnvironment.ApplicationPhysicalPath + "XML Files\\Message.xml");
if (IsPostBack)
{
var ctrlName = Request.Params[PageBase.postEventSourceID];
var args = Request.Params[PageBase.postEventArgumentID];
HandleCustomPostbackEvent(ctrlName, args);
}
packageID = Request.QueryString["packageID"];
if (packageID != null)
{
if (!IsPostBack)
{
objEnt = packageObj.readerForPackageDetail(packageID);
if (objEnt.PackageNumber != null)
{
btnUpdate.Visible = true;
btnSubmit.Visible = false;
btnCancel.Visible = true;
txtPackageNo.Text = objEnt.PackageNumber;
txtPackageName.Text = objEnt.PackageName;
if (objEnt.StartDate != null)
{
if (objEnt.StartDate != "")
{
DateTime dtstartdate = DateTime.Parse(objEnt.StartDate);
txtStartDate.Text = dtstartdate.ToString(clsConstant.DATE_FORMAT);
}
}
else
{
txtStartDate.Text = "";
}
if (objEnt.EndDate != null)
{
if (objEnt.EndDate != "")
{
DateTime dtenddate = DateTime.Parse(objEnt.EndDate);
txtEndDate.Text = dtenddate.ToString(clsConstant.DATE_FORMAT);
}
}
//Binding loannumber to the dropdown control.
drpLoanNumber.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_LOAN, null);
drpLoanNumber.DataTextField = "DisplayFieldText";
drpLoanNumber.DataValueField = "ValueFieldText";
drpLoanNumber.DataBind();
drpLoanNumber.Items.FindByValue(objEnt.LoanID.ToString()).Selected = true;
}
else
{
btnSubmit.Visible = true;
btnUpdate.Visible = false;
}
}
}
else
{
if (!IsPostBack)
{
if (Utility.CheckAccess("PackageDetailsAddEdit") == false)
{
pnlInvalid.Visible = true;
MainDiv.Visible = false;
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
this.MakeReadOnly(this.Controls);
}
btnUpdate.Visible = false;
drpLoanNumber.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_LOAN, null);
drpLoanNumber.DataTextField = "DisplayFieldText";
drpLoanNumber.DataValueField = "ValueFieldText";
drpLoanNumber.DataBind();
txtStartDate.Text = DateTime.Now.Date.ToString(clsConstant.DATE_FORMAT);
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
