protected void gridCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Allotte") { long id; Int64.TryParse(e.CommandArgument.ToString(), out id); var gridRow = ((LinkButton)e.CommandSource).NamingContainer as GridViewRow; HiddenField hidApplicationId = gridRow.FindControl("hidApplicationId") as HiddenField; //AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Allotted); Response.Redirect("~/admin/Allottee.aspx?appid=" + hidApplicationId.Value + "&ChangeRequestID=" + id + "&returnurl=admin/ViewChangeRequest.aspx"); } else if (e.CommandName == "Withdraw") { long id; Int64.TryParse(e.CommandArgument.ToString(), out id); DataClassesDataContext dataContext = new DataClassesDataContext(); var requests = from request in dataContext.tblChangeRequests where request.Id == id select request; tblChangeRequest tblreject = requests.FirstOrDefault(); if (tblreject != null) { //Added on January 24,2017 tblAllottee allottee = Allottee.GetAllotteeByAAN(tblreject.AAN); Quarters.UpdateQuarterStatus(allottee.QuarterNumber, QuarterStatus.Vacant); //update allottee //Reset the quarter to previous one at the time of change request allottee.QuarterNumber = tblreject.QuarterNumber; Allottee.Update(allottee); //Added on January 24,2017 end dataContext.tblChangeRequests.DeleteOnSubmit(tblreject); dataContext.SubmitChanges(); } BindGrid(); AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.rejected); //Quarters.UpdateQuarterStatus(tblreject.QuarterNumber, QuarterStatus.Vacant); //Commented on Dec 12,2016 purposely } else if (e.CommandName == "Possesed") { var gridRow = ((LinkButton)e.CommandSource).NamingContainer as GridViewRow; LinkButton lnkAllotte = gridRow.FindControl("lnkAllotte") as LinkButton; hdnChangeRequestId.Value = lnkAllotte.CommandArgument; hdnSelected.Value = e.CommandArgument.ToString(); tblAllottee _allotte = Allottee.getAllotteByApplicationid(Convert.ToInt64(e.CommandArgument)); txtName.Text = AllotementApplications.GetApplication(Convert.ToInt64(e.CommandArgument)).tblUser.fullName; if (_allotte != null) { txtQuarternumber.Text = _allotte.QuarterNumber; } pop.Show(); } }
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); }
protected void btnadd_Click(object sender, EventArgs e) { 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 select _requested; if (_alreadyRequested.FirstOrDefault() != null) { empty(); lblmessage.Text = "You have already submitted request!"; lblmessage.Visible = true; return; } tblChangeRequest changeRequest = new tblChangeRequest(); changeRequest.AAN = aan; changeRequest.FirstPerference = drpFirstPerference.SelectedValue; if (drpsecondPerference.SelectedValue == "-1") { changeRequest.SecondPerference = string.Empty; } else { changeRequest.SecondPerference = drpsecondPerference.SelectedValue; } if (drpThirdPerference.SelectedValue == "-1") { changeRequest.ThirdPerference = string.Empty; } else { changeRequest.ThirdPerference = drpThirdPerference.SelectedValue; } //changeRequest.SecondPerference = drpsecondPerference.SelectedValue; //changeRequest.ThirdPerference = drpThirdPerference.SelectedValue; changeRequest.QuarterCategory = Convert.ToInt32(drpQuarterCategory.SelectedValue); changeRequest.QuarterNumber = drpAllotedQuarter.SelectedValue; changeRequest.Name = txtUsername.Text; changeRequest.dateofsubmission = DateTime.Now; dataContext.tblChangeRequests.InsertOnSubmit(changeRequest); dataContext.SubmitChanges(); empty(); lblmessage.Text = "Information has been saved sucessfully!"; lblmessage.Visible = true; }
private void BindRequestData() { DataClassesDataContext datacontext = new DataClassesDataContext(); var changeReuest = from request in datacontext.tblChangeRequests where request.Id == changeReuestId select request; tblChangeRequest _request = changeReuest.FirstOrDefault(); tblUser user = Users.getUserByAAN(_request.AAN); drpOffice.SelectedValue = user.BaseOfficeId.ToString(); drpQuarterCatergory.SelectedValue = _request.QuarterCategory.ToString(); if (user.DateOfRetirement.HasValue) { txtDor.Text = user.DateOfRetirement.Value.ToShortDateString(); } if (user.DateOfJoining.HasValue) { txtDoj.Text = user.DateOfJoining.Value.ToShortDateString(); } txtAllotteeName.Text = user.AAN; bindQuarter(); drpQuarterCatergory.Enabled = false; drpOffice.Enabled = false; drpDesignation.Enabled = false; }
protected void btnSave_Click(object sender, EventArgs e) { //Save change request 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 select _requested; if (_alreadyRequested.FirstOrDefault() != null) { lblStatus.Text = "You have already submitted a change request!"; return; } string firstPreferrence = string.Empty; string secondPreference = string.Empty; string thirdPreference = string.Empty; foreach (GridViewRow row in grdQuarters.Rows) { RadioButton radPriority1 = row.FindControl("radPriority1") as RadioButton; RadioButton radPriority2 = row.FindControl("radPriority2") as RadioButton; RadioButton radPriority3 = row.FindControl("radPriority3") as RadioButton; if (firstPreferrence == string.Empty && radPriority1.Checked) { firstPreferrence = ((Label)row.FindControl("lblQuarterNumber")).Text; } if (secondPreference == string.Empty && radPriority2.Checked) { secondPreference = ((Label)row.FindControl("lblQuarterNumber")).Text; } if (thirdPreference == string.Empty && radPriority3.Checked) { thirdPreference = ((Label)row.FindControl("lblQuarterNumber")).Text; } } if (string.IsNullOrEmpty(firstPreferrence) && string.IsNullOrEmpty(secondPreference) && string.IsNullOrEmpty(thirdPreference)) { lblStatus.Text = "Please select a valid preference."; return; } tblChangeRequest changeRequest = new tblChangeRequest(); changeRequest.AAN = aan; changeRequest.FirstPerference = firstPreferrence; if (string.IsNullOrEmpty(secondPreference)) { changeRequest.SecondPerference = string.Empty; } else { changeRequest.SecondPerference = secondPreference; } if (string.IsNullOrEmpty(thirdPreference)) { changeRequest.ThirdPerference = string.Empty; } else { changeRequest.ThirdPerference = thirdPreference; } changeRequest.QuarterCategory = Convert.ToInt32(categoryId); changeRequest.QuarterNumber = lblAllottedQuarter.Text; changeRequest.Name = lblFullname.Text; changeRequest.dateofsubmission = DateTime.Now; dataContext.tblChangeRequests.InsertOnSubmit(changeRequest); dataContext.SubmitChanges(); Response.Redirect("~/user/confirmation.aspx"); }
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; } }