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);
}
