protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
CultureInfo ukCulture = new CultureInfo("en-GB");
DateTime _dt = DateTime.Parse(txtbirthdate.Text, ukCulture);
DateTime _dt1 = DateTime.Parse(txtDateOfAppointment.Text, ukCulture);
try
{
LoanDSTableAdapters.OwnersTableAdapter tblOwners = new LoanDSTableAdapters.OwnersTableAdapter();
if (!(type == "update"))
{
tblOwners.InsertOwner(MySessionManager.ClientID,
MySessionManager.AppID,
txtfullname.Value.Trim(),
_dt,
txtAge.Text,
ddlNationality.Text,
txtcountryres.Value,
txtEducationalBackground.Value,
_dt1.ToShortDateString(),
Convert.ToInt32(ddlShord.Text),
txtpercentage.Value.Trim(),
MySessionManager.CurrentUser.UserID);
}
else if (type == "update")
{
tblOwners.UpdateOwner(MySessionManager.ClientID,
MySessionManager.AppID,
txtfullname.Value.Trim(),
_dt,
txtAge.Text,
ddlNationality.Text,
txtcountryres.Value,
txtEducationalBackground.Value,
_dt1.ToShortDateString(),
Convert.ToInt32(ddlShord.Text),
txtpercentage.Value.Trim(),
MySessionManager.CurrentUser.UserID,
id);
}
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "oedit"));
}
catch(Exception ex)
{ }
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
CultureInfo ukCulture = new CultureInfo("en-GB");
DateTime _dt = DateTime.Parse(txtbirthdate.Text, ukCulture);
DateTime _dt1 = DateTime.Parse(txtDateOfAppointment.Text, ukCulture);
try
{
LoanDSTableAdapters.OwnersTableAdapter tblOwners = new LoanDSTableAdapters.OwnersTableAdapter();
if (!(type == "update"))
{
tblOwners.InsertOwner(MySessionManager.ClientID,
MySessionManager.AppID,
txtfullname.Value.Trim(),
_dt,
txtAge.Text,
ddlNationality.Text,
txtcountryres.Value,
txtEducationalBackground.Value,
_dt1.ToShortDateString(),
Convert.ToInt32(ddlShord.Text),
txtpercentage.Value.Trim(),
MySessionManager.CurrentUser.UserID);
}
else if (type == "update")
{
tblOwners.UpdateOwner(MySessionManager.ClientID,
MySessionManager.AppID,
txtfullname.Value.Trim(),
_dt,
txtAge.Text,
ddlNationality.Text,
txtcountryres.Value,
txtEducationalBackground.Value,
_dt1.ToShortDateString(),
Convert.ToInt32(ddlShord.Text),
txtpercentage.Value.Trim(),
MySessionManager.CurrentUser.UserID,
id);
}
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "oedit"));
}
catch (Exception ex)
{ }
}
}
public void loadownership(int id)
{
LoanDSTableAdapters.OwnersTableAdapter owners = new LoanDSTableAdapters.OwnersTableAdapter();
LoanDS.OwnersDataTable tblowners = owners.GetOwnerDetails(id);
if (tblowners.Rows.Count > 0)
{
txtAge.Text = tblowners[0].datAge.ToString();
txtbirthdate.Text = tblowners[0].datDateOfBirth.ToString("dd-MM-yyyy");
txtcountryres.Value = tblowners[0].datResidence.ToString();
txtDateOfAppointment.Text = tblowners[0].datAppointment.ToString();
txtEducationalBackground.Value = tblowners[0].datEducation.ToString();
txtfullname.Value = tblowners[0].datFullName.ToString();
txtpercentage.Value = tblowners[0].datPercentage.ToString();
if (Convert.ToInt32(tblowners[0].datNationality) > 0)
{
ddlNationality.SelectedValue = tblowners[0].datNationality.ToString();
}
if (tblowners[0].datSHORD > 0)
{
ddlShord.SelectedValue = tblowners[0].datSHORD.ToString();
}
}
}
public void loadownership(int id)
{
LoanDSTableAdapters.OwnersTableAdapter owners = new LoanDSTableAdapters.OwnersTableAdapter();
LoanDS.OwnersDataTable tblowners = owners.GetOwnerDetails(id);
if (tblowners.Rows.Count > 0)
{
txtAge.Text = tblowners[0].datAge.ToString();
txtbirthdate.Text = tblowners[0].datDateOfBirth.ToString("dd-MM-yyyy");
txtcountryres.Value = tblowners[0].datResidence.ToString();
txtDateOfAppointment.Text = tblowners[0].datAppointment.ToString();
txtEducationalBackground.Value = tblowners[0].datEducation.ToString();
txtfullname.Value = tblowners[0].datFullName.ToString();
txtpercentage.Value = tblowners[0].datPercentage.ToString();
if(Convert.ToInt32(tblowners[0].datNationality)>0){ ddlNationality.SelectedValue = tblowners[0].datNationality.ToString();}
if (tblowners[0].datSHORD > 0) { ddlShord.SelectedValue = tblowners[0].datSHORD.ToString(); }
}
}
