public Grant(Grant g)
{
this.category = g.category;
this.grantManagerFirst = g.grantManagerFirst;
this.grantManagerLast = g.grantManagerLast;
this.grantNumber = g.grantNumber;
this.grantTitle = g.grantTitle;
this.ID = g.ID;
this.stateCatalogNum = g.stateCatalogNum;
}
public static Grant[] GetGrantFromID(int ID, int index)
{
List<Grant> grants = (List<Grant>)HttpContext.Current.Session["Grants"];
var grant = (from g in grants where g.ID == ID select g).SingleOrDefault();
List<Grant> selGrants = null;
if (HttpContext.Current.Session["SelectedGrants"] != null)
{
selGrants = (List<Grant>)HttpContext.Current.Session["SelectedGrants"];
}
else
{
selGrants = new List<Grant>();
}
if (selGrants.Count < 1)
{
for (int ix = 0; ix < 6; ix++)
{
Grant g = new Grant();
g.ID = -1;
selGrants.Add(g);
}
}
Grant gg = selGrants[index];
var grt = (from gt in grants where gt.ID == ID select gt).SingleOrDefault();
gg.category = grt.category;
gg.ID = grt.ID;
gg.grantTitle = grt.grantTitle;
gg.grantManagerFirst = grt.grantManagerFirst;
gg.grantManagerLast = grt.grantManagerLast;
gg.grantNumber = grt.grantNumber;
gg.stateCatalogNum = grt.stateCatalogNum;
HttpContext.Current.Session["SelectedGrants"] = selGrants;
return selGrants.ToArray();
}
public static string formulateApprovalForGM(int month, int year, Employee emp, Grant g, Employee manager)
{
StringBuilder sb = new StringBuilder();
sb.Append("<html><body><strong>Hi " + manager.firstName + "</strong><p />");
sb.Append(emp.firstName + " " + emp.lastName + " has been approved for the " + g.grantTitle + " grant.<br />");
sb.Append("To see the grant entries for " + emp.firstName + " please click on the following link:<br /><a href=");
sb.Append("http://www.mid-state.net/GrantApplication/Default.aspx?Review=true&ID=" + manager.ID.ToString() + "&Employee=" + emp.ID.ToString());
sb.Append( "&month=" + month.ToString() + "&Year=" + year.ToString() + "&GrantID=" +g.ID.ToString());
sb.Append(">Review Time Enties</a><p />Thank you,<br />");
sb.Append("<strong>The grant allocations team.</strong></body></html>");
return sb.ToString();
}
private List<Grant> getGrants(OleDbConnection conn)
{
OleDbCommand comm = new OleDbCommand();
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = "select * from GrantInfo order by ID";
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = comm;
DataSet set = new DataSet();
try
{
adapter.Fill(set);
}
catch (System.Exception eb)
{
return null;
}
List<Grant> grants = new List<Grant>();
foreach (DataRow dr in set.Tables[0].Rows)
{
Grant g = new Grant();
g.ID = (int)dr[0];
g.stateCatalogNum = dr[1].ToString();
g.category = dr[2].ToString();
g.grantNumber = dr[3].ToString();
g.grantTitle = dr[4].ToString();
g.grantManagerLast = dr[5].ToString();
g.grantManagerFirst = dr[6].ToString();
grants.Add(g);
}
Session["Grants"] = grants;
return grants;
}
private List<Grant> getApprovalGrant(OleDbConnection conn)
{
int grantID = System.Convert.ToInt32(Request.Params["GrantID"]);
OleDbCommand comm = new OleDbCommand();
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = "select * from GrantInfo where ID in (" + grantID.ToString() + ",52,53)";
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = comm;
DataSet set = new DataSet();
try
{
adapter.Fill(set);
}
catch (System.Exception eb)
{
return null;
}
List<Grant> grants = new List<Grant>();
foreach (DataRow dr in set.Tables[0].Rows)
{
Grant g = new Grant();
g.ID = (int)dr[0];
g.stateCatalogNum = dr[1].ToString();
g.category = dr[2].ToString();
g.grantNumber = dr[3].ToString();
g.grantTitle = dr[4].ToString();
g.grantManagerLast = dr[5].ToString();
g.grantManagerFirst = dr[6].ToString();
grants.Add(g);
}
Session["Grants"] = grants;
//conn.Close();
return grants;
}
private static Grant populateGrant(DataRow dr)
{
Grant g = new Grant();
g.ID = (int)dr[0];
g.stateCatalogNum = dr[1].ToString();
g.category = dr[2].ToString();
g.grantNumber = dr[3].ToString();
g.grantTitle = dr[4].ToString();
g.grantManagerLast = dr[5].ToString();
g.grantManagerFirst = dr[6].ToString();
return g;
}
