public static List <AllotementApplication> GetAllotedUsers(ApplicationStatus status, long categoryId) { DataClassesDataContext dataContext = new DataClassesDataContext(); var applications = dataContext.uspGetAllotedUsers(Convert.ToInt32(status), Convert.ToInt32(categoryId)); List <AllotementApplication> allotements = new List <AllotementApplication>(); foreach (var application in applications) { AllotementApplication obj = new AllotementApplication(); obj.Id = application.ID; obj.Status = (ApplicationStatus)application.Status; obj.AAN = application.AAN; obj.Dept = application.OfficeName; obj.AlreadyAllottedQuarter = application.OtherQuarterNumber; obj.GradePay = GradePay.GetPayGradesById(Convert.ToInt64(application.GradePay)); obj.Designation = application.DesignationName; obj.UserName = application.fullName; obj.QuarterType = application.QuarterCategoryName; obj.Cast = application.Cast; obj.QuarterNumber = application.QuarterNumber; obj.DateOfAllottment = application.DateOfAllotement.HasValue ? application.DateOfAllotement.Value : DateTime.Now; if (application.DateOfjoining.HasValue) { obj.dateOfJoining = application.DateOfjoining.Value; } allotements.Add(obj); } return(allotements); }
public static List <AllotementApplication> GetPendingAndVerifiedApplications(long categoryId) { DataClassesDataContext dataContext = new DataClassesDataContext(); var applications = (from application in dataContext.tbAllotmentApplications where (application.Status == Convert.ToInt32(ApplicationStatus.Verified) || application.Status == Convert.ToInt32(ApplicationStatus.Pending)) && application.QuarterCategory == categoryId select application).OrderBy(x => x.DateOfjoining); List <AllotementApplication> allotements = new List <AllotementApplication>(); foreach (var application in applications) { AllotementApplication obj = new AllotementApplication(); obj.Id = application.ID; obj.Status = (ApplicationStatus)application.Status; obj.AAN = application.tblUser.AAN; obj.Dept = application.tblOffice.Name; obj.AlreadyAllottedQuarter = application.OtherQuarterNumber; obj.GradePay = GradePay.GetPayGradesById(Convert.ToInt64(application.GradePay)); obj.Designation = application.tblDesignation.Name; obj.UserName = application.tblUser.fullName; obj.QuarterType = application.tblQuarterCategory.Name; obj.Cast = application.Cast; if (application.tblUser.DateOfJoining.HasValue) { obj.dateOfJoining = application.tblUser.DateOfJoining.Value; } allotements.Add(obj); } return(allotements); }
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(); } }