public void loadEnterpriseDetails()
{
try
{
LoanDSTableAdapters.EnterpriseDetailsTableAdapter entDetails = new LoanDSTableAdapters.EnterpriseDetailsTableAdapter();
LoanDS.EnterpriseDetailsDataTable tblEntDetails = entDetails.GetEnterpriseDetails(MySessionManager.ClientID, MySessionManager.AppID);
if (tblEntDetails.Rows.Count > 0)
{
txtEntName.Value = tblEntDetails[0].datEnterpriseName.ToString();
txtPhysicalAddress.Value = tblEntDetails[0].datPhysicalAddress.ToString();
txtRegDate.Text = tblEntDetails[0].datRegistrationDate.ToShortDateString();
txtRegNo.Value = tblEntDetails[0].datRegistrationNumber.ToString();
txtTelephoneNo.Text = tblEntDetails[0].datTelephoneNumber.ToString();
txtFaxNo.Text = tblEntDetails[0].datFaxNumber.ToString();
txtActivity.Text = tblEntDetails[0].datActivity.ToString();
txtDateOfOccupancy.Text = tblEntDetails[0].datOccupancy.ToShortDateString();
if (tblEntDetails[0].IsdatSectorNull() == false) { ddlSector.SelectedValue = tblEntDetails[0].datSector.ToString(); }
if (tblEntDetails[0].IsdatPremisesNull() == false) { ddlEnterprisePremStatus.SelectedValue = tblEntDetails[0].datPremises.ToString(); }
}
}
catch(Exception ex)
{ }
}
public void loadEnterpriseDetails()
{
try
{
LoanDSTableAdapters.EnterpriseDetailsTableAdapter entDetails = new LoanDSTableAdapters.EnterpriseDetailsTableAdapter();
LoanDS.EnterpriseDetailsDataTable tblEntDetails = entDetails.GetEnterpriseDetails(MySessionManager.ClientID, MySessionManager.AppID);
if (tblEntDetails.Rows.Count > 0)
{
txtEntName.Value = tblEntDetails[0].datEnterpriseName.ToString();
txtPhysicalAddress.Value = tblEntDetails[0].datPhysicalAddress.ToString();
txtRegDate.Text = tblEntDetails[0].datRegistrationDate.ToShortDateString();
txtRegNo.Value = tblEntDetails[0].datRegistrationNumber.ToString();
txtTelephoneNo.Text = tblEntDetails[0].datTelephoneNumber.ToString();
txtFaxNo.Text = tblEntDetails[0].datFaxNumber.ToString();
txtActivity.Text = tblEntDetails[0].datActivity.ToString();
txtDateOfOccupancy.Text = tblEntDetails[0].datOccupancy.ToShortDateString();
if (tblEntDetails[0].IsdatSectorNull() == false)
{
ddlSector.SelectedValue = tblEntDetails[0].datSector.ToString();
}
if (tblEntDetails[0].IsdatPremisesNull() == false)
{
ddlEnterprisePremStatus.SelectedValue = tblEntDetails[0].datPremises.ToString();
}
}
}
catch (Exception ex)
{ }
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
LoanDSTableAdapters.EnterpriseDetailsTableAdapter enterprisedetails = new LoanDSTableAdapters.EnterpriseDetailsTableAdapter();
enterprisedetails.InsertEnterpriseDetails(MySessionManager.AppID,
MySessionManager.ClientID,
txtEntName.Value,
txtTelephoneNo.Text,
txtFaxNo.Text,
txtPhysicalAddress.Value,
txtActivity.Text,
DateTime.Parse(txtRegDate.Text),
txtRegNo.Value,
Convert.ToInt32(ddlEnterprisePremStatus.Text),
DateTime.Parse(txtDateOfOccupancy.Text),
Convert.ToInt32(ddlSector.Text)
);
}
catch { }
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
LoanDSTableAdapters.EnterpriseDetailsTableAdapter enterprisedetails = new LoanDSTableAdapters.EnterpriseDetailsTableAdapter();
enterprisedetails.InsertEnterpriseDetails(MySessionManager.AppID,
MySessionManager.ClientID,
txtEntName.Value,
txtTelephoneNo.Text,
txtFaxNo.Text,
txtPhysicalAddress.Value,
txtActivity.Text,
DateTime.Parse(txtRegDate.Text),
txtRegNo.Value,
Convert.ToInt32(ddlEnterprisePremStatus.Text),
DateTime.Parse(txtDateOfOccupancy.Text),
Convert.ToInt32(ddlSector.Text)
);
}
catch { }
}
}
