public static void RegisterSemesterFreezeApplication(SemesterFreezeClass app)
{
var db = new DatabaseEntities();
db.Applications.Add(app.Application);
db.SaveChanges();
List <Form_Approver> faList = db.Form_Approver.ToList();
faList = (from f in faList where f.FormID == app.Application.FormID select f).ToList();
String[] semesters = app.SelectedSemesters.Split(',');
db.SemesterDropApplicationRecords.Add(new SemesterDropApplicationRecord()
{
Application_ID = app.Application.ApplicationID, SemesterOne = semesters[0].Equals("1"), SemesterTwo = semesters[1].Equals("1"), SemesterThree = semesters[2].Equals("1"), SemesterFour = semesters[3].Equals("1"), SemesterFive = semesters[4].Equals("1"), SemesterSix = semesters[5].Equals("1"), SemesterSeven = semesters[6].Equals("1"), SemesterEight = semesters[7].Equals("1")
});
db.SaveChanges();
Workflow wf = new Workflow()
{
AppliationID = app.Application.ApplicationID, ApproverID = faList.ElementAt(0).ApproverID, Status = 1, Order = faList.ElementAt(0).ApprovalOrder, Time = app.Application.CreatedOn
};
db.Workflows.Add(wf);
for (int i = 1; i < faList.Count; i++)
{
wf = new Workflow()
{
AppliationID = app.Application.ApplicationID, ApproverID = faList.ElementAt(i).ApproverID, Status = 4, Order = faList.ElementAt(i).ApprovalOrder, Time = app.Application.CreatedOn
};
db.Workflows.Add(wf);
}
db.SaveChanges();
}
public static SemesterFreezeClass GetSemesterFreezeApplicationForThisUser(int app_id, int user_id)
{
var db = new DatabaseEntities();
List <Workflow> workflows = db.Workflows.ToList();
var y = (from w in workflows where w.AppliationID == app_id && w.ApproverID == user_id select w).ToList();
if (y.Count == 0)
{
return(null);
}
List <Application> apps = db.Applications.ToList();
List <Workflow> list = (from w in workflows where w.AppliationID == app_id select w).ToList();
var x = (from a in apps where a.ApplicationID == app_id select a).ToList();
List <User> users = db.Users.ToList();
var u = (from user in users where user.UserId == x.ElementAt(0).UserID select user).ToList();
List <SemesterDropApplicationRecord> sdar = db.SemesterDropApplicationRecords.ToList();
var ss = (from s in sdar where s.Application_ID == app_id select s).ToList();
List <String> sSemesters = new List <string>();
if (ss.ElementAt(0).SemesterOne)
{
sSemesters.Add("1");
}
if (ss.ElementAt(0).SemesterTwo)
{
sSemesters.Add("2");
}
if (ss.ElementAt(0).SemesterThree)
{
sSemesters.Add("3");
}
if (ss.ElementAt(0).SemesterFour)
{
sSemesters.Add("4");
}
if (ss.ElementAt(0).SemesterFive)
{
sSemesters.Add("5");
}
if (ss.ElementAt(0).SemesterSix)
{
sSemesters.Add("6");
}
if (ss.ElementAt(0).SemesterSeven)
{
sSemesters.Add("7");
}
if (ss.ElementAt(0).SemesterEight)
{
sSemesters.Add("8");
}
String selectedSemesters = String.Join(", ", sSemesters.ToArray());
SemesterFreezeClass sfc = new SemesterFreezeClass()
{
Application = x.ElementAt(0), RollNumber = u.ElementAt(0).Login, SelectedSemesters = selectedSemesters, WorkFlows = list
};
return(sfc);
}
public static SemesterFreezeClass GetSemesterFreezeApplicationByThisUser(int app_id, int user_id, String rollNumber)
{
var db = new DatabaseEntities();
List <Application> apps = db.Applications.ToList();
var y = (from a in apps where a.ApplicationID == app_id && a.UserID == user_id select a).ToList();
if (y.Count == 0)
{
return(null);
}
List <Workflow> workflows = db.Workflows.ToList();
var finalResultDates = db.ClearanceFormFinalResultDates.ToList();
List <Workflow> wfs = (from wf in workflows where wf.AppliationID == app_id select wf).ToList();
List <SemesterDropApplicationRecord> sdar = db.SemesterDropApplicationRecords.ToList();
var ss = (from s in sdar where s.Application_ID == app_id select s).ToList();
List <String> sSemesters = new List <string>();
if (ss.ElementAt(0).SemesterOne)
{
sSemesters.Add("1");
}
if (ss.ElementAt(0).SemesterTwo)
{
sSemesters.Add("2");
}
if (ss.ElementAt(0).SemesterThree)
{
sSemesters.Add("3");
}
if (ss.ElementAt(0).SemesterFour)
{
sSemesters.Add("4");
}
if (ss.ElementAt(0).SemesterFive)
{
sSemesters.Add("5");
}
if (ss.ElementAt(0).SemesterSix)
{
sSemesters.Add("6");
}
if (ss.ElementAt(0).SemesterSeven)
{
sSemesters.Add("7");
}
if (ss.ElementAt(0).SemesterEight)
{
sSemesters.Add("8");
}
String selectedSemesters = String.Join(", ", sSemesters.ToArray());
SemesterFreezeClass sfc = new SemesterFreezeClass()
{
Application = y.ElementAt(0), RollNumber = rollNumber, SelectedSemesters = selectedSemesters, WorkFlows = wfs
};
return(sfc);
}
