public IHttpActionResult Postgsf_Travel_Allowance(gsf_Travel_Allowance gsf_travel_allowance)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
db.gsf_Travel_Allowance.Add(gsf_travel_allowance);
db.SaveChanges();
return CreatedAtRoute("DefaultApi", new { id = gsf_travel_allowance.Allowance_ID }, gsf_travel_allowance);
}
// PUT api/Default2/5
public IHttpActionResult Putgsf_Travel_Allowance(int id, gsf_Travel_Allowance gsf_travel_allowance)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != gsf_travel_allowance.Allowance_ID)
{
return BadRequest();
}
db.Entry(gsf_travel_allowance).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!gsf_Travel_AllowanceExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
public string Getgsf_Travel_Allowance(string query, string para)
{
if (query == "checkrecordexist")
{
var termcode = getTermCode();
var recordnumber = (from m in db.gsf_Travel_Allowance
where m.USC_ID == para & m.Period_Code == termcode
select m.USC_ID).Count();
return recordnumber.ToString();
}
else if (query == "createnewapplication")
{
string[] words = para.Split('$');
var USC_ID =words[0];
var Applicant_ID=words[1];
var USC_Email=words[2];
var Period_Code=words[3];
var Start_Apply_Time=words[4];
gsf_Travel_Allowance gsf_travel_allowance =new gsf_Travel_Allowance();
gsf_travel_allowance.USC_ID=USC_ID;
gsf_travel_allowance.Applicant_ID=Convert.ToInt32(Applicant_ID);
gsf_travel_allowance.USC_Email=USC_Email;
gsf_travel_allowance.Period_Code=Convert.ToInt32(Period_Code);
Random r = new Random();
var x = r.Next(0, 100000);
string s = x.ToString("00000");
gsf_travel_allowance.PIN=s;
gsf_travel_allowance.Apply_Status=0;
gsf_travel_allowance.Admin_Status=0;
gsf_travel_allowance.Is_Email_Sent = 0;
gsf_travel_allowance.Start_Apply_Time=Convert.ToDateTime(Start_Apply_Time);
Postgsf_Travel_Allowance(gsf_travel_allowance);
return "created";
}
else if (query == "getseveraladminstatus")
{
string[] words = para.Split('@');
var word0 = words[0];
var word1 = words[1];
var table = from m in db.gsf_Travel_Allowance
where m.USC_ID == word0 & m.Period_Code.ToString() == word1
select new { Admin_Status = m.Admin_Status };
var count = table.Count();
if (count != 0)
{
foreach (var c in table)
{
return c.Admin_Status.ToString();
}
}
else
{
return "-1";
}
}
else if (query == "getstartapplytime")
{
var termcode = getTermCode();
var table = from m in db.gsf_Travel_Allowance
where m.USC_ID == para & m.Period_Code == termcode
select new { StartApplyTime = m.Start_Apply_Time };
var count = table.Count();
if (count != 0)
{
foreach (var c in table)
{
return c.StartApplyTime.ToString();
}
}
else
{
return null;
}
}
else if (query == "getpin")
{
var termcode = getTermCode();
var getpin = from m in db.gsf_Travel_Allowance
where m.USC_ID == para & m.Period_Code == termcode
select new { PIN = m.PIN };
if (getpin.Count() != 0)
{
return "exist";
}
else
return null;
}
else if (query == "getentryforapplicant")
{
var termcode = getTermCode();
var row = from m in db.gsf_Travel_Allowance
where m.USC_ID == para & m.Period_Code == termcode
select new { IsPassScreening = m.Pass_Screening, IsCompleteUnits = m.Complete_Units, ChairFName = m.Chair_FName, ChairLName = m.Chair_LName, ChairEmail = m.Chair_Email, AdvisorFName = m.Advisor_FName, AdvisorLName = m.Advisor_LName, AdvisorEmail = m.Advisor_Email, Purpose = m.Travel_Purpose };
foreach (var c in row)
{
return c.IsPassScreening + "&" + c.IsCompleteUnits + "&" + c.ChairFName + "&" + c.ChairLName + "&" + c.ChairEmail + "&" + c.AdvisorFName + "&" + c.AdvisorLName + "&" + c.AdvisorEmail + "&" + c.Purpose;
}
}
else if (query == "getentrynumberforapplicant")
{
var termcode = getTermCode();
var rownumber = (from m in db.gsf_Travel_Allowance
where m.USC_ID == para & m.Period_Code == termcode
select m.USC_Email).Count();
return rownumber.ToString();
}
else if (query == "getallowanceid")
{
var termcode = getTermCode();
var row = from m in db.gsf_Travel_Allowance
where m.USC_ID == para & m.Period_Code == termcode
select new { AppId = m.Allowance_ID };
foreach (var c in row)
{
return c.AppId.ToString();
}
}
else if (query == "getapplystate")
{
var termcode = getTermCode();
var row = from m in db.gsf_Travel_Allowance
where m.USC_ID == para & m.Period_Code == termcode
select new { AppId = m.Apply_Status };
foreach (var c in row)
{
return c.AppId.ToString();
}
}
else if (query == "getseveralallowanceid")
{
//var termcode = getTermCode();
string[] words = para.Split('@');
var word0 = words[0];
var word1 = words[1];
var row = from m in db.gsf_Travel_Allowance
where m.USC_ID == word0 & m.Period_Code.ToString() == word1
select new { AppId = m.Allowance_ID };
foreach (var c in row)
{
return c.AppId.ToString();
}
}
else if (query == "getallinformation")
{
// var termcode = getTermCode();
var row = from m in db.gsf_Travel_Allowance
where m.Allowance_ID.ToString() == para
select m;
foreach (var c in row)
{
return c.Allowance_ID + "$" + c.Period_Code + "$" + c.USC_ID + "$" + c.USC_Email + "$" + c.PIN + "$" + c.Travel_Destination + "$" + c.Travel_Purpose + "$" + c.Travel_Comment + "$" + c.Chair_FName + "$" + c.Chair_LName + "$" + c.Chair_Email + "$" + c.Advisor_FName + "$" + c.Advisor_LName + "$" + c.Advisor_Email + "$" + c.Apply_Status + "$" + c.Admin_Status + "$" + c.Is_Email_Sent + "$" + c.Decision_Notes + "$" + c.Start_Apply_Time + "$" + c.Last_Update_Time + "$" + c.Submit_Time + "$" + c.Start_Review_Time + "$" + c.Approve_Time + "$" + c.Decline_Time + "$" + c.Email_Sent_Time + "$" + c.Pass_Screening + "$" + c.Complete_Units + "$" + c.Applicant_ID + "$" + c.AllowanceAmount;
}
}
else if (query == "getdetailinformation")
{
var row = from m in db.gsf_Travel_Allowance
join n in db.vw_Active_Travel_Grant_Students on m.Applicant_ID equals n.Applicant_ID
where m.Allowance_ID.ToString() == para
select new { n.LastName, n.FirstName, m.USC_ID, m.USC_Email, n.Program, n.School, n.Fellowship_Name, n.Term_ID, n.Post, m.Period_Code, m.Travel_Purpose, m.Chair_FName, m.Chair_LName, m.Chair_Email, m.Advisor_FName, m.Advisor_LName, m.Advisor_Email, m.Pass_Screening, m.Complete_Units };
foreach (var c in row)
{
return c.LastName + "$" + c.FirstName + "$" + c.USC_ID + "$" + c.USC_Email + "$" + c.Program + "$" + c.School + "$" + c.Fellowship_Name + "$" + Convert.ToInt32(c.Term_ID / 10) + "$" + c.Post + "$" + c.Travel_Purpose + "$" + c.Period_Code + "$" + c.Advisor_FName + " " + c.Advisor_LName + "$" + c.Advisor_Email + "$" + c.Chair_FName + " " + c.Chair_LName + "$" + c.Chair_Email + "$" + c.Pass_Screening + "$" + c.Complete_Units;
}
}
else if (query == "getadmindetailinformation")
{
var row = from m in db.gsf_Travel_Allowance
join n in db.vw_Active_Travel_Grant_Students on m.Applicant_ID equals n.Applicant_ID
where m.Allowance_ID.ToString() == para
select new { m.Period_Code, m.Is_Email_Sent, m.Admin_Status, m.Decision_Notes, m.AllowanceAmount };
foreach (var c in row)
{
return c.Is_Email_Sent + "$" + c.Period_Code + "$" + c.Admin_Status + "$" + c.Decision_Notes + "$" + c.AllowanceAmount;
}
}
return "unsolved";
}