protected void GridRowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Verify")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
Response.Redirect(string.Format("~/user/submission.aspx?applicationid={0}&returnurl=admin/verification.aspx&verify=true", id));
}
if (e.CommandName == "view")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
Response.Redirect(string.Format("~/user/submission.aspx?applicationid={0}&returnurl=admin/verification.aspx", id));
}
if (e.CommandName == "reject")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
tbAllotmentApplication application = AllotementApplications.GetApplication(id);
application.Status = (int)ApplicationStatus.rejected;
AllotementApplications.SaveApplications(application);
lblMessage.Text = "Application has been rejected sucessfully!";
lblMessage.Visible = true;
BindData();
}
}
private void possession()
{
long id;
Int64.TryParse(hdnSelected.Value, out id);
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Pos);
tbAllotmentApplication app = AllotementApplications.GetApplication(id);
tblAllottee _allotte = Allottee.getAllotteByApplicationid(id);
if (_allotte != null)
{
DateTime _dateofPossession;
DateTime.TryParse(txtDateOfPossession.Text, out _dateofPossession);
_allotte.Status = (int)AllotementStatus.Possessed;
_allotte.DateOfPossession = _dateofPossession;
Allottee.Update(_allotte);
}
tbluserhistory _userhistory = new tbluserhistory();
_userhistory.Action = "Possession";
_userhistory.description = _user.Username + " has marked possesed application with " + id;
_userhistory.time = DateTime.Now;
_userhistory.useraan = _user.AAN;
userHistory.Save(_userhistory);
}
public static tbAllotmentApplication updateApplications(tbAllotmentApplication application)
{
DataClassesDataContext dataContext = new DataClassesDataContext();
//dataContext.tbAllotmentApplications.InsertOnSubmit(application);
dataContext.SubmitChanges();
return(application);
}
private void possession()
{
long id;
Int64.TryParse(hdnSelected.Value, out id);
long changeRequestId;
Int64.TryParse(hdnChangeRequestId.Value, out changeRequestId);
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Pos);
tbAllotmentApplication app = AllotementApplications.GetApplication(id);
tblAllottee _allotte = Allottee.getAllotteByApplicationid(id);
if (_allotte != null)
{
DateTime _dateofPossession;
DateTime.TryParse(txtDateOfPossession.Text, out _dateofPossession);
_allotte.Status = (int)AllotementStatus.Possessed;
_allotte.DateOfPossession = _dateofPossession;
Allottee.Update(_allotte);
}
if (id > 0)
{
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Pos);
}
DataClassesDataContext dataContext = new DataClassesDataContext();
var requests = from request in dataContext.tblChangeRequests where request.Id == changeRequestId select request;
/*tblChangeRequest tblDelete = requests.FirstOrDefault();
* if (tblDelete != null)
* {
* dataContext.tblChangeRequests.DeleteOnSubmit(tblDelete);
* dataContext.SubmitChanges();
* } //Finally deleting the change request changed on 02-06-2016*/
tblChangeRequest tblUpdate = requests.FirstOrDefault();
if (tblUpdate != null)
{
tblUpdate.Status = (int)ChangeRequestStatus.Approved;
dataContext.SubmitChanges(); //Updating the status of request to approved
}
tbluserhistory _userhistory = new tbluserhistory();
_userhistory.Action = "Possession";
_userhistory.description = _user.Username + " has marked possesed application with " + id;
_userhistory.time = DateTime.Now;
_userhistory.useraan = _user.AAN;
userHistory.Save(_userhistory);
}
public static void UpdateApplicationStaus(long id, ApplicationStatus status)
{
DataClassesDataContext dataContext = new DataClassesDataContext();
var applications = from application in dataContext.tbAllotmentApplications where application.ID == id select application;
tbAllotmentApplication updateApplication = applications.FirstOrDefault();
if (updateApplication != null)
{
updateApplication.Status = (int)status;
}
dataContext.SubmitChanges();
}
private void BindApplicationData()
{
tbAllotmentApplication appication = AllotementApplications.GetApplication(applicationid);
tblUser user = Users.getUserByAAN(appication.tblUser.AAN);
drpOffice.SelectedValue = user.BaseOfficeId.ToString();
drpQuarterCatergory.SelectedValue = appication.QuarterCategory.ToString();
txtDor.Text = user.DateOfRetirement.Value.ToShortDateString();
txtDoj.Text = user.DateOfJoining.Value.ToShortDateString();
txtAllotteeName.Text = user.AAN;
bindQuarter();
drpQuarterCatergory.Enabled = false;
drpOffice.Enabled = false;
drpDesignation.Enabled = false;
}
protected void btnApplyNew_Click(object sender, EventArgs e)
{
tbAllotmentApplication application = AllotementApplications.GetApplication(Convert.ToInt64(applicationId));
if (application.Status == (int)ApplicationStatus.Verified)
{
lblStatus.Text = "You have already applied for the new allotment application, and your application is under process.";
}
else if (application.Status == (int)ApplicationStatus.Pending ||
application.Status == (int)ApplicationStatus.withdraw) //added on 30.12.2016 as per request from amrinder
{
//Change application status to verified
AllotementApplications.UpdateApplicationStaus(Convert.ToInt64(applicationId), ApplicationStatus.Verified);
lblStatus.Text = "Your application request is processed further, thanks for your application";
Response.Redirect("~/user/confirmation.aspx");
}
}
public static tbAllotmentApplication SaveApplications(tbAllotmentApplication application)
{
DataClassesDataContext dataContext = new DataClassesDataContext();
if (application.ID <= 0)
{
dataContext.tbAllotmentApplications.InsertOnSubmit(application);
}
else
{
var _tempapplication = from temp in dataContext.tbAllotmentApplications where temp.ID == application.ID select temp;
tbAllotmentApplication _application = _tempapplication.FirstOrDefault();
_application.DateOfBirth = application.DateOfBirth;
_application.DateOfjoining = application.DateOfjoining;
_application.GradePay = application.GradePay;
_application.Name = application.Name;
_application.Designation = application.Designation;
_application.OfficeId = application.OfficeId;
_application.OtherQuarterAddress = application.OtherQuarterAddress;
_application.OtherQuarterNumber = application.OtherQuarterNumber;
_application.JobType = application.JobType;
_application.Sex = application.Sex;
_application.Status = application.Status;
_application.Cast = application.Cast;
_application.IsSublet = application.IsSublet;
_application.IsDebarred = application.IsDebarred;
_application.QuarterCategory = application.QuarterCategory;
_application.ContactNumber = application.ContactNumber;
_application.MedicalCategory = application.MedicalCategory;
if (_application.IsDebarred.HasValue && _application.IsDebarred.Value)
{
_application.DebarredDate = application.DebarredDate;
}
_application.IsOtherAccomendation = application.IsOtherAccomendation;
if (_application.IsOtherAccomendation.HasValue && _application.IsOtherAccomendation.Value)
{
_application.OtherAllotteName = application.OtherAllotteName;
_application.OtherQuarterAddress = application.OtherQuarterAddress;
_application.OtherQuarterNumber = application.OtherQuarterNumber;
}
}
dataContext.SubmitChanges();
return(application);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["applicationId"] == null)
{
Response.Redirect("~/user/application.aspx");
}
else if (Request["applicationId"] != null)
{
applicationId = Convert.ToString(Request["applicationId"]);
}
tbAllotmentApplication application = AllotementApplications.GetApplication(Convert.ToInt64(applicationId));
categoryId = application.QuarterCategory.Value;
if (!Page.IsPostBack)
{
tblUser user = Users.getUser(application.Userid.Value);
DateTime?dt = null;
//Check if user is debarred or deferred
if (Users.IsUserDeferred(user.Id, out dt))
{
Response.Redirect("~/user/notallowed.aspx");
}
if (Users.IsUserDebarred(user.Id, out dt))
{
Response.Redirect("~/user/notallowed.aspx?debar=true");
}
lblFullname.Text = user.fullName;
lblDesignation.Text = Users.GetUserDesignation(user.Id);
lblAllottedQuarter.Text = "N/A";
var allottee = Allottee.GetAllotteeByAAN(user.AAN);
if (allottee != null && (allottee.Status.Value == ((int)AllotementStatus.Possessed) || allottee.Status.Value == ((int)AllotementStatus.ChangeRequested)))
{
string allottedQuarter = allottee.QuarterNumber;
lblAllottedQuarter.Text = allottedQuarter;
}
if (application.QuarterCategory.HasValue && !Quarters.IsQuarterCategoryActive(application.QuarterCategory.Value))
{
submissionClosedPanel.Visible = true;
return;
}
else
{
//Quarter category is active
if (lblAllottedQuarter.Text == "N/A" || application.Status == (int)ApplicationStatus.Pending) //New allottment cases
{
if (application.MedicalCategory.HasValue && application.MedicalCategory.Value >= 0) //Medical grounds
{
applyForQuarterMedicalGroundsPanel.Visible = true;
btnNewAllottmentMedical.Enabled = true;
}
else
{
applyForQuarterPanel.Visible = true;
btnNewAllottment.Enabled = true;
}
}
else
{
if (application.MedicalCategory.HasValue && application.MedicalCategory.Value >= 0) //Medical grounds
{
applyForQuarterMedicalGroundsPanel.Visible = true;
btnChangeRequestMedical.Enabled = true;
}
else
{
applyForQuarterPanel.Visible = true;
btnChangeRequest.Enabled = true;
}
}
DataClassesDataContext dataContext = new DataClassesDataContext();
string aan = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).AAN;
var _alreadyRequested = from _requested in dataContext.tblChangeRequests
where _requested.AAN == aan &&
(_requested.Status == (int)ChangeRequestStatus.Pending ||
_requested.Status == (int)ChangeRequestStatus.Approved)
select _requested;
if (_alreadyRequested.FirstOrDefault() != null)
{
var changeRequest = _alreadyRequested.FirstOrDefault();
pnlChangeRequestInformation.Visible = true;
btnChangeRequest.Enabled = false;
btnChangeRequestMedical.Enabled = false;
lblRequestID.Text = changeRequest.Id.ToString();
lblFirstPreference.Text = changeRequest.FirstPerference ?? "N/A";
lblSecondPreference.Text = changeRequest.SecondPerference ?? "N/A";
lblThirdPreference.Text = changeRequest.ThirdPerference ?? "N/A";
}
else
{
pnlChangeRequestInformation.Visible = false;
}
}
BindData();
}
changeRequests = new DataClassesDataContext().tblChangeRequests.ToList();
grdQuarters.RowDataBound += new GridViewRowEventHandler(grdQuarters_RowDataBound);
}
private void BindApplicationData()
{
tbAllotmentApplication application = AllotementApplications.GetApplication(applicationid);
if (application != null)
{
//DateTime DateOfBirth, DateOfjoining, DateOfDebared, dateofret;
//DateTime.TryParse(txtDob.Text, out DateOfBirth);
//DateTime.TryParse(txtEmployedfrom.Text, out DateOfjoining);
//DateTime.TryParse(txtDateOfRetirement.Text, out dateofret);
lblGradePay.Text = GradePay.GetPayGradesById(Convert.ToInt64(application.GradePay));
txtUsername.Text = application.Name;
if (application.Designation.HasValue)
{
lbldesignations.Text = Allottee.GetDesignationName(application.Designation.Value).ToString();
}
if (application.OfficeId.HasValue)
{
lblOffice.Text = Offices.GetOfficeName(application.OfficeId.Value).ToString();
}
txtAuditAddress.Text = application.OtherQuarterAddress;
txtQuartertype.Text = application.OtherQuarterNumber;
txtContactNumber.Text = application.ContactNumber;
if (application.JobType.Value == 0)
{
drpJobType.Text = "Permanent";
}
else
{
drpJobType.Text = "Temporary";
}
if (application.Sex.Value == 0)
{
lblSex.Text = "Female";
}
else
{
lblSex.Text = "Male";
}
tblUser _user = Users.getUser(application.Userid.Value);
if (application.DateOfBirth.HasValue)
{
txtDob.Text = application.DateOfBirth.Value.ToShortDateString();
}
lblcategory.Text = application.Cast;
if (_user.DateOfJoining.HasValue)
{
txtEmployedfrom.Text = _user.DateOfJoining.Value.ToShortDateString();
}
if (_user.DateOfRetirement.HasValue)
{
txtDateOfRetirement.Text = _user.DateOfRetirement.Value.ToShortDateString();
}
//_user.DateOfJoining = DateOfjoining;
//_user.DateOfRetirement = dateofret;
if (application.IsSublet.HasValue)
{
isSubletTrue.Checked = application.IsSublet.Value;
}
if (!isSubletTrue.Checked)
{
lblSublet.Text = "Yes";
isSubletFalse.Checked = true;
}
else
{
lblSublet.Text = "No";
}
if (application.IsDebarred.HasValue)
{
isDebarred.Checked = application.IsDebarred.Value;
}
if (application.QuarterCategory.HasValue)
{
lblQuarterCategory.Text = Quarters.GetQuarterCategoryName(application.QuarterCategory.Value).ToString();
}
if (isDebarred.Checked)
{
lblDebarred.Text = "Yes";
if (application.DebarredDate.HasValue)
{
txtDebaredDate.Text = application.DebarredDate.Value.ToShortDateString();
}
Page.ClientScript.RegisterStartupScript(Page.GetType(), "showdebarred", "showbarredDate(1);", true);
}
else
{
lblDebarred.Text = "No";
isDebarredNO.Checked = true;
}
if (application.IsOtherAccomendation.HasValue)
{
isauditpooyes.Checked = application.IsOtherAccomendation.Value;
}
if (!isauditpooyes.Checked)
{
lblauditpooyes.Text = "No";
isauditpoono.Checked = true;
}
else
{
lblauditpooyes.Text = "Yes";
txtAuditAllotteName.Text = application.OtherAllotteName;
txtAuditAddress.Text = application.OtherQuarterAddress;
txtQuartertype.Text = application.OtherQuarterNumber;
Page.ClientScript.RegisterStartupScript(Page.GetType(), "showaudit", "showAudit(1);", true);
}
grdmembers.DataSource = Tblmemberinfo.GetMemberinfo(application.ID);
grdmembers.DataBind();
}
}
private void BindApplicationData()
{
tbAllotmentApplication application = AllotementApplications.GetApplication(applicationid);
if (application != null)
{
//DateTime DateOfBirth, DateOfjoining, DateOfDebared, dateofret;
//DateTime.TryParse(txtDob.Text, out DateOfBirth);
//DateTime.TryParse(txtEmployedfrom.Text, out DateOfjoining);
//DateTime.TryParse(txtDateOfRetirement.Text, out dateofret);
drpGradePay.SelectedValue = application.GradePay;
txtUsername.Text = application.Name;
if (application.Designation.HasValue)
{
drpdesignations.SelectedValue = application.Designation.Value.ToString();
}
if (application.OfficeId.HasValue)
{
drpOffice.SelectedValue = application.OfficeId.Value.ToString();
}
txtAuditAddress.Text = application.OtherQuarterAddress;
txtQuartertype.SelectedValue = Convert.ToString(application.OtherQuarterType);
drpAllotedQuarter.SelectedValue = application.OtherQuarterNumber;
if (application.JobType.HasValue)
{
drpJobType.SelectedValue = application.JobType.Value.ToString();
}
drpSex.SelectedValue = application.Sex.ToString();
ddlMedicalCategory.SelectedValue = application.MedicalCategory.ToString();
txtContactNumber.Text = application.ContactNumber;
//application.Status = 0;
//application.Userid = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).Id;
tblUser _user = Users.getUser(application.Userid.Value);
if (application.DateOfBirth.HasValue)
{
txtDob.Text = application.DateOfBirth.Value.ToShortDateString();
}
//txtPayBand.Text = application.QuarterNumber;
foreach (ListItem ino in drpcategory.Items)
{
if (!string.IsNullOrEmpty(application.Cast) && ino.Text.ToLower() == application.Cast.ToLower())
{
ino.Selected = true;
}
}
if (_user.DateOfJoining.HasValue)
{
txtEmployedfrom.Text = _user.DateOfJoining.Value.ToShortDateString();
}
if (_user.DateOfRetirement.HasValue)
{
txtDateOfRetirement.Text = _user.DateOfRetirement.Value.ToShortDateString();
}
txtAAN.Text = _user.AAN;
txtEmailAddress.Text = _user.EmailID;
txtPUCDACode.Text = _user.EmployeeCode;
txtAadharNumber.Text = _user.AadharNumber;
txtPAN.Text = _user.PanNumber;
//_user.DateOfJoining = DateOfjoining;
//_user.DateOfRetirement = dateofret;
if (application.IsSublet.HasValue)
{
isSubletTrue.Checked = application.IsSublet.Value;
}
if (!isSubletTrue.Checked)
{
isSubletFalse.Checked = true;
}
if (application.IsDebarred.HasValue)
{
isDebarred.Checked = application.IsDebarred.Value;
}
if (application.QuarterCategory.HasValue)
{
drpQuarterCategory.SelectedValue = application.QuarterCategory.Value.ToString();
}
if (isDebarred.Checked)
{
if (application.DebarredDate.HasValue)
{
txtDebaredDate.Text = application.DebarredDate.Value.ToShortDateString();
}
Page.ClientScript.RegisterStartupScript(Page.GetType(), "showdebarred", "showbarredDate(1);", true);
}
else
{
isDebarredNO.Checked = true;
}
if (application.IsOtherAccomendation.HasValue)
{
isauditpooyes.Checked = application.IsOtherAccomendation.Value;
}
if (!isauditpooyes.Checked)
{
isauditpoono.Checked = true;
}
else
{
txtAuditAllotteName.Text = application.OtherAllotteName;
txtAuditAddress.Text = application.OtherQuarterAddress;
txtQuartertype.SelectedValue = Convert.ToString(application.OtherQuarterType);
drpAllotedQuarter.SelectedValue = application.OtherQuarterNumber;
Page.ClientScript.RegisterStartupScript(Page.GetType(), "showaudit", "showAudit(1);", true);
}
grdmembers.DataSource = Tblmemberinfo.GetMemberinfo(application.ID);
grdmembers.DataBind();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (chkDeclaration.Checked == true)
{
validatedeclaration.Visible = false;
tbAllotmentApplication application;
if (applicationid <= 0)
{
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/submissionVerfication.xml"));
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
if (!Convert.ToBoolean(dt.Rows[0][0]))
{
lblmessage.Text = "Application submission has been closed";
lblmessage.Visible = true;
return;
}
}
application = AllotementApplications.GetApplication(applicationid);
if (application == null)
{
application = new tbAllotmentApplication();
application.SubmissionDate = DateTime.Now;
}
else
{
lblmessage.Text = "Only one application can be submitted!";
lblmessage.Visible = true;
return;
}
}
else
{
application = AllotementApplications.GetApplication(applicationid);
}
DateTime DateOfBirth, DateOfjoining, DateOfDebared, dateofret;
DateTime.TryParse(txtDob.Text, out DateOfBirth);
DateTime.TryParse(txtEmployedfrom.Text, out DateOfjoining);
DateTime.TryParse(txtDateOfRetirement.Text, out dateofret);
application.DateOfBirth = DateOfBirth;
application.DateOfjoining = DateOfjoining;
application.GradePay = drpGradePay.SelectedValue;
application.Name = txtUsername.Text;
application.Designation = Convert.ToInt64(drpdesignations.SelectedValue);
application.OfficeId = Convert.ToInt32(drpOffice.SelectedValue);
application.OtherQuarterAddress = txtAuditAddress.Text;
if ((txtQuartertype.SelectedValue != null) && (txtQuartertype.SelectedValue != "-1") && (txtQuartertype.SelectedValue != ""))
{
application.OtherQuarterType = Convert.ToInt32(txtQuartertype.SelectedValue);
}
application.MedicalCategory = Convert.ToInt32(ddlMedicalCategory.SelectedValue);
application.OtherQuarterNumber = drpAllotedQuarter.SelectedValue;
application.JobType = Convert.ToInt32(drpJobType.SelectedValue);
application.Sex = Convert.ToInt32(drpSex.SelectedValue);
//application.Status = 0;
application.ContactNumber = txtContactNumber.Text;
//if (applicationid <= 0)
{
//application.Userid = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).Id;
tblUser user = Users.getUser(application.Userid.Value);
//user.Username = txtUsername.Text;
user.EmailID = txtEmailAddress.Text;
user.fullName = txtUsername.Text;
user.BaseOfficeId = Convert.ToInt32(drpOffice.SelectedValue);
user.Roleid = 4;//by default viewer role
user.designation = Convert.ToInt64(drpdesignations.SelectedValue);
user.EmployeeCode = txtPUCDACode.Text;
user.AadharNumber = txtAadharNumber.Text.Trim();
user.PanNumber = txtPAN.Text.Trim();
//application.Userid = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).Id;
//tblUser _user = Users.getUserByUserName(HttpContext.Current.User.Identity.Name);
user.DateOfJoining = DateOfjoining;
user.DateOfRetirement = dateofret;
Users.SaveUser(user);
}
//else
//{
//}
application.Cast = drpcategory.SelectedItem.Text;
application.IsSublet = isSubletTrue.Checked;
application.IsDebarred = isDebarred.Checked;
//int quarterCategoryId = Convert.ToInt32(drpQuarterCategory.SelectedValue);
long quarterCategoryId = GradePay.GetQuarterCategoryByGradePay(Convert.ToInt32(drpGradePay.SelectedValue));
if (application.QuarterCategory != quarterCategoryId) //Previous category is different than the new one
{
//Put status of the application under pending state again, to be reviewed further
application.Status = 0;
//Delete the change requests taken by the user if any to changerequested state
//And when user category is changed
tblUser user = Users.getUser(application.Userid.Value);
var dataContext = new DataClassesDataContext();
tblChangeRequest changeRequestToUpdate = dataContext.tblChangeRequests
.Where(x => x.AAN.ToLower() == user.AAN.ToLower() &&
(x.Status == (int)ChangeRequestStatus.Pending ||
x.Status == (int)ChangeRequestStatus.Approved)).FirstOrDefault();
if (changeRequestToUpdate != null)
{
//changeRequestToUpdate.Status = (int)ChangeRequestStatus.Done;
changeRequestToUpdate.Status = (int)ChangeRequestStatus.Pending;
//dataContext.tblChangeRequests.DeleteOnSubmit(changeRequestToDelete);
dataContext.SubmitChanges();
}
}
application.QuarterCategory = quarterCategoryId;
if (isDebarred.Checked)
{
DateTime.TryParse(txtDebaredDate.Text, out DateOfDebared);
application.DebarredDate = DateOfDebared;
}
application.IsOtherAccomendation = isauditpooyes.Checked;
if (isauditpooyes.Checked)
{
application.OtherAllotteName = txtAuditAllotteName.Text;
application.OtherQuarterAddress = txtAuditAddress.Text;
application.OtherQuarterType = Convert.ToInt32(txtQuartertype.SelectedValue);
application.OtherQuarterNumber = drpAllotedQuarter.SelectedValue;
}
if (!IsQuarterCategoryActive(quarterCategoryId))
{
lblmessage.Text = "The application cannot be saved, because specified category is not active";
lblmessage.Visible = true;
return;
}
application = AllotementApplications.SaveApplications(application);
if (Session["members"] != null)
{
List <tblMember> mem = (List <tblMember>)Session["members"];
foreach (tblMember meminfo in mem)
{
meminfo.ApplicationId = application.ID;
}
Tblmemberinfo.Save(mem);
Session["members"] = null;
}
lblmessage.Visible = true;
lblmessage.Text = "Information saved sucessfully";
Empty();
lblmessage.Font.Bold = true;
if (!string.IsNullOrEmpty(Request["returnurl"]))
{
Response.Redirect("~/" + Request["returnurl"]);
}
else
{
Response.Redirect("~/user/Confirmation.aspx");
}
}
else
{
validatedeclaration.Visible = true;
}
}
protected void btnadd_Click(object sender, EventArgs e)
{
if (chkDeclaration.Checked == true)
{
validatedeclaration.Visible = false;
tbAllotmentApplication application = new tbAllotmentApplication();
if (applicationid <= 0)
{
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/submissionVerfication.xml"));
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
if (!Convert.ToBoolean(dt.Rows[0][0]))
{
lblmessage.Text = "Application submission has been closed";
lblmessage.Visible = true;
return;
}
}
/*application = AllotementApplications.GetApplicationByAAN(Users.getUserByUserName(HttpContext.Current.User.Identity.Name).AAN);
* if (application == null)
* {
* application = new tbAllotmentApplication();
* application.SubmissionDate = DateTime.Now;
* }
* else
* {
* lblmessage.Text = "Only one application can be submitted!";
* lblmessage.Visible = true;
* return;
* }*/
}
else
{
application = AllotementApplications.GetApplication(applicationid);
}
DateTime DateOfBirth, DateOfjoining, DateOfDebared, dateofret;
DateTime.TryParse(txtDob.Text, out DateOfBirth);
DateTime.TryParse(txtEmployedfrom.Text, out DateOfjoining);
DateTime.TryParse(txtDateOfRetirement.Text, out dateofret);
application.DateOfBirth = DateOfBirth;
application.DateOfjoining = DateOfjoining;
application.GradePay = drpGradePay.SelectedValue;
application.Name = txtUsername.Text;
application.Designation = Convert.ToInt64(drpdesignations.SelectedValue);
application.OfficeId = Convert.ToInt32(drpOffice.SelectedValue);
application.OtherQuarterAddress = txtAuditAddress.Text;
if ((txtQuartertype.SelectedValue != null) && (txtQuartertype.SelectedValue != "-1") && (txtQuartertype.SelectedValue != ""))
{
application.OtherQuarterType = Convert.ToInt32(txtQuartertype.SelectedValue);
}
application.OtherQuarterNumber = drpAllotedQuarter.SelectedValue;
application.MedicalCategory = Convert.ToInt32(ddlMedicalCategory.SelectedValue);
application.JobType = Convert.ToInt32(drpJobType.SelectedValue);
application.Sex = Convert.ToInt32(drpSex.SelectedValue);
application.Status = 0;
application.ContactNumber = txtContactNumber.Text;
application.SubmissionDate = DateTime.Now;
if (applicationid <= 0)
{
tblUser user = new tblUser();
//user.Username = txtUsername.Text;
user.EmailID = txtEmailAddress.Text;
user.EmployeeCode = txtPUCDACode.Text;
user.IsPasswordChanged = false;
user.fullName = txtUsername.Text;
user.AAN = Offices.GetOfficeCode(Convert.ToInt32(drpOffice.SelectedValue)) + user.EmployeeCode;
user.Username = user.AAN;
user.Password = "******";
user.BaseOfficeId = Convert.ToInt32(drpOffice.SelectedValue);
user.Roleid = 4;//by default viewer role
user.designation = Convert.ToInt64(drpdesignations.SelectedValue);
user.bIsDeleted = false;
//application.Userid = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).Id;
//tblUser _user = Users.getUserByUserName(HttpContext.Current.User.Identity.Name);
user.DateOfJoining = DateOfjoining;
user.DateOfRetirement = dateofret;
user.AadharNumber = txtAadharNumber.Text.Trim();
user.PanNumber = txtPAN.Text.Trim();
var app = AllotementApplications.GetApplicationByAAN(user.AAN);
if (app != null)
{
lblmessage.Text = "Only one application can be submitted!";
lblmessage.Visible = true;
return;
}
Users.SaveUser(user);
string emailBody = "Your username/AAN = " + user.AAN + " and Password is " + user.Password;
try
{
SendmailMessage.SendMail(user.EmailID, "*****@*****.**", emailBody, "Account created");
}
catch (Exception ex)
{
}
//Send email here for user AAN and Password
//Send SMS
try
{
//new IntegratedMessageSender().SendMessage("NEW_USER", "Username:"******",Password:"******"The application cannot be saved, because specified category is not active";
lblmessage.Visible = true;
return;
}
application = AllotementApplications.SaveApplications(application);
if (Session["members"] != null)
{
List <tblMember> mem = (List <tblMember>)Session["members"];
foreach (tblMember meminfo in mem)
{
meminfo.ApplicationId = application.ID;
}
Tblmemberinfo.Save(mem);
Session["members"] = null;
}
lblmessage.Visible = true;
lblmessage.Text = "Information saved sucessfully";
Empty();
lblmessage.Font.Bold = true;
Response.Redirect("~/user/Confirmation.aspx");
}
else
{
validatedeclaration.Visible = true;
}
}
