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); }
protected void gridrowdatabound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { AllotementApplication _app = e.Row.DataItem as AllotementApplication; HyperLink hypprint = e.Row.FindControl("hypprint") as HyperLink; hypprint.NavigateUrl = "~/User/printapplication.aspx?applicationid=" + _app.Id; } }
public static List <AllotementApplication> GetPendingApplications(ApplicationStatus status, int baseofficeid) { DataClassesDataContext dataContext = new DataClassesDataContext(); var applications = (from application in dataContext.tbAllotmentApplications where (application.tblUser.BaseOfficeId.HasValue == false || application.tblUser.BaseOfficeId.Value == baseofficeid) && application.Status == Convert.ToInt32(status) 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.Designation = application.tblDesignation.Name; obj.UserName = application.tblUser.fullName; obj.QuarterType = application.tblQuarterCategory.Name; obj.Cast = application.Cast; allotements.Add(obj); } return(allotements); }
public static List <AllotementApplication> GetApplicationsByAAn(string AAN) { DataClassesDataContext dataContext = new DataClassesDataContext(); var applications = (from application in dataContext.tbAllotmentApplications where application.tblUser.AAN == AAN 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.Designation = application.tblDesignation.Name; obj.UserName = application.tblUser.fullName; obj.QuarterType = application.tblQuarterCategory.Name; obj.Cast = application.Cast; allotements.Add(obj); } return(allotements); }