protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["SerialNum"] != null)
HyperLinkDetail.NavigateUrl = "../GameServer/ServerOperationHistory.aspx?SerialNum=" + Request.Params["SerialNum"].ToString();
TableHeaderRow header = new TableHeaderRow();
TableHeaderCell[] head = new TableHeaderCell[2];
for (int i = 0; i <= 1; i++) head[i] = new TableHeaderCell();
head[0].Width = new Unit(10f, UnitType.Percentage);
head[0].Text = StringDef.Name;
head[1].Width = new Unit(30f, UnitType.Percentage);
head[1].Text = StringDef.Message;
header.Cells.AddRange(head);
ResultList.Rows.Add(header);
if (Session["ActionResultList"] == null)
{
TableRow row = new TableRow();
TableCell[] cell = new TableCell[2];
for (int i = 0; i <= 1; i++) cell[i] = new TableCell(); ;
cell[0].Text = "";
cell[1].Text = "Çë²é¿´ÈÕÖ¾";
row.Cells.AddRange(cell);
ResultList.Rows.Add(row);
}
else
{
ShowRunResult(Session["ActionResultList"] as IList);
}
}
}
public static TableHeaderRow CreateTableHeaderRow (params string [] cells)
{
TableHeaderRow result = new TableHeaderRow ();
for (int i = 0; i < cells.Length; i++)
result.Cells.Add (CreateTableHeaderCell (cells [i]));
return result;
}
protected void DropDownListSuppliers_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownListSuppliers.SelectedIndex == 0) return;
List<List<string>> lProd = NorthwindAccess.GetProducts(DropDownListSuppliers.SelectedValue);
TableHeaderRow thr = new TableHeaderRow();
for (int i = 0; i < lProd[0].Count; i++)
{
TableHeaderCell thc = new TableHeaderCell();
thc.Text = lProd[0][i];
thr.Cells.Add(thc);
}
tableProducts.Rows.Add(thr);
for (int i = 1; i < lProd.Count; i++)
{
TableRow tr = new TableRow();
for (int ii = 0; ii < lProd[i].Count; ii++)
{
TableCell tc = new TableCell();
tc.Text = lProd[i][ii];
tr.Cells.Add(tc);
}
tableProducts.Rows.Add(tr);
}
}
protected void Page_Load(object sender, EventArgs e)
{
v1txtName.Focus();
//count is used to populate the number of rows in the view2 table
//it is based on the number entered in the v1txtFields TextBox
int count;
try
{
if (v1txtFields.Text.Trim().Length > 0)//if a value is present at all
{
count = int.Parse(v1txtFields.Text.Trim());//get the number from v1txtFields TextBox
//set the table columns and headers
TableHeaderRow thr = new TableHeaderRow();
TableHeaderCell thFieldName = new TableHeaderCell();
TableHeaderCell thDataType = new TableHeaderCell();
TableHeaderCell thRequired = new TableHeaderCell();
thFieldName.Text = "Field Name";
thDataType.Text = "Data Type";
thRequired.Text = "Required";
thr.Cells.Add(thFieldName);
thr.Cells.Add(thDataType);
thr.Cells.Add(thRequired);
v2table.Rows.Add(thr);
//populate the table with new text boxes, drop lists, and validators
for (int i = 0; i < count; i++)
{
TableRow tr = new TableRow();
TableCell c1 = new TableCell();//text box
TableCell c2 = new TableCell();//droplist
TableCell c3 = new TableCell();//checkbox
DropDownList ddl = SetDataTypeList();
TextBox t = new TextBox();
t.TabIndex = (short)(i + 1);
t.ID = "box" + i.ToString(); // can't validate without an ID
c1.Controls.Add(t);
c2.Controls.Add(ddl);
c3.Controls.Add(new CheckBox());
tr.Cells.Add(c1);
tr.Cells.Add(c2);
tr.Cells.Add(c3);
tr.Cells.Add(new TableCell()); //add a blank cell for the validator later
v2table.Rows.Add(tr);
}
}
else //nothing is in the view 1 textbox at page load
{
count = 0;
}
}
catch (Exception)
{
}
}
public TableHeaderRow adicionarCabecalho(params object[] conteudo)
{
TableHeaderRow cabecalho = new TableHeaderRow();
foreach (object conteudoCelula in conteudo)
{
adicionar(cabecalho, new TableHeaderCell(), conteudoCelula);
}
tabela.Rows.Add(cabecalho);
return cabecalho;
}
protected void Page_Load(object sender, EventArgs e)
{
Alert.Visible = false;
LoadAllStandardOperatingProcedures();
if (standardOperatingProcedures == null)
{
Alert.Visible = true;
Alert.InnerHtml = "There are no SOPs in the database!";
}
else
{
var headerRow = new TableHeaderRow();
var titleHeaderCell = new TableHeaderCell();
titleHeaderCell.Text = "Title";
var departmentHeaderCell = new TableHeaderCell();
departmentHeaderCell.Text = "Department";
TableHeaderCell[] headerCells = { titleHeaderCell, departmentHeaderCell };
headerRow.Cells.AddRange(headerCells);
StandardOperatingProcedures.Rows.Add(headerRow);
foreach (var sop in standardOperatingProcedures)
{
var row = new TableRow();
var titleCell = new TableCell();
titleCell.Text = sop.Title;
var departmentCell = new TableCell();
departmentCell.Text = sop.Department;
//var previewCell = new TableCell();
//previewCell.Text = "<a href='"
var viewCell = new TableCell();
var viewButton = new Button();
viewButton.Text = "View";
viewButton.CommandArgument = sop.Title;
viewButton.Command += new CommandEventHandler(ViewClick);
viewCell.Controls.Add(viewButton);
var downloadCell = new TableCell();
Button downloadButton = new Button();
downloadButton.Text = "Download";
downloadButton.CommandArgument = sop.Title;
downloadButton.Command += new CommandEventHandler(DownloadClick);
downloadCell.Controls.Add(downloadButton);
var editCell = new TableCell();
Button editButton = new Button();
editButton.Text = "Edit";
editButton.CommandArgument = sop.XmlPath.Substring(sop.XmlPath.LastIndexOf('\\'));
editButton.Command += new CommandEventHandler(EditClick);
editCell.Controls.Add(editButton);
TableCell[] cells = { titleCell, departmentCell, viewCell, /*previewCell,*/ downloadCell, editCell };
row.Cells.AddRange(cells);
StandardOperatingProcedures.Rows.Add(row);
}
}
}
/// <summary>
/// Event triggered to perform the matchmaking algorithm
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnFindParticipants_Click(object sender, EventArgs e)
{
int studyID = Convert.ToInt32(Request.QueryString["study_id"]);
Matchmaker matchmaker = new Matchmaker(new Study(studyID));
Table tblResults = new Table();
TableHeaderRow header = new TableHeaderRow();
TableHeaderCell headerName = new TableHeaderCell();
TableHeaderCell headerEmail = new TableHeaderCell();
TableHeaderCell headerScore = new TableHeaderCell();
headerName.Text = "Name";
headerEmail.Text = "Email";
headerScore.Text = "Score";
header.Cells.Add(headerName);
header.Cells.Add(headerEmail);
header.Cells.Add(headerScore);
tblResults.Rows.Add(header);
tblResults.CellSpacing = 3;
tblResults.CellPadding = 5;
foreach (KeyValuePair<Participant, int> result in matchmaker.Results) {
TableRow row = new TableRow();
TableCell cellID = new TableCell();
TableCell cellName = new TableCell();
TableCell cellEmail = new TableCell();
TableCell cellScore = new TableCell();
cellID.Text = result.Key.UserID.ToString();
cellID.Visible = false;
HyperLink link = new HyperLink();
link.ToolTip = "Click the link to view more information about this user";
link.Text = result.Key.FirstName + " " + result.Key.LastName;
link.NavigateUrl="ParticipantInfo.aspx?participant_id=" + cellID.Text + "&study_id=" + studyID;
cellName.Controls.Add(link);
cellEmail.Text = result.Key.Email;
cellScore.Text = result.Value.ToString();
row.Cells.Add(cellID);
row.Cells.Add(cellName);
row.Cells.Add(cellEmail);
row.Cells.Add(cellScore);
tblResults.Rows.AddAt(getIndexToAdd(tblResults, row), row);
pnlmatchmakingResults.Controls.Add(tblResults);
}
if (matchmaker.Results.Count == 0) {
lblNoResults.Visible = true;
}
pnlmatchmakingResults.Visible = true;
btnEmailParticipant.Visible = true;
}
public void fillTable(string sql, ref Table table)
{
DataTable dataTable = selectQuery(sql);
TableHeaderRow th = new TableHeaderRow();
for (int i = 0; i < dataTable.Columns.Count; i++)
{
TableHeaderCell cell = new TableHeaderCell();
cell.Text = dataTable.Columns[i].ColumnName;
th.Cells.Add(cell);
}
table.Rows.Add(th);
foreach (DataRow row in dataTable.Rows)
{
TableRow trow = new TableRow();
for (int i = 0; i < dataTable.Columns.Count; i++)
{
TableCell cell = new TableCell();
cell.Text = row[i].ToString();
trow.Cells.Add(cell);
}
if (table.ID == "TableEquip")
{
TableCell cell = new TableCell();
LinkButton edit = new LinkButton();
edit.PostBackUrl = "~/PersonnelEditEquip.aspx?equip=";
edit.PostBackUrl += row[0].ToString();
edit.Text = "ویرایش";
cell.Controls.Add(edit);
trow.Cells.Add(cell);
}
table.Rows.Add(trow);
}
}
private void ShowGatewayList(IList<GatewayInfo> list)
{
if (list == null || list.Count == 0)
{
return;
}
TableHeaderRow rowHead = new TableHeaderRow();
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = StringDef.GatewayName;
rowHead.Cells.Add(cellHead);
cellHead = new TableHeaderCell();
cellHead.Text = StringDef.ZoneName;
rowHead.Cells.Add(cellHead);
cellHead = new TableHeaderCell();
cellHead.Text = StringDef.IPAddress;
rowHead.Cells.Add(cellHead);
TableGatewayInfo.Rows.Add(rowHead);
foreach (GatewayInfo info in list)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Text = info.GatewayName;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = info.ZoneName;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = info.IPAddress;
row.Cells.Add(cell);
TableGatewayInfo.Rows.Add(row);
}
LabelResult.Text = StringDef.GatewayList;
}
public static void CreateHeader(string strheader, Table table, int[] widths)
{
string[] Headers = strheader.Split(',');
TableHeaderRow thr = new TableHeaderRow();
int i = 0;
if (Headers.Length != widths.Length)
{
i = -1;
}
foreach (string s in Headers)
{
TableHeaderCell tc = new TableHeaderCell();
tc.Text = s;
if (i > -1)
{
tc.Width = widths[i];
i++;
}
thr.Cells.Add(tc);
}
table.Rows.Add(thr);
}
protected void Button1_Click(object sender, EventArgs e)
{
DateTime dt = Convert.ToDateTime(TextBox1.Text);
string date = dt.ToString("yyyy/MM/dd");
DateTime tt = Convert.ToDateTime(TextBox2.Text);
string date2 = tt.ToString("yyyy/MM/dd");
if (dt > tt)
{
Page.ClientScript.RegisterStartupScript(GetType(), "msgtype", "alert('Select Date Properly !!!')", true);
}
else
{
SqlDataAdapter da;
DataSet ds = new DataSet();
string ol = "select foodname,sum(quantity) as quantity,sum(amount) as amount,date from transact where date >= '" + date + "' and date<='" + date2 + "' group by foodname,quantity,amount,date";
da = new SqlDataAdapter(ol, con);
da.Fill(ds);
double amt = 0;
if (ds.Tables[0].Rows.Count > 0)
{
TableHeaderRow hr = new TableHeaderRow();
TableHeaderCell thc = new TableHeaderCell();
TableHeaderCell thc1 = new TableHeaderCell();
TableHeaderCell thc2 = new TableHeaderCell();
TableHeaderCell thc3 = new TableHeaderCell();
thc.Text = "Food Name";
thc1.Text = "Quantity";
thc2.Text = "Amount";
thc3.Text = "Date";
hr.Cells.Add(thc);
hr.Cells.Add(thc1);
hr.Cells.Add(thc2);
hr.Cells.Add(thc3);
Table1.Rows.Add(hr);
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
TableRow tRow = new TableRow();
TableCell tcell = new TableCell();
TableCell tcell1 = new TableCell();
TableCell tcell2 = new TableCell();
TableCell tcell3 = new TableCell();
TableCell tcell4 = new TableCell();
TableCell tcell5 = new TableCell();
tcell.Text = ds.Tables[0].Rows[j][0].ToString();
tcell.HorizontalAlign = HorizontalAlign.Center;
tcell1.Text = ds.Tables[0].Rows[j][1].ToString();
tcell1.HorizontalAlign = HorizontalAlign.Center;
tcell2.Text = ds.Tables[0].Rows[j][2].ToString();
tcell2.HorizontalAlign = HorizontalAlign.Center;
tcell3.Text = ds.Tables[0].Rows[j][3].ToString();
tcell3.HorizontalAlign = HorizontalAlign.Center;
amt = amt + Convert.ToDouble(ds.Tables[0].Rows[j][2].ToString());
tRow.Cells.Add(tcell);
tRow.Cells.Add(tcell1);
tRow.Cells.Add(tcell2);
tRow.Cells.Add(tcell3);
Table1.Rows.Add(tRow);
}
Chart1.DataSource = ds;
TableRow tr = new TableRow();
TableCell tc = new TableCell();
TableCell tc1 = new TableCell();
tc.ColumnSpan = 2;
tc.Text = "Total";
tc.HorizontalAlign = HorizontalAlign.Right;
tc.Font.Bold = true;
tc.Font.Size = 20;
tc1.Text = Convert.ToString(amt);
tc1.HorizontalAlign = HorizontalAlign.Center;
tc1.Font.Bold = true;
tc1.Font.Size = 20;;
tr.Cells.Add(tc);
tr.Cells.Add(tc1);
Table1.Rows.Add(tr);
Chart1.Series["Series1"].XValueMember = "foodname";
Chart1.Series["Series1"].YValueMembers = "amount";
// Chart1.Series.Add("Series2");
// Chart1.Series["Series2"].YValueMembers = "date";
Chart1.DataBind();
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "msgtype", "alert('No Data Available!!!')", true);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty) || autro_obj.CheckGroupUser(login_data, group_var.admin_department) || autro_obj.CheckGroupUser(login_data, group_var.admin_otherOffice))
{
/*=============================*/
userId = Request.QueryString["Uid"];
flag = Request.QueryString["flag"];
token = Request.QueryString["token"];
bool haverole = false;
//if (autro_obj.CheckGroupUser(login_data, group_var.admin_university))
// {
// haverole = true;
// }
if (autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.admin_faculty);
foreach (string fac in faculty_authorized)
{
if (fac == token.Substring(0, 2))
{
haverole = true;
break;
}
}
}
//else if (autro_obj.CheckGroupUser(login_data, group_var.admin_department))
// {
// List<string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.admin_department);
// foreach(string dep in department_authorized)
// {
// if(dep == token)
// {
// haverole = true;
// break;
// }
// }
// }
//else if (autro_obj.CheckGroupUser(login_data, group_var.admin_otherOffice))
// {
// List<string> otheroffice_authorized = autro_obj.getOtherOffice_Authorized(login_data, group_var.admin_otherOffice);
// foreach(string office in otheroffice_authorized)
// {
// if (office == token)
// {
// haverole = true;
// break;
// }
// }
// }
else
{
haverole = false;
}
if (haverole == true)
{
userData = userObj.getUsers(userId);
lblUserId.Text = userData.USERS_INFO_USER_ID;
lblName.Text = new Prefix().getPrefix(userData.USERS_INFO_TITLE_THAINAME).Prefix_Thai;
lblName.Text += userData.USERS_INFO_FIRST_THAINAME + " " + userData.USERS_INFO_FAMILY_THAINAME;
if (userData.USERS_INFO_DEPARTMENT_ID == "0000")
{
lblDepartment.Text = "-";
}
else
{
Department departmentObj = new Department();
lblDepartment.Text = departmentObj.getDepartment(userData.USERS_INFO_DEPARTMENT_ID).Department_Thai;
}
if (userData.USERS_INFO_FACULTY_ID == "00")
{
OtherOfficeData otherOffice = new OtherOffice().getOtherOffice(userData.OTHEROFFICE_CODE);
lblFaculty.Text = otherOffice.OtherOffice_ThaiName;
}
else
{
Faculty facultyObj2 = new Faculty();
lblFaculty.Text = facultyObj2.getFaculty(userData.USERS_INFO_FACULTY_ID).Faculty_Thai;
}
// Head Table
string[] ar = { "ระดับสิทธิ์", "ภาควิชา", "คณะ/วิทยาลัย/สำนักงาน", "ลบ" };
//Table tb1 = new Table();
tblUsers.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblUsers.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++)
{
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar[cellCtr - 1];
if (cellCtr == 1)
{
cellHead.Width = 250;
}
else if (cellCtr == 4)
{
cellHead.Width = 80;
}
tRowHead.Cells.Add(cellHead);
}
tblUsers.Rows.Add(tRowHead);
TableBody("Faculty", userId);
TableBody("Department", userId);
TableBody("Office", userId);
if (!Page.IsPostBack)
{
//ซ่อน ddl สังกัดไว้ตอน page load
if (flag == "1" || flag == "2")
{
ddlDivision.Items.FindByValue("1").Selected = true;
//ddlFaculty.Items.FindByValue(token).Selected = true;
// คณะ
//List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.admin_faculty);
ddlFaculty.Items.Clear();
FacultyData fac_data = new FacultyData();
fac_data = facultyObj.getFaculty(token.Substring(0, 2));
ddlFaculty.Items.Insert(ddlFaculty.Items.Count, new ListItem(fac_data.Faculty_Thai, fac_data.Faculty_Code));
//โหลดภาควิชา
List <DepartmentData> departmentData = new List <DepartmentData>();
departmentData = new Department().getDepartmentWithFaculty(fac_data.Faculty_Code);
ddlDepartment.Items.Clear();
ddlDepartment.Items.Insert(0, new ListItem("-- ไม่ได้สังกัดภาควิชา --", "0000"));
foreach (DepartmentData data in departmentData)
{
ddlDepartment.Items.Insert(ddlDepartment.Items.Count, new ListItem(data.Department_Thai, data.Department_Code));
}
//โหลดระดับสิทธิ์ระดับคณะ
userGroupData = userGroup.getUserGroup();
ddlGroup.Items.Clear();
foreach (UserGroupData data in userGroupData)
{
if (data.Users_Group_Id == "0300" || data.Users_Group_Id == "1101")
{
ddlGroup.Items.Insert(ddlGroup.Items.Count, new ListItem(data.Users_Group_Name, data.Users_Group_Id));
}
}
divOffice.Visible = false;
}
//if (flag == "2")
// {
// //โหลดภาควิชา
// Department department = new Department();
// List<DepartmentData> departmentData = new List<DepartmentData>();
// //departmentData = department.getDepartmentWithFaculty(ddlFaculty.SelectedValue);
// departmentData = department.getDepartment();
// ddlDepartment.Items.Clear();
// ddlDepartment.Items.Insert(0, new ListItem("-- ไม่ได้สังกัดภาควิชา --", "0000"));
// foreach (DepartmentData data in departmentData)
// {
// ddlDepartment.Items.Insert(ddlDepartment.Items.Count, new ListItem(data.Department_Thai, data.Department_Code));
// }
// string fac = new Department().getDepartment(token).Department_FacultyCode;
// ddlDivision.Items.FindByValue("1").Selected = true;
// ddlFaculty.Items.FindByValue(fac).Selected = true;
// ddlDepartment.Items.FindByValue(token).Selected = true;
// //โหลดระดับสิทธิ์ระดับภาควิชา
// userGroupData = userGroup.getUserGroup();
// ddlGroup.Items.Clear();
// foreach (UserGroupData data in userGroupData)
// {
// if (data.Users_Group_Id == "0400" || data.Users_Group_Id == "1102" || data.Users_Group_Id == "0800")
// {
// ddlGroup.Items.Insert(ddlGroup.Items.Count, new ListItem(data.Users_Group_Name, data.Users_Group_Id));
// }
// }
// divOffice.Visible = false;
// }
if (flag == "3")
{
/////รหัสสิทธิ์ Users_Group_Id
//0300 วิชาการคณะ
//0200 เจ้าหน้าที่ทะเบียน สถิติ บณฑิต
//0100 ผู้บริหารงานทะเบียน สถิติ บัณฑิต
//0400 วิชาการภาค
//0500 งานการเงิน
//0800 อาจารย์ที่ปรึกษา/ผู้สอน
//5000 งานธนาคาร
//1103 ผู้ดูแลหน่วยงาน
//0900 งานหลักสูตร
//0700 งานทุนนักศึกษา
//1000 ผู้บริหารมหาวิทยาลัย
//1101 ผู้ดูแลระบบคณะ
//1102 ผู้ดูแลลระบบภาควิชา
//1100 ผู้ดูแลระบบหลัก
//0600 งานกองแผนงาน
divFaculty.Visible = false;
ddlDivision.Items.FindByValue("2").Selected = true;
ddlOffice.Items.FindByValue(token).Selected = true;
//0500 กองแผนงาน
if (ddlOffice.SelectedValue == "0500")
{
//โหลดระดับสิทธิ์ระดับสำนักงาน
userGroupData = userGroup.getUserGroup();
ddlGroup.Items.Clear();
foreach (UserGroupData data in userGroupData)
{
if (data.Users_Group_Id == "0600" || data.Users_Group_Id == "1103")
{
ddlGroup.Items.Insert(ddlGroup.Items.Count, new ListItem(data.Users_Group_Name, data.Users_Group_Id));
}
}
}
//2200 สำนักคอมพิวเตอร์และเทคโนโลยีสารสนเทศ
if (ddlOffice.SelectedValue == "2200")
{
//โหลดระดับสิทธิ์ระดับสำนักงาน
userGroupData = userGroup.getUserGroup();
ddlGroup.Items.Clear();
foreach (UserGroupData data in userGroupData)
{
if (data.Users_Group_Id == "1100" || data.Users_Group_Id == "1000" || data.Users_Group_Id == "5000")
{
ddlGroup.Items.Insert(ddlGroup.Items.Count, new ListItem(data.Users_Group_Name, data.Users_Group_Id));
}
}
}
//0601 กองบริการการศึกษา
if (ddlOffice.SelectedValue == "0601")
{
//โหลดระดับสิทธิ์ระดับสำนักงาน
userGroupData = userGroup.getUserGroup();
ddlGroup.Items.Clear();
foreach (UserGroupData data in userGroupData)
{
if (data.Users_Group_Id == "0900" || data.Users_Group_Id == "0100" || data.Users_Group_Id == "0200" || data.Users_Group_Id == "1103")
{
ddlGroup.Items.Insert(ddlGroup.Items.Count, new ListItem(data.Users_Group_Name, data.Users_Group_Id));
}
}
}
//1001 กองคลัง
if (ddlOffice.SelectedValue == "1001")
{
//โหลดระดับสิทธิ์ระดับสำนักงาน
userGroupData = userGroup.getUserGroup();
ddlGroup.Items.Clear();
foreach (UserGroupData data in userGroupData)
{
if (data.Users_Group_Id == "0500" || data.Users_Group_Id == "1103")
{
ddlGroup.Items.Insert(ddlGroup.Items.Count, new ListItem(data.Users_Group_Name, data.Users_Group_Id));
}
}
}
//5001 ธนาคารกรุงเทพ
if (ddlOffice.SelectedValue == "5001")
{
//โหลดระดับสิทธิ์ระดับสำนักงาน
userGroupData = userGroup.getUserGroup();
ddlGroup.Items.Clear();
foreach (UserGroupData data in userGroupData)
{
if (data.Users_Group_Id == "5000")
{
ddlGroup.Items.Insert(ddlGroup.Items.Count, new ListItem(data.Users_Group_Name, data.Users_Group_Id));
}
}
}
//0700 กองกิจการนักศึกษา
if (ddlOffice.SelectedValue == "0700")
{
//โหลดระดับสิทธิ์ระดับสำนักงาน
userGroupData = userGroup.getUserGroup();
ddlGroup.Items.Clear();
foreach (UserGroupData data in userGroupData)
{
if (data.Users_Group_Id == "0700" || data.Users_Group_Id == "1103")
{
ddlGroup.Items.Insert(ddlGroup.Items.Count, new ListItem(data.Users_Group_Name, data.Users_Group_Id));
}
}
}
}
}
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
/// <summary>
/// Generates tables
/// </summary>
private void GenerateTable()
{
tblData.Controls.Clear();
Hashtable ht = data.ConvertToHashtable();
TableHeaderRow th = new TableHeaderRow()
{
TableSection = TableRowSection.TableHeader
};
TableHeaderCell ha = new TableHeaderCell();
TableHeaderCell hn = new TableHeaderCell();
TableHeaderCell hv = new TableHeaderCell();
th.CssClass = "unigrid-head";
ha.Text = GetString("unigrid.actions");
ha.CssClass = "unigrid-actions-header";
hn.Text = GetString("xmleditor.propertyname");
hn.Width = Unit.Pixel(180);
hv.Text = GetString("xmleditor.propertyvalue");
hv.Width = Unit.Pixel(500);
th.Cells.Add(ha);
th.Cells.Add(hn);
th.Cells.Add(hv);
tblData.Rows.Add(th);
ArrayList keys = new ArrayList(ht);
keys.Sort(new CustomStringComparer());
foreach (DictionaryEntry okey in keys)
{
String key = ValidationHelper.GetString(okey.Key, String.Empty);
String value = ValidationHelper.GetString(okey.Value, String.Empty);
bool isInvalid = (key == INVALIDTOKEN);
key = isInvalid ? invalidKey : key;
if (value == String.Empty)
{
continue;
}
TableRow tr = new TableRow();
// Actions
TableCell tna = new TableCell();
tna.CssClass = "unigrid-actions";
var imgEdit = new CMSGridActionButton();
imgEdit.OnClientClick = String.Format("displayEdit('{1}','{0}'); return false; ", key, ClientID);
imgEdit.IconCssClass = "icon-edit";
imgEdit.IconStyle = GridIconStyle.Allow;
imgEdit.ID = key + "_edit";
imgEdit.ToolTip = GetString("xmleditor.edititem");
var imgOK = new CMSGridActionButton();
imgOK.IconCssClass = "icon-check";
imgOK.IconStyle = GridIconStyle.Allow;
imgOK.OnClientClick = String.Format("approveCustomChanges('{0}','{1}');return false;", ClientID, key);
imgOK.ID = key + "_ok";
imgOK.ToolTip = GetString("xmleditor.approvechanges");
var imgDelete = new CMSGridActionButton();
imgDelete.OnClientClick = " if (confirm('" + GetString("xmleditor.deleteconfirm") + "')) {" + ControlsHelper.GetPostBackEventReference(tblData, "delete_" + key) + "} ;return false;";
imgDelete.IconCssClass = "icon-bin";
imgDelete.IconStyle = GridIconStyle.Critical;
imgDelete.ID = key + "_del";
imgDelete.ToolTip = GetString("xmleditor.deleteitem");
var imgUndo = new CMSGridActionButton();
imgUndo.OnClientClick = String.Format("if (confirm('" + GetString("xmleditor.confirmcancel") + "')) undoCustomChanges('{0}','{1}'); return false;", ClientID, key);
imgUndo.IconCssClass = "icon-arrow-crooked-left";
imgUndo.ID = key + "_undo";
imgUndo.ToolTip = GetString("xmleditor.undochanges");
tna.Controls.Add(imgEdit);
tna.Controls.Add(imgOK);
tna.Controls.Add(imgDelete);
tna.Controls.Add(imgUndo);
value = MacroSecurityProcessor.RemoveSecurityParameters(value, false, null);
// Labels
Label lblName = new Label();
lblName.ID = "sk" + key;
lblName.Text = key;
Label lblValue = new Label();
lblValue.ID = "sv" + key;
lblValue.Text = value;
// Textboxes
CMSTextBox txtName = new CMSTextBox();
txtName.Text = key;
txtName.ID = "tk" + key;
txtName.CssClass = "XmlEditorTextbox";
CMSTextBox txtValue = new CMSTextBox();
txtValue.Text = value;
txtValue.ID = "tv" + key;
txtValue.CssClass = "XmlEditorTextbox";
txtValue.Width = Unit.Pixel(490);
labels.Add(lblName);
labels.Add(lblValue);
textboxes.Add(txtName);
textboxes.Add(txtValue);
TableCell tcn = new TableCell();
tcn.Controls.Add(lblName);
tcn.Controls.Add(txtName);
TableCell tcv = new TableCell();
tcv.Controls.Add(lblValue);
tcv.Controls.Add(txtValue);
tr.Cells.Add(tna);
tr.Cells.Add(tcn);
tr.Cells.Add(tcv);
tblData.Rows.Add(tr);
lblValue.CssClass = String.Empty;
lblName.CssClass = "CustomEditorKeyClass";
if (isInvalid)
{
imgDelete.AddCssClass("hidden");
imgEdit.AddCssClass("hidden");
lblName.AddCssClass("hidden");
lblValue.AddCssClass("hidden");
RegisterEnableScript(false);
}
else
{
imgOK.AddCssClass("hidden");
imgUndo.AddCssClass("hidden");
txtName.CssClass += " hidden";
txtValue.CssClass += " hidden";
}
}
}
/// <summary>
/// Display DataSet content.
/// </summary>
/// <param name="ds">DataSet to display</param>
private void DisplayDataSet(DataSet ds)
{
if (!DataHelper.DataSourceIsEmpty(ds))
{
// Prepare list of tables
string excludedTableNames = (ExcludedTableNames != null) ? ";" + ExcludedTableNames.Trim(';').ToLowerCSafe() + ";" : "";
List<string> tables = new List<string>();
foreach (DataTable dt in ds.Tables)
{
if (!DataHelper.DataSourceIsEmpty(dt))
{
string tableName = dt.TableName;
if (!excludedTableNames.Contains(";" + tableName.ToLowerCSafe() + ";"))
{
tables.Add(tableName);
}
}
}
// Generate the tables ordered by object type display name
foreach (string tableName in tables.OrderBy(x => GetString("ObjectType." + x)))
{
DataTable dt = ds.Tables[tableName];
if (!DataHelper.DataSourceIsEmpty(dt))
{
if (ds.Tables.Count > 1)
{
plcContent.Controls.Add(new LiteralControl(GetTableHeaderText(dt)));
}
Table contentTable;
if (!ForceRowDisplayFormat && (dt.Columns.Count >= 6) && !dt.TableName.EqualsCSafe("ObjectTranslation", true))
{
// Write all rows
foreach (DataRow dr in dt.Rows)
{
contentTable = new Table();
SetTable(contentTable);
// Set first table as table property
if (Table == null)
{
Table = contentTable;
}
// Create table header
TableCell labelCell = new TableHeaderCell();
labelCell.Text = GetString("General.FieldName");
TableCell valueCell = new TableHeaderCell();
valueCell.Text = GetString("General.Value");
AddRow(contentTable, labelCell, valueCell, null, "unigrid-head", true);
// Add values
foreach (DataColumn dc in dt.Columns)
{
string content = GetRowColumnContent(dr, dc, false);
if (ShowAllFields || !String.IsNullOrEmpty(content))
{
labelCell = new TableCell();
labelCell.Text = "<strong>" + dc.ColumnName + "</strong>";
valueCell = new TableCell();
valueCell.Text = content;
AddRow(contentTable, labelCell, valueCell, null);
}
}
plcContent.Controls.Add(contentTable);
plcContent.Controls.Add(new LiteralControl("<br />"));
}
}
else
{
contentTable = new Table();
SetTable(contentTable);
// Add header
TableRow tr = new TableHeaderRow { TableSection = TableRowSection.TableHeader };
tr.CssClass = "unigrid-head";
int h = 1;
foreach (DataColumn column in dt.Columns)
{
TableHeaderCell th = new TableHeaderCell();
th.Text = ValidationHelper.GetString(column.Caption, column.ColumnName);
if (!ForceRowDisplayFormat && (h == dt.Columns.Count))
{
th.CssClass = "main-column-100";
}
tr.Cells.Add(th);
h++;
}
contentTable.Rows.Add(tr);
// Write all rows
foreach (DataRow dr in dt.Rows)
{
tr = new TableRow();
// Add values
foreach (DataColumn dc in dt.Columns)
{
TableCell tc = new TableCell();
object value = dr[dc.ColumnName];
// Possible DataTime columns
if ((dc.DataType == typeof(DateTime)) && (value != DBNull.Value))
{
DateTime dateTime = Convert.ToDateTime(value);
CultureInfo cultureInfo = CultureHelper.GetCultureInfo(MembershipContext.AuthenticatedUser.PreferredUICultureCode);
value = dateTime.ToString(cultureInfo);
}
string content = ValidationHelper.GetString(value, String.Empty);
tc.Text = EncodeDisplayedData ? HTMLHelper.HTMLEncode(content) : content;
if (!ForceRowDisplayFormat)
{
tc.Style.Add(HtmlTextWriterStyle.WhiteSpace, "nowrap");
}
tr.Cells.Add(tc);
}
contentTable.Rows.Add(tr);
}
plcContent.Controls.Add(contentTable);
plcContent.Controls.Add(new LiteralControl("<br />"));
}
}
}
}
else
{
Label lblError = new Label();
lblError.CssClass = "InfoLabel";
lblError.Text = GetString("general.nodatafound");
plcContent.Controls.Add(lblError);
}
}
protected void populate_goods()
{
//c# dynamic table populate base on database Goods data
Table itemTable = new Table();
TableHeaderRow thr = new TableHeaderRow();
itemTable.CssClass = "table table-bordered table-hover table-striped table-responsive thead-inverse";
TableHeaderCell imgHeader = new TableHeaderCell(); imgHeader.Text = "Image"; thr.Cells.Add(imgHeader);
TableHeaderCell thc_name = new TableHeaderCell(); thc_name.Text = "Name"; thr.Cells.Add(thc_name);
TableHeaderCell thc_venue = new TableHeaderCell(); thc_venue.Text = "Venue"; thr.Cells.Add(thc_venue);
TableHeaderCell thc_price = new TableHeaderCell(); thc_price.Text = "Price"; thr.Cells.Add(thc_price);
TableHeaderCell thc_desc = new TableHeaderCell(); thc_desc.Text = "Description"; thr.Cells.Add(thc_desc);
TableHeaderCell thc_time = new TableHeaderCell(); thc_time.Text = "Available"; thr.Cells.Add(thc_time);
TableHeaderCell thc_date = new TableHeaderCell(); thc_date.Text = "Date"; thr.Cells.Add(thc_date);
TableHeaderCell thc_addedby = new TableHeaderCell(); thc_addedby.Text = "Posted by"; thr.Cells.Add(thc_addedby);
TableHeaderCell thc_search = new TableHeaderCell(); thc_search.Text = "Trade This"; thr.Cells.Add(thc_search);
itemTable.Rows.Add(thr);
/*
* How to: Add Rows and Cells Dynamically to a Table Web Server Control. 2016.
* How to: Add Rows and Cells Dynamically to a Table Web Server Control.
* [ONLINE] Available at: https://msdn.microsoft.com/en-us/library/7bewx260.aspx. [Accessed 18 September 2017].
*/
//get items from list<> and loop through each item in items<> list
foreach (item item in getitems()) //return the object item and the obj item has all the attributes need to populate into table
{
TableRow newRow = new TableRow();
TableCell imgCell = new TableCell(); imgCell.Text = string.Format("<img src='/images/" + item.img + "' class='center-block' runat='server' Height='120px' Width='150px'/>"); newRow.Cells.Add(imgCell);
/*
* c# - How can I loop through a List and grab each item? - Stack Overflow. 2016. c# - How can I loop through a List and grab each item? - Stack Overflow.
* [ONLINE] Available at: http://stackoverflow.com/questions/18863187/how-can-i-loop-through-a-listt-and-grab-each-item. [Accessed 08 September 2017].
*/
TableCell nameCell = new TableCell(); nameCell.Text = item.ITEM; newRow.Cells.Add(nameCell);
TableCell venueCell = new TableCell(); venueCell.Text = item.venue; newRow.Cells.Add(venueCell);
TableCell priceCell = new TableCell(); priceCell.Text = (item.unit_price).ToString(); newRow.Cells.Add(priceCell);
TableCell descCell = new TableCell(); descCell.Text = item.description; newRow.Cells.Add(descCell);
TableCell timeCell = new TableCell(); timeCell.Text = item.available; newRow.Cells.Add(timeCell);
TableCell dateCell = new TableCell(); dateCell.Text = item.date; newRow.Cells.Add(dateCell);
TableCell addedBy = new TableCell(); addedBy.Text = (item.posted_by).ToString(); newRow.Cells.Add(addedBy);
TableCell itemBtnCell = new TableCell();
Button itemBtn = new Button();
itemBtn.Width = 100;
itemBtn.Height = 100;
itemBtn.BackColor = Color.Green;
itemBtn.ForeColor = Color.Red;
itemBtn.ID = item.id.ToString();
itemBtn.Text = "Manage";
itemBtn.CssClass = "btn-sm btn-success";
itemBtnCell.Controls.Add(itemBtn);
itemBtn.Click += new EventHandler(this.itemBtn_Click);
if (Session["id"] != null)
{
newRow.Cells.Add(itemBtnCell);
}
else
{
thc_search.Visible = false;
}
//newRow.Cells.Add(imgCell);
itemTable.Rows.Add(newRow);
}
good_ph.Controls.Add(itemTable);
}
protected void btnViewCart_Click(object sender, EventArgs e)
{
pnlBookSelectionView.Visible = false;
pnlShoppingCartView.Visible = true;
// Generate the table header
var tHead = new TableHeaderRow();
tblCart.Rows.Add(tHead);
var tHeadCellTitle = new TableHeaderCell();
var tHeadCellQuantity = new TableHeaderCell();
var tHeadCellSubtotal = new TableHeaderCell();
tHeadCellTitle.Text = "Title";
tHeadCellQuantity.Text = "Quantity";
tHeadCellSubtotal.Text = "Subtotal";
tHead.Cells.Add(tHeadCellTitle);
tHead.Cells.Add(tHeadCellQuantity);
tHead.Cells.Add(tHeadCellSubtotal);
ShoppingCart cart = ShoppingCart.RetrieveShoppingCart();
if (cart.IsEmpty)
{
var tRow = new TableRow();
tblCart.Rows.Add(tRow);
var tCell = new TableCell();
tCell.ColumnSpan = 3;
tCell.HorizontalAlign = HorizontalAlign.Center;
tCell.Text = "<span class='error'>Your shopping Cart is Empty</span>";
tRow.Cells.Add(tCell);
}
// Table generation loop
foreach (BookOrder order in cart.BookOrders)
{
// Start creating the table rows
var tRow = new TableRow();
tblCart.Rows.Add(tRow);
// Now the table cells
var tCellTitle = new TableCell();
var tCellQuantity = new TableCell();
var tCellSubtotal = new TableCell();
tCellTitle.Text = order.Book.Title;
tCellQuantity.Text = Convert.ToString(order.NumOfCopies);
tCellSubtotal.Text = Convert.ToString(String.Format("{0:C0}", order.Book.Price * order.NumOfCopies));
tRow.Cells.Add(tCellTitle);
tRow.Cells.Add(tCellQuantity);
tRow.Cells.Add(tCellSubtotal);
}
if (!cart.IsEmpty)
{
// Generate the table footer
var tFoot = new TableRow();
tblCart.Rows.Add(tFoot);
var tFootTotalLabel = new TableCell();
var tFootTotal = new TableCell();
tFootTotalLabel.Text = "Total";
tFootTotalLabel.HorizontalAlign = HorizontalAlign.Right;
tFootTotalLabel.ColumnSpan = 2;
tFootTotal.Text = Convert.ToString("$" + cart.TotalAmountPayable);
tFoot.Cells.Add(tFootTotalLabel);
tFoot.Cells.Add(tFootTotal);
}
}
/// <summary>
/// Function that is always called to recreate the table and all the check boxes
/// </summary>
private void GetMemberList()
{
tblResults.Rows.Clear();
lblEntryError.Text = String.Empty;
if (txtEntry.Text != String.Empty)
{
int userSearchType = rdSearchType.SelectedIndex;
int userID = 0;
string userEmail = String.Empty;
string userName = String.Empty;
string userIPAddress = String.Empty;
string userBBCUID = String.Empty;
string loginName = String.Empty;
if (userSearchType == 0)
{
try
{
userID = Convert.ToInt32(txtEntry.Text);
}
catch (System.FormatException Ex)
{
lblEntryError.Text = "Please enter a valid User ID";
System.Console.WriteLine(Ex.Message);
return;
}
}
else if (userSearchType == 1)
{
userEmail = txtEntry.Text;
}
else if (userSearchType == 2)
{
userName = txtEntry.Text;
}
else if (userSearchType == 3)
{
userIPAddress = txtEntry.Text;
}
else if (userSearchType == 4)
{
userBBCUID = txtEntry.Text;
try
{
Guid tmpBBCUID = new Guid(userBBCUID);
}
catch (System.FormatException Ex)
{
lblEntryError.Text = "Please enter a valid BBC UID";
System.Console.WriteLine(Ex.Message);
return;
}
}
else if (userSearchType == 5)
{
loginName = txtEntry.Text;
}
bool checkAllSites = false;
//Sets the get across all sites for the stored procedures
if (ViewingUser.IsSuperUser)
{
checkAllSites = true;
}
else
{
checkAllSites = false;
}
MemberList memberList = new MemberList(_basePage);
memberList.GenerateMemberListPageXml(userSearchType,
txtEntry.Text,
checkAllSites);
int count = 0;
TableHeaderRow headerRow = new TableHeaderRow();
headerRow.BackColor = Color.MistyRose;
int previousUserID = 0;
int accountCount = 0;
foreach (XmlNode node in memberList.RootElement.SelectNodes(@"MEMBERLIST/USERACCOUNTS/USERACCOUNT"))
{
if (count == 0)
{
//No header cell for the tickbox
TableHeaderCell headerfirstCheckBoxCell = new TableHeaderCell();
CheckBox checkBoxApplyAll = new CheckBox();
checkBoxApplyAll.ID = "ApplyToAll";
checkBoxApplyAll.Text = "Apply To All";
checkBoxApplyAll.Checked = ApplyToAllStatus;
checkBoxApplyAll.CheckedChanged += new EventHandler(ApplyToAll_CheckedChanged);
checkBoxApplyAll.AutoPostBack = true;
checkBoxApplyAll.EnableViewState = true;
checkBoxApplyAll.Attributes.Add("onfocus", "document.getElementById('__LASTFOCUS').value=this.id;");
headerfirstCheckBoxCell.Controls.Add(checkBoxApplyAll);
headerRow.Cells.Add(headerfirstCheckBoxCell);
TableHeaderCell headerFirstCell = new TableHeaderCell();
headerFirstCell.Text = "User ID";
headerFirstCell.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(headerFirstCell);
}
TableRow row = new TableRow();
TableCell firstCheckBoxCell = new TableCell();
firstCheckBoxCell.HorizontalAlign = HorizontalAlign.Center;
CheckBox checkBoxApply = new CheckBox();
checkBoxApply.ID = "Check" + count.ToString();
checkBoxApply.CheckedChanged += new EventHandler(ListApply_CheckedChanged);
checkBoxApply.AutoPostBack = true;
checkBoxApply.EnableViewState = true;
checkBoxApply.Attributes.Add("onfocus", "document.getElementById('__LASTFOCUS').value=this.id;");
firstCheckBoxCell.Controls.Add(checkBoxApply);
row.Cells.Add(firstCheckBoxCell);
TableCell firstCell = new TableCell();
firstCell.HorizontalAlign = HorizontalAlign.Center;
string userIDText = node.SelectSingleNode(@"@USERID").InnerText;
firstCell.Text = userIDText;
int currentUserID = Convert.ToInt32(userIDText);
if (currentUserID != previousUserID)
{
accountCount++;
previousUserID = currentUserID;
}
if (accountCount % 2 == 0)
row.BackColor = Color.LightGray;
else
row.BackColor = Color.Linen;
HyperLink link = new HyperLink();
link.NavigateUrl = "/dna/moderation/MemberDetails?userid=" + userIDText;
link.Text = "U" + userIDText;
firstCell.Controls.Add(link);
row.Cells.Add(firstCell);
foreach (XmlNode data in node.ChildNodes)
{
TableCell nextCell = new TableCell();
if (data.LocalName == "PREFSTATUS")
{
if (count == 0)
{
AddHeaderCell(headerRow, "STATUS");
}
HtmlImage img = new HtmlImage();
string path = @"/dnaimages/moderation/images/icons/status" + data.InnerText + ".gif";
//img.Src = String.Format("http://ops-dna2.national.core.bbc.co.uk/dnaimages/moderation/images/icons/status{0}.gif", data.InnerText);
img.Src = path;
img.Alt = data.ParentNode.SelectSingleNode("USERSTATUSDESCRIPTION").InnerText;
nextCell.HorizontalAlign = HorizontalAlign.Center;
nextCell.Controls.Add(img);
row.Cells.Add(nextCell);
}
else if (data.LocalName == "SITEID")
{
if (count == 0)
{
AddHeaderCell(headerRow, "SITEID");
}
nextCell.HorizontalAlign = HorizontalAlign.Center;
nextCell.Text = data.InnerText;
row.Cells.Add(nextCell);
}
else if (data.LocalName == "PREFSTATUSCHANGEDDATE")
{
if (count == 0)
{
AddHeaderCell(headerRow, "CHANGEDDATE");
}
nextCell.HorizontalAlign = HorizontalAlign.Center;
DateTime date = new DateTime();
string sortDate = String.Empty;
if (data.SelectSingleNode("DATE/@SORT") != null)
{
DateTimeFormatInfo UKDTFI = new CultureInfo("en-GB", false).DateTimeFormat;
sortDate = data.SelectSingleNode("DATE/@SORT").InnerText;
DateTime.TryParseExact(sortDate, "yyyyMMddHHmmss", UKDTFI, DateTimeStyles.NoCurrentDateDefault, out date);
nextCell.Text = date.ToString();
}
else
{
nextCell.Text = "";
}
row.Cells.Add(nextCell);
}
else if (data.LocalName == "PREFSTATUSDURATION")
{
if (count == 0)
{
AddHeaderCell(headerRow, "DURATION");
}
nextCell.HorizontalAlign = HorizontalAlign.Center;
nextCell.Text = memberList.GetPrefStatusDurationDisplayText(data.InnerText);
row.Cells.Add(nextCell);
}
else if (data.LocalName == "SHORTNAME")
{
if (count == 0)
{
AddHeaderCell(headerRow, "SITE");
}
nextCell.HorizontalAlign = HorizontalAlign.Center;
nextCell.Text = data.InnerText;
row.Cells.Add(nextCell);
}
else if ( data.LocalName != "USERSTATUSDESCRIPTION" &&
data.LocalName != "URLNAME")
{
if (count == 0)
{
AddHeaderCell(headerRow, data.LocalName);
}
nextCell.HorizontalAlign = HorizontalAlign.Center;
nextCell.Text = data.InnerText;
row.Cells.Add(nextCell);
}
}
tblResults.Rows.Add(row);
count++;
}
if (count == 0)
{
TableRow nodatarow = new TableRow();
TableCell nodataCell = new TableCell();
nodataCell.ColumnSpan = 4;
nodataCell.Text = @"No data for those details";
nodatarow.Cells.Add(nodataCell);
tblResults.Rows.Add(nodatarow);
Count.Text = "";
}
else
{
Count.Text = String.Format(@"There are {0} entries.", count.ToString());
}
tblResults.Rows.AddAt(0, headerRow);
tblResults.CellSpacing = 5;
tblResults.BorderWidth = 2;
tblResults.BorderStyle = BorderStyle.Outset;
}
}
protected void View_Companies_With_Average_Salary_DESC(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["iWorkDBConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("view_Company_by_highest_Average_Salary", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter output_message = cmd.Parameters.Add("@output_message", SqlDbType.Int);
output_message.Direction = ParameterDirection.Output;
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
TableHeaderRow tblhdrrw = new TableHeaderRow();
TableHeaderCell tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Average Salary"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrrw.Cells.Add(tblhdrcl);
tbl_output_table.Controls.Add(tblhdrrw);
while (rdr.Read())
{
TableRow tblrw = new TableRow();
TableCell tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetValue(rdr.GetOrdinal("AVG")).ToString()));
tblrw.Cells.Add(tblcl);
tbl_output_table.Controls.Add(tblrw);
}
rdr.Close();
if (!output_message.Value.ToString().Equals("2"))
{
tbl_output_table.Rows.Clear();
}
if (output_message.Value.ToString().Equals("0"))
{
Response.Write("Something Went Wrong. Please Contact The Website Admins Immediately!");
}
else if (output_message.Value.ToString().Equals("1"))
{
Response.Write("No Companies Saved On The Website Yet!");
}
}
private TableCell GetTable(bool IgnoreGeneration, RatePeriod[] ratePeriods, IEnumerable <SampleResponse> samples, String title, ref Decimal totalCost, Decimal generationRate, Decimal fuelSurcharge)
{
SampleResponse prevSample = samples.First();
Dictionary <Decimal, RatePeriodTotal> totalsByRatePeriod = ratePeriods.Select(x => x.rate + fuelSurcharge).Distinct().ToDictionary(x => x, x => new RatePeriodTotal());
foreach (var sample in samples)
{
var ratePeriod = ratePeriods.FirstOrDefault(x => x.days != null && x.days.Contains(prevSample.intervalTS.DayOfWeek) && x.months.Contains(prevSample.intervalTS.Month) && x.startHour <= prevSample.intervalTS.Hour && x.endHour >= prevSample.intervalTS.Hour);
if (ratePeriod == null)
{
ratePeriod = ratePeriods.First();
}
totalsByRatePeriod[ratePeriod.rate + fuelSurcharge].addValues(sample.consumption - prevSample.consumption, sample.generation - prevSample.generation);
prevSample = sample;
}
TableRow tr;
var table = new Table();
tr = new TableHeaderRow {
HorizontalAlign = HorizontalAlign.Center
};
tr.Cells.Add(new TableHeaderCell {
Text = title
});
table.Rows.Add(tr);
var tbl = new Table {
GridLines = GridLines.Both, CellPadding = 4
};
tr = new TableRow {
HorizontalAlign = HorizontalAlign.Center,
};
tr.Cells.Add(new TableHeaderCell {
Text = "Rate<br />(Cost/Net Usage)"
});
tr.Cells.Add(new TableHeaderCell {
Text = "Consumption"
});
if (!IgnoreGeneration)
{
tr.Cells.Add(new TableHeaderCell {
Text = "Generation"
});
tr.Cells.Add(new TableHeaderCell {
Text = "Net Usage"
});
tr.Cells.Add(new TableHeaderCell {
Text = "Effective Rate<br />(Cost/Consumption)"
});
}
tr.Cells.Add(new TableHeaderCell {
Text = "Cost"
});
tbl.Rows.Add(tr);
decimal totalConsumption = 0;
decimal totalGeneration = 0;
totalCost = 0;
foreach (var result in totalsByRatePeriod.Where(x => (x.Value.Consumption + x.Value.Generation) > 0))
{
var Generation = (IgnoreGeneration ? 0 : result.Value.Generation);
totalConsumption += result.Value.Consumption;
totalGeneration += Generation;
var netConsumption = (result.Value.Consumption - Generation);
var cost = netConsumption * (netConsumption < 0 ? generationRate : result.Key);
totalCost += cost;
if (ratePeriods.Count() > 1)
{
tr = new TableRow {
HorizontalAlign = HorizontalAlign.Right
};
tr.Cells.Add(new TableCell {
Text = result.Key.ToString("$.00")
});
tr.Cells.Add(new TableCell {
Text = result.Value.Consumption.ToString("0.00")
});
if (!IgnoreGeneration)
{
tr.Cells.Add(new TableCell {
Text = Generation.ToString("0.00")
});
tr.Cells.Add(new TableCell {
Text = netConsumption.ToString("0.00")
});
tr.Cells.Add(new TableCell {
Text = (cost / (result.Value.Consumption)).ToString("$.000")
});
}
tr.Cells.Add(new TableCell {
Text = cost.ToString("$0.00")
});
tbl.Rows.Add(tr);
}
}
var netUsage = totalConsumption - totalGeneration;
tr = new TableFooterRow {
HorizontalAlign = HorizontalAlign.Right, BackColor = Color.LightGray
};
tr.Cells.Add(new TableCell {
Text = ((totalCost / netUsage) >= 0 ? (totalCost / netUsage).ToString("$.000") : " --- ")
});
tr.Cells.Add(new TableCell {
Text = totalConsumption.ToString("0.00")
});
if (!IgnoreGeneration)
{
tr.Cells.Add(new TableCell {
Text = totalGeneration.ToString("0.00")
});
tr.Cells.Add(new TableCell {
Text = netUsage.ToString("0.00")
});
tr.Cells.Add(new TableCell {
Text = (totalCost / totalConsumption).ToString("$.000")
});
}
tr.Cells.Add(new TableCell {
Text = (totalCost).ToString("$0.00")
});
tbl.Rows.Add(tr);
tr = new TableRow();
var tc = new TableCell();
tc.Controls.Add(tbl);
tr.Cells.Add(tc);
table.Rows.Add(tr);
tc = new TableCell();
tc.Controls.Add(table);
return(tc);
}
protected void View_Certain_Company_Department(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["iWorkDBConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("view_certain_Company_Department_Job", conn);
cmd.CommandType = CommandType.StoredProcedure;
string domain_name = arraylist_company_domain_name[drpdwnlst_view_certain_department_company_company.SelectedIndex].ToString();
string dep_code = arraylist_department_code[drpdwnlst_view_certain_department_company_department.SelectedIndex].ToString();
cmd.Parameters.AddWithValue("@company_domain", domain_name);
cmd.Parameters.AddWithValue("@dep_code", dep_code);
SqlParameter output_message = cmd.Parameters.Add("@output_message", SqlDbType.Int);
output_message.Direction = ParameterDirection.Output;
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
tbl_output_table.Rows.Clear();
TableHeaderRow tblhdrrw = new TableHeaderRow();
TableHeaderCell tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Department's Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Department's Code"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Domain"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Available Job(s)' Title"));
tblhdrrw.Cells.Add(tblhdrcl);
tbl_output_table.Controls.Add(tblhdrrw);
while (rdr.Read())
{
TableRow tblrw = new TableRow();
TableCell tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("dep_name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("code"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("company_domain_name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("title")) + "<br />"));
while (rdr.Read())
{
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("title")) + "<br />"));
}
tblrw.Cells.Add(tblcl);
tbl_output_table.Controls.Add(tblrw);
}
rdr.Close();
if (!output_message.Value.ToString().Equals("7"))
{
tbl_output_table.Rows.Clear();
}
if (output_message.Value.ToString().Equals("0") || output_message.Value.ToString().Equals("1") || output_message.Value.ToString().Equals("2"))
{
Response.Write("Something Went Wrong. Please Contact The Website Admins Immediately!");
}
else if (output_message.Value.ToString().Equals("3"))
{
Response.Write("Company Was Not Found!");
}
else if (output_message.Value.ToString().Equals("4"))
{
Response.Write("Department Was not Found!");
}
else if (output_message.Value.ToString().Equals("5"))
{
Response.Write("This Department Is Not Part Of This Company!");
}
else if (output_message.Value.ToString().Equals("6"))
{
Response.Write("This Department Has No Available Jobs!");
}
}
protected void Search_For_Job_With_Vacancies_Keyword(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["iWorkDBConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("search_for_Job_with_Vacancies_by_Keyword", conn);
cmd.CommandType = CommandType.StoredProcedure;
string keyword = txtbox_search_for_job_vacancies_keyword.Text;
cmd.Parameters.AddWithValue("@keyword", keyword);
SqlParameter output_message = cmd.Parameters.Add("@output_message", SqlDbType.Int);
output_message.Direction = ParameterDirection.Output;
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
TableHeaderRow tblhdrrw = new TableHeaderRow();
TableHeaderCell tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Department's Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Job's Title"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Job's Detailed Description"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Job's Short Description"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Job's Minimum Years Of Experience"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Job's Salary"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Job's Application Deadline"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Job's Work Hours"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Job's Number Of Vacancies"));
tblhdrrw.Cells.Add(tblhdrcl);
tbl_output_table.Controls.Add(tblhdrrw);
while (rdr.Read())
{
TableRow tblrw = new TableRow();
TableCell tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("dep_name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("title"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("detailed_description"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("short_description"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetValue(rdr.GetOrdinal("minimum_years_of_experience")).ToString()));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetValue(rdr.GetOrdinal("salary")).ToString()));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetValue(rdr.GetOrdinal("application_deadline")).ToString()));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetValue(rdr.GetOrdinal("work_hours")).ToString()));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetValue(rdr.GetOrdinal("number_of_vacancies")).ToString()));
tblrw.Cells.Add(tblcl);
tbl_output_table.Controls.Add(tblrw);
}
rdr.Close();
if (!output_message.Value.ToString().Equals("4"))
{
tbl_output_table.Rows.Clear();
}
if (output_message.Value.ToString().Equals("0"))
{
Response.Write("Something Went Wrong. Please Contact The Website Admins Immediately!");
}
else if (output_message.Value.ToString().Equals("1"))
{
Response.Write("Search Box Is Empty!");
}
else if (output_message.Value.ToString().Equals("2"))
{
Response.Write("NULL Input(s)!");
}
else if (output_message.Value.ToString().Equals("3"))
{
Response.Write("No Job Found With Such Keyword(s)!");
}
}
protected void View_Certain_Company(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["iWorkDBConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("view_certain_Company_Department", conn);
cmd.CommandType = CommandType.StoredProcedure;
string domain_name = arraylist_company_domain_name[drpdwnlst_view_certain_Company.SelectedIndex].ToString();
cmd.Parameters.AddWithValue("@domain_name", domain_name);
SqlParameter output_message = cmd.Parameters.Add("@output_message", SqlDbType.Int);
output_message.Direction = ParameterDirection.Output;
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
tbl_output_table.Rows.Clear();
TableHeaderRow tblhdrrw = new TableHeaderRow();
TableHeaderCell tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Domain Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Address"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Email"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Vision"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Type"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Specialization"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Phone Number(s)"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Department(s)' Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tbl_output_table.Controls.Add(tblhdrrw);
while (rdr.Read())
{
TableRow tblrw = new TableRow();
TableCell tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("domain_name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("address"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("email"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("vision"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("type"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("field_of_specialization"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
SqlConnection conn2 = new SqlConnection(connStr);
SqlCommand cmd2 = new SqlCommand("view_Phone_Numbers", conn2);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add("@company_domain", rdr.GetString(rdr.GetOrdinal("domain_name")));
SqlParameter output_message2 = cmd2.Parameters.Add("@output_message", SqlDbType.Int);
output_message2.Direction = ParameterDirection.Output;
conn2.Open();
SqlDataReader rdr2 = cmd2.ExecuteReader(CommandBehavior.CloseConnection);
while (rdr2.Read())
{
tblcl.Controls.Add(new LiteralControl(rdr2.GetString(rdr2.GetOrdinal("phone_number")) + "<br />"));
}
tblrw.Cells.Add(tblcl);
rdr2.Close();
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("dep_name")) + "<br />" + "<br />"));
while (rdr.Read())
{
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("dep_name")) + "<br />" + "<br />"));
}
tblrw.Cells.Add(tblcl);
tbl_output_table.Controls.Add(tblrw);
}
rdr.Close();
if (!output_message.Value.ToString().Equals("4"))
{
tbl_output_table.Rows.Clear();
}
if (output_message.Value.ToString().Equals("0") || output_message.Value.ToString().Equals("2"))
{
Response.Write("Something Went Wrong. Please Contact The Website Admins Immediately!");
}
else if (output_message.Value.ToString().Equals("1"))
{
Response.Write("No Companies Saved On The Website Yet!");
}
else if (output_message.Value.ToString().Equals("3"))
{
Response.Write("This Company Has No Departments!");
}
}
protected void Search_Company_By(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["iWorkDBConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("view_all_companies", conn);
cmd.CommandType = CommandType.StoredProcedure;
string search_keyword = txtbox_search_company_by.Text;
if (drpdwnlst_search_company_by.SelectedIndex.ToString().Equals("0"))
{
cmd.CommandText = "search_for_Company_by_Name";
cmd.Parameters.AddWithValue("@name", search_keyword);
}
else if (drpdwnlst_search_company_by.SelectedIndex.ToString().Equals("1"))
{
cmd.CommandText = "search_for_Company_by_Address";
cmd.Parameters.AddWithValue("@address", search_keyword);
}
else if (drpdwnlst_search_company_by.SelectedIndex.ToString().Equals("2"))
{
cmd.CommandText = "search_for_Company_by_Type";
cmd.Parameters.AddWithValue("@type", search_keyword);
}
SqlParameter output_message = cmd.Parameters.Add("@output_message", SqlDbType.Int);
output_message.Direction = ParameterDirection.Output;
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
tbl_output_table.Rows.Clear();
TableHeaderRow tblhdrrw = new TableHeaderRow();
TableHeaderCell tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Domain Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Name"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Address"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Email"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Vision"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Type"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Specialization"));
tblhdrrw.Cells.Add(tblhdrcl);
tblhdrcl = new TableHeaderCell();
tblhdrcl.Controls.Add(new LiteralControl("Company's Phone Number(s)"));
tblhdrrw.Cells.Add(tblhdrcl);
tbl_output_table.Controls.Add(tblhdrrw);
bool selected = false;
while (rdr.Read())
{
if (!selected)
{
drpdwnlst_view_certain_Company.SelectedIndex = arraylist_company_domain_name.IndexOf(rdr.GetString(rdr.GetOrdinal("domain_name")));
selected = true;
}
TableRow tblrw = new TableRow();
TableCell tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("domain_name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("name"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("address"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("email"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("vision"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("type"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
tblcl.Controls.Add(new LiteralControl(rdr.GetString(rdr.GetOrdinal("field_of_specialization"))));
tblrw.Cells.Add(tblcl);
tblcl = new TableCell();
SqlConnection conn2 = new SqlConnection(connStr);
SqlCommand cmd2 = new SqlCommand("view_Phone_Numbers", conn2);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add("@company_domain", rdr.GetString(rdr.GetOrdinal("domain_name")));
SqlParameter output_message2 = cmd2.Parameters.Add("@output_message", SqlDbType.Int);
output_message2.Direction = ParameterDirection.Output;
conn2.Open();
SqlDataReader rdr2 = cmd2.ExecuteReader(CommandBehavior.CloseConnection);
while (rdr2.Read())
{
tblcl.Controls.Add(new LiteralControl(rdr2.GetString(rdr2.GetOrdinal("phone_number")) + "<br />"));
}
tblrw.Cells.Add(tblcl);
rdr2.Close();
tbl_output_table.Controls.Add(tblrw);
}
rdr.Close();
if (!output_message.Value.ToString().Equals("4"))
{
tbl_output_table.Rows.Clear();
}
if (output_message.Value.ToString().Equals("0"))
{
Response.Write("Invalid Input(s)");
}
else if (output_message.Value.ToString().Equals("1"))
{
Response.Write("Search Box Is Empty!");
}
else if (output_message.Value.ToString().Equals("2"))
{
Response.Write("NULL Input(s)");
}
else if (output_message.Value.ToString().Equals("3"))
{
Response.Write("No Companies With That Search Found!");
}
}
public void loadUsers()
{
List <UserAccount> liste = u.Users.Where(u => u.Role == "Garage").ToList();
TableRow th, tr;
TableHeaderCell HId, HFirstName, HLastName, HEmail, HPhoneNumber, HPassword, HUpdate;
TableCell IdCell, FirstName, LastName, Email, PhoneNumber, Password, UpdateCell;
TableGarages.Rows.Clear();
HId = new TableHeaderCell()
{
Text = "Id"
};
HFirstName = new TableHeaderCell()
{
Text = "Prenom"
};
HLastName = new TableHeaderCell()
{
Text = "Nom"
};
HEmail = new TableHeaderCell()
{
Text = "Email"
};
HPhoneNumber = new TableHeaderCell()
{
Text = "Téléphone"
};
HPassword = new TableHeaderCell()
{
Text = "Mot de Passe"
};
HUpdate = new TableHeaderCell()
{
Text = "Modifier"
};
th = new TableHeaderRow()
{
Cells =
{
HId, HFirstName, HLastName, HEmail, HPhoneNumber, HUpdate, HPassword
}
};
TableGarages.Rows.Add(th);
if (liste != null)
{
foreach (UserAccount us in liste)
{
IdCell = new TableCell()
{
Text = us.UserId.ToString()
};
FirstName = new TableCell()
{
Text = us.FirstName
};
LastName = new TableCell()
{
Text = us.LastName
};
Email = new TableCell()
{
Text = us.Email
};
PhoneNumber = new TableCell()
{
Text = us.PhoneNumber.ToString()
};
Password = new TableCell();
UpdateCell = new TableCell();
UpdateUserlink = new LinkButton
{
Text = "Modifier",
ID = "updateLink" + us.UserId
};
UpdateUserlink.Click += new EventHandler(popupUpdatePanel);
UpdateCell.Controls.Add(UpdateUserlink);
LinkButton ViewPass = new LinkButton
{
Text = "View",
ID = "View" + us.UserId
};
ViewPass.Click += new EventHandler(ViewPassword);
Password.Controls.Add(ViewPass);
tr = new TableRow()
{
Cells =
{
IdCell, FirstName, LastName, Email, PhoneNumber, UpdateCell, Password
}
};
TableGarages.Rows.Add(tr);
}
}
}
private void ShowRuntime()
{
ResultList.Rows.Clear();
TableHeaderRow header = new TableHeaderRow();
TableHeaderCell[] head = new TableHeaderCell[2];
for (int i = 0; i <= 1; i++) head[i] = new TableHeaderCell();
head[0].Width = new Unit(10f, UnitType.Percentage);
head[0].Text = StringDef.Name;
head[1].Width = new Unit(30f, UnitType.Percentage);
head[1].Text = StringDef.Message;
header.Cells.AddRange(head);
ResultList.Rows.Add(header);
ShowRunResult();
}
protected void view_status_requests(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["iWorkDBConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("view_status_of_requests", conn);
cmd.CommandType = CommandType.StoredProcedure;
string username = Session["username"].ToString();
cmd.Parameters.Add(new SqlParameter("@username", username));
SqlParameter printStat = cmd.Parameters.Add("@out", SqlDbType.Int);
printStat.Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
if (printStat.Value.ToString().Equals("1"))
{
Response.Write("user did not submit a request");
}
else if (printStat.Value.ToString().Equals("3"))
{
Response.Write("username is incorrect");
}
else if (printStat.Value.ToString().Equals("2"))
{
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
TableHeaderRow hdr = new TableHeaderRow();
TableHeaderCell hdrcl = new TableHeaderCell();
TableHeaderCell hdrcl1 = new TableHeaderCell();
TableHeaderCell hdrcl2 = new TableHeaderCell();
TableHeaderCell hdrcl3 = new TableHeaderCell();
TableHeaderCell hdrcl4 = new TableHeaderCell();
TableHeaderCell hdrcl5 = new TableHeaderCell();
TableHeaderCell hdrcl6 = new TableHeaderCell();
TableHeaderCell hdrcl7 = new TableHeaderCell();
TableHeaderCell hdrcl8 = new TableHeaderCell();
TableHeaderCell hdrcl9 = new TableHeaderCell();
TableHeaderCell hdrcl10 = new TableHeaderCell();
hdrcl.Controls.Add(new LiteralControl("request_id"));
hdrcl1.Controls.Add(new LiteralControl("filing_date"));
hdrcl2.Controls.Add(new LiteralControl("start_date"));
hdrcl3.Controls.Add(new LiteralControl("end_date"));
hdrcl4.Controls.Add(new LiteralControl("number_of_days"));
hdrcl5.Controls.Add(new LiteralControl("status"));
hdrcl6.Controls.Add(new LiteralControl("hr_approval"));
hdrcl7.Controls.Add(new LiteralControl("manager_approval"));
hdrcl8.Controls.Add(new LiteralControl("manager_reason"));
hdrcl9.Controls.Add(new LiteralControl("hr_employee_username"));
hdrcl10.Controls.Add(new LiteralControl("manager_username"));
hdr.Cells.Add(hdrcl);
hdr.Cells.Add(hdrcl1);
hdr.Cells.Add(hdrcl2);
hdr.Cells.Add(hdrcl3);
hdr.Cells.Add(hdrcl4);
hdr.Cells.Add(hdrcl5);
hdr.Cells.Add(hdrcl6);
hdr.Cells.Add(hdrcl7);
hdr.Cells.Add(hdrcl8);
hdr.Cells.Add(hdrcl9);
hdr.Cells.Add(hdrcl10);
tbl_view_status_of_requests.Rows.Add(hdr);
DropDownListRequestID.Items.Clear();
while (rdr.Read())
{
string request_id = rdr.GetValue(rdr.GetOrdinal("request_id")).ToString();
string filing_date = rdr.GetValue(rdr.GetOrdinal("filing_date")).ToString();
string start_date = rdr.GetValue(rdr.GetOrdinal("start_date")).ToString();
string end_date = (rdr.GetValue(rdr.GetOrdinal("end_date"))).ToString();
string number_of_days = rdr.GetValue(rdr.GetOrdinal("number_of_days")).ToString();
string status = rdr.GetValue(rdr.GetOrdinal("status")).ToString();
string hr_approval = rdr.GetValue(rdr.GetOrdinal("hr_approval")).ToString();
string manager_approval = rdr.GetValue(rdr.GetOrdinal("manager_approval")).ToString();
string manager_reason = rdr.GetValue(rdr.GetOrdinal("manager_reason")).ToString();
string hr_employee_username = rdr.GetValue(rdr.GetOrdinal("hr_employee_username")).ToString();
string manager_username = rdr.GetValue(rdr.GetOrdinal("manager_username")).ToString();
DropDownListRequestID.Items.Add(new ListItem(request_id));
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
TableCell cell2 = new TableCell();
TableCell cell3 = new TableCell();
TableCell cell4 = new TableCell();
TableCell cell5 = new TableCell();
TableCell cell6 = new TableCell();
TableCell cell7 = new TableCell();
TableCell cell8 = new TableCell();
TableCell cell9 = new TableCell();
TableCell cell10 = new TableCell();
TableCell cell11 = new TableCell();
cell1.Controls.Add(new LiteralControl(request_id));
cell2.Controls.Add(new LiteralControl(filing_date));
cell3.Controls.Add(new LiteralControl(start_date));
cell4.Controls.Add(new LiteralControl(end_date));
cell5.Controls.Add(new LiteralControl(number_of_days));
cell6.Controls.Add(new LiteralControl(status));
cell7.Controls.Add(new LiteralControl(hr_approval));
cell8.Controls.Add(new LiteralControl(manager_approval));
cell9.Controls.Add(new LiteralControl(manager_reason));
cell10.Controls.Add(new LiteralControl(hr_employee_username));
cell11.Controls.Add(new LiteralControl(manager_username));
row.Cells.Add(cell1);
row.Cells.Add(cell2);
row.Cells.Add(cell3);
row.Cells.Add(cell4);
row.Cells.Add(cell5);
row.Cells.Add(cell6);
row.Cells.Add(cell7);
row.Cells.Add(cell8);
row.Cells.Add(cell9);
row.Cells.Add(cell10);
row.Cells.Add(cell11);
tbl_view_status_of_requests.Rows.Add(row);
}
}
}
private TableHeaderRow CreateTableHeaderRow(SqlDataReader reader, Data dataType)
{
int fieldCount = reader.FieldCount;
TableHeaderRow currentRow = new TableHeaderRow();
for (int f = 0; f < fieldCount; f++)
{
// Grab the field name and value
String currentField = reader.GetName(f);
String currentValue = reader.GetValue(f).ToString();
TableCell currentCell = null;
switch (dataType)
{
case Data.NAME:
currentCell = CreateTableCell(currentField);
break;
case Data.VALUE:
currentCell = CreateTableCell(currentValue);
break;
}
currentRow.Controls.Add(currentCell);
}
return currentRow;
}
protected void view_announcements(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["iWorkDBConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("view_announcements", conn);
cmd.CommandType = CommandType.StoredProcedure;
string username = Session["username"].ToString();
cmd.Parameters.Add(new SqlParameter("@username", username));
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
TableHeaderRow hdr = new TableHeaderRow();
TableHeaderCell hdrcl = new TableHeaderCell();
TableHeaderCell hdrcl1 = new TableHeaderCell();
TableHeaderCell hdrcl2 = new TableHeaderCell();
TableHeaderCell hdrcl3 = new TableHeaderCell();
TableHeaderCell hdrcl4 = new TableHeaderCell();
TableHeaderCell hdrcl5 = new TableHeaderCell();
hdrcl.Controls.Add(new LiteralControl("a_id"));
hdrcl1.Controls.Add(new LiteralControl("date"));
hdrcl2.Controls.Add(new LiteralControl("description"));
hdrcl3.Controls.Add(new LiteralControl("type"));
hdrcl4.Controls.Add(new LiteralControl("title"));
hdrcl5.Controls.Add(new LiteralControl("company_domain_name"));
hdr.Cells.Add(hdrcl);
hdr.Cells.Add(hdrcl1);
hdr.Cells.Add(hdrcl2);
hdr.Cells.Add(hdrcl3);
hdr.Cells.Add(hdrcl4);
hdr.Cells.Add(hdrcl5);
tbl_announcements.Rows.Add(hdr);
while (rdr.Read())
{
string a_id = rdr.GetValue(rdr.GetOrdinal("a_id")).ToString();
string date = rdr.GetValue(rdr.GetOrdinal("date")).ToString();
string description = rdr.GetValue(rdr.GetOrdinal("description")).ToString();
string type = (rdr.GetValue(rdr.GetOrdinal("type"))).ToString();
string title = rdr.GetValue(rdr.GetOrdinal("title")).ToString();
string company_domain_name = rdr.GetValue(rdr.GetOrdinal("company_domain_name")).ToString();
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
TableCell cell2 = new TableCell();
TableCell cell3 = new TableCell();
TableCell cell4 = new TableCell();
TableCell cell5 = new TableCell();
TableCell cell6 = new TableCell();
cell1.Controls.Add(new LiteralControl(a_id));
cell2.Controls.Add(new LiteralControl(date));
cell3.Controls.Add(new LiteralControl(description));
cell4.Controls.Add(new LiteralControl(type));
cell5.Controls.Add(new LiteralControl(title));
cell6.Controls.Add(new LiteralControl(company_domain_name));
row.Cells.Add(cell1);
row.Cells.Add(cell2);
row.Cells.Add(cell3);
row.Cells.Add(cell4);
row.Cells.Add(cell5);
row.Cells.Add(cell6);
tbl_announcements.Rows.Add(row);
}
}
protected void initializeHeaderRows()
{
foreach (KeyValuePair<string, Table> pair in symptomNameTable)
{
Table symptomTable = pair.Value;
String symptomName = pair.Key;
TableHeaderRow headerRow = new TableHeaderRow();
TableHeaderCell headerWhenCell = new TableHeaderCell();
headerWhenCell.Text = "When";
headerRow.Cells.Add(headerWhenCell);
TableHeaderCell headerNameCell = new TableHeaderCell();
headerNameCell.Text = symptomName + " Scale";
headerRow.Cells.Add(headerNameCell);
symptomTable.Rows.Add(headerRow);
}
}
protected void View_Attendance_Records(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["iWorkDBConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("view_attendance_records", conn);
cmd.CommandType = CommandType.StoredProcedure;
String username = Session["username"].ToString();
DateTime start = DateTime.Parse(TextBox2.Text);
DateTime end = DateTime.Parse(TextBox3.Text);
cmd.Parameters.Add(new SqlParameter("@username", username));
cmd.Parameters.Add(new SqlParameter("@start", start));
cmd.Parameters.Add(new SqlParameter("@end", end));
SqlParameter printStat = cmd.Parameters.Add("@out", SqlDbType.Int);
printStat.Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
if (printStat.Value.ToString().Equals("1"))
{
Response.Write("Please do not leave any empty fields");
}
else if (printStat.Value.ToString().Equals("3"))
{
Response.Write("no records for this username in the specified period");
}
else if (printStat.Value.ToString().Equals("2"))
{
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
TableHeaderRow hdr = new TableHeaderRow();
TableHeaderCell hdrcl = new TableHeaderCell();
TableHeaderCell hdrcl1 = new TableHeaderCell();
TableHeaderCell hdrcl2 = new TableHeaderCell();
TableHeaderCell hdrcl3 = new TableHeaderCell();
hdrcl.Controls.Add(new LiteralControl("start_time"));
hdrcl1.Controls.Add(new LiteralControl("end_time"));
hdrcl2.Controls.Add(new LiteralControl("duration"));
hdrcl3.Controls.Add(new LiteralControl("missing_hours"));
hdr.Cells.Add(hdrcl);
hdr.Cells.Add(hdrcl1);
hdr.Cells.Add(hdrcl2);
hdr.Cells.Add(hdrcl3);
tbl_attendance_records.Rows.Add(hdr);
while (rdr.Read())
{
string start_time = rdr.GetValue(rdr.GetOrdinal("start_time")).ToString();
string end_time = rdr.GetValue(rdr.GetOrdinal("end_time")).ToString();
string duration = rdr.GetString(rdr.GetOrdinal("duration"));
string missing_hours = (rdr.GetValue(rdr.GetOrdinal("missing_hours"))).ToString();
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
TableCell cell2 = new TableCell();
TableCell cell3 = new TableCell();
TableCell cell4 = new TableCell();
cell1.Controls.Add(new LiteralControl(start_time));
cell2.Controls.Add(new LiteralControl(end_time));
cell3.Controls.Add(new LiteralControl(duration));
cell4.Controls.Add(new LiteralControl(missing_hours));
row.Cells.Add(cell1);
row.Cells.Add(cell2);
row.Cells.Add(cell3);
row.Cells.Add(cell4);
tbl_attendance_records.Rows.Add(row);
}
}
}
protected void View3_Activate(object sender, EventArgs e)
{
int count = v2table.Rows.Count - 1; //this is -1 because the first row is header cells
string[] fields = new string[count];
string[] types = new string[count];
bool[] checks = new bool[count];
//get the values entered in v2table controls, ignoring headers
for (int i = 1; i <= count; i++) //start at 1 to ignore headers, and include the last row with <=
{
TextBox t = (TextBox)v2table.Rows[i].Cells[0].Controls[0];
DropDownList d = (DropDownList)v2table.Rows[i].Cells[1].Controls[0];
CheckBox c = (CheckBox)v2table.Rows[i].Cells[2].Controls[0];
fields[i - 1] = t.Text; //-1 for both these because arrays uses zero index
types[i - 1] = d.SelectedValue;
if (c.Checked)
checks[i - 1] = true;
else
checks[i - 1] = false;
}
//v3table header
TableHeaderRow rh = new TableHeaderRow();
TableHeaderCell hc = new TableHeaderCell();
hc.ColumnSpan = 3;
hc.Text = v1txtName.Text;
rh.Cells.Add(hc);
v3table.Rows.Add(rh);
//put values in a v3 summary table
for (int i = 1; i <= count; i++)//start at 1 to ignore headers, and include the last row with <=
{
TableRow r = new TableRow();
TableCell c1 = new TableCell();
TableCell c2 = new TableCell();
TableCell c3 = new TableCell();
c1.Text = "<b>" + fields[i-1].ToString() + "</b>: "; //-1 because of previous zero index
c2.Text = types[i-1].ToString(); //-1 same reason
if (checks[i - 1] == true)
{
c3.Text = " * Required";
}
r.Cells.Add(c1); r.Cells.Add(c2); r.Cells.Add(c3);
v3table.Rows.Add(r);
}
Session["fields"] = fields;
Session["types"] = types;
Session["checks"] = checks;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
if (!Page.IsPostBack)
{
//โหลดสำนักงาน
string sql = "Select * From LEARNING_CENTER Order By LEARNING_CEN_CODE";
learnData = learnObj.getLearningCenterManual(sql);
// Head Table
string[] ar = { "รหัส", "ชื่อศูนย์การเรียนรู้ (Thai)", "ชื่อศูนย์การเรียนรู้ (English)", "สถานะ", "แก้ไข", "ลบ" };
//Table tb1 = new Table();
tblLearningCenter.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblLearningCenter.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++)
{
// Create a new cell and add it to the row.
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar[cellCtr - 1];
if (cellCtr == 1 || cellCtr > 3)
{
cellHead.Width = 100;
}
tRowHead.Cells.Add(cellHead);
}
tblLearningCenter.Rows.Add(tRowHead);
foreach (LearningCenterData data in learnData)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TableCell cellLearnCode = new TableCell();
cellLearnCode.Text = data.LearningCenter_Code;
tRowBody.Cells.Add(cellLearnCode);
TableCell cellLearnThai = new TableCell();
cellLearnThai.Text = data.LearningCenter_Thai;
tRowBody.Cells.Add(cellLearnThai);
TableCell cellLearnEng = new TableCell();
cellLearnEng.Text = data.LearningCenter_Eng;
tRowBody.Cells.Add(cellLearnEng);
TableCell cellStatus = new TableCell();
//0001 = ใช้งาน
if (data.LearningCenter_Status == "0001")
{
cellStatus.Text = "<h4 class='txt-color-green'><i class='fa fa-check'></i></h4>";
cellStatus.ToolTip = "ใช้งาน";
}
//0002 = ไม่ใช้งาน
if (data.LearningCenter_Status == "0002")
{
cellStatus.Text = "<h4 class='txt-color-red'><i class='fa fa-times'></i></h4>";
cellStatus.ToolTip = "ไม่ใช้งาน";
}
cellStatus.CssClass = "text-center";
tRowBody.Cells.Add(cellStatus);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_Learning_Center.aspx?token=" + data.LearningCenter_Code;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLearning_Center");
hypEdit.Attributes.Add("data-toggle", "modal");
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
cellEdit.CssClass = "text-center";
tRowBody.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
//string urlDel = "#";
string urlDel = "delete_Learning_Center.aspx?token=" + data.LearningCenter_Code;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLearning_Center");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDel.Controls.Add(hypDel);
cellDel.CssClass = "text-center";
tRowBody.Cells.Add(cellDel);
tblLearningCenter.Rows.Add(tRowBody);
}
} //end !Page.IsPostBack
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
//function to retrive the features based on product
private void GetProductFeatures()
{
int serialNo = 1;
DataTable tab = new DataTable();
BLL obj = new BLL();
try
{
txtProductName.Value = Request.QueryString["productName"].ToString();
txtProductName.Disabled = true;
tab = obj.GetFeaturesByCategory(int.Parse(Request.QueryString["categoryId"].ToString()));
if (tab.Rows.Count > 0)
{
tableFeatures.Rows.Clear();
tableFeatures.BorderStyle = BorderStyle.Double;
tableFeatures.GridLines = GridLines.Both;
tableFeatures.BorderColor = System.Drawing.Color.DarkGray;
TableRow headerrow = new TableRow();
headerrow.Height = 30;
headerrow.ForeColor = System.Drawing.Color.WhiteSmoke;
headerrow.BackColor = System.Drawing.Color.Gray;
TableCell cell1 = new TableCell();
cell1.Text = "<b>SLNo</b>";
headerrow.Controls.Add(cell1);
TableCell cell3 = new TableCell();
cell3.Text = "<b>Feature Name</b>";
headerrow.Controls.Add(cell3);
TableCell cell4 = new TableCell();
cell4.Text = "<b>Value</b>";
headerrow.Controls.Add(cell4);
tableFeatures.Controls.Add(headerrow);
for (int cnt = 0; cnt < tab.Rows.Count; cnt++)
{
TableRow row = new TableRow();
row.Height = 35;
TableCell cellSerialNo = new TableCell();
cellSerialNo.Width = 10;
cellSerialNo.Font.Size = 10;
cellSerialNo.Text = serialNo + cnt + ".";
row.Controls.Add(cellSerialNo);
TableCell cellFeature = new TableCell();
cellFeature.Width = 250;
DataTable tabFeature = new DataTable();
tabFeature = obj.GetFeatureById(int.Parse(tab.Rows[cnt]["FeatureId"].ToString()));
cellFeature.Text = tabFeature.Rows[0]["Feature"].ToString();
row.Controls.Add(cellFeature);
DataTable tabvalues = new DataTable();
tabvalues = obj.GetValuesByFeature(int.Parse(tab.Rows[cnt]["FeatureId"].ToString()));
TableCell cellvalue = new TableCell();
DropDownList dropdownlistValue = new DropDownList();
dropdownlistValue.Width = 200;
int num = serialNo + cnt;
dropdownlistValue.ID = num.ToString();
if (tabvalues.Rows.Count > 0)
{
for (int i = 0; i < tabvalues.Rows.Count; i++)
{
ListItem item = new ListItem(tabvalues.Rows[i]["Value"].ToString(), tabvalues.Rows[i]["ValueId"].ToString());
dropdownlistValue.Items.Add(item);
}
}
else
{
ListItem item = new ListItem("Notset", "Notset");
dropdownlistValue.Items.Add(item);
}
DataTable tabproductFeature = new DataTable();
tabproductFeature = obj.GetProductFeatures(int.Parse(Request.QueryString["productId"].ToString()));
if (tabproductFeature.Rows.Count > 0)
{
string valueText = dropdownlistValue.Items.FindByValue(tabproductFeature.Rows[cnt]["ValueId"].ToString()).ToString();
ListItem itemValue = new ListItem(valueText, tabproductFeature.Rows[cnt]["ValueId"].ToString());
int Index = dropdownlistValue.Items.IndexOf(itemValue);
if (Index != -1)
{
dropdownlistValue.SelectedIndex = Index;
}
}
cellvalue.Controls.Add(dropdownlistValue);
row.Controls.Add(cellvalue);
tableFeatures.Controls.Add(row);
}
}
else
{
tableFeatures.Rows.Clear();
tableFeatures.BorderStyle = BorderStyle.None;
TableHeaderRow row = new TableHeaderRow();
TableHeaderCell cell = new TableHeaderCell();
cell.ColumnSpan = 5;
cell.Font.Bold = true;
cell.ForeColor = System.Drawing.Color.Red;
cell.Text = "No Features Found";
row.Controls.Add(cell);
tableFeatures.Controls.Add(row);
}
}
catch
{
ClientScript.RegisterStartupScript(GetType(), "key", "<script>alert('Server Error - Check the Database Connectivity!!!')</script>");
}
}
private void creaGrilla(List <Empresa> listEmpresa)
{
tableUsuarios.Controls.Clear();
TableHeaderRow thr;
TableHeaderCell thc;
TableRow tr;
TableCell tc;
Label lbl;
LinkButton lnk;
Literal lit;
if (listEmpresa != null)
{
thr = new TableHeaderRow();
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Rut empresa";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Razón social";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Dirección";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Contacto";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Correo";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Teléfono";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Opciones";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
tableUsuarios.Rows.Add(thr);
foreach (Empresa item in listEmpresa)
{
tr = new TableRow();
tc = new TableCell();
lbl = new Label();
lbl.Text = item.rut;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tc = new TableCell();
tc.CssClass = "";
lbl = new Label();
lbl.Text = item.nombre;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tc = new TableCell();
lbl = new Label();
lbl.Text = item.direccion;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tc = new TableCell();
lbl = new Label();
lbl.Text = item.contacto;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tc = new TableCell();
lbl = new Label();
lbl.Text = item.correo;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tc = new TableCell();
lbl = new Label();
lbl.Text = item.telefono;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tc = new TableCell();
tc.CssClass = "";
lnk = new LinkButton();
lnk.ID = "lnkEdit" + item.id;
lnk.CssClass = "btn btn-primary btn-xs";
lnk.Text = "<i class='glyphicon glyphicon-pencil'></i>";
lnk.CommandArgument = "Editar";
lnk.CommandName = item.id.ToString();
lnk.Command += new CommandEventHandler(lnk_click);
tc.Controls.Add(lnk);
tr.Cells.Add(tc);
tableUsuarios.Rows.Add(tr);
}
}
else
{
thr = new TableHeaderRow();
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "No se encontraron registros";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
tableUsuarios.Rows.Add(thr);
}
}
protected void dlDetailsTable_ItemDataBound(Object sender, DataListItemEventArgs e)
{
// for limiting groups displayed
int numDisplayGroups = Math.Min(testRegex.GetGroupNumbers().Count(), MAX_GROUPS + 1);
switch (e.Item.ItemType)
{
case ListItemType.Header:
// grab controls
TableHeaderRow thrHeader = (TableHeaderRow)e.Item.FindControl("thrHeader");
if (cbReplacement.Checked)
{
// add header cell for replacement value
TableHeaderCell thcReplacement = new TableHeaderCell();
thcReplacement.Controls.Add(new LiteralControl("Replacement"));
thrHeader.Cells.Add(thcReplacement);
}
// add a header cell for each group name
for (int i = 1; i < numDisplayGroups; i++)
{
// decide how to display this group column header
string groupDisplay;
int groupNumber = testRegex.GetGroupNumbers()[i];
string groupName = testRegex.GroupNameFromNumber(groupNumber);
if (groupNumber.ToString() == groupName)
{
// name is same as number, assume group is unnamed
groupDisplay = "$" + groupName;
}
else
{
// named group
groupDisplay = "${" + groupName + "}";
}
TableHeaderCell thcGroup = new TableHeaderCell();
thcGroup.Controls.Add(new LiteralControl(groupDisplay));
if (i == 1)
{
thcGroup.CssClass = "first_group";
}
thrHeader.Cells.Add(thcGroup);
}
break;
case ListItemType.Item:
case ListItemType.AlternatingItem:
TableRow trRow = (TableRow)e.Item.FindControl("trRow");
if (e.Item.ItemIndex < matchesLimit)
{
// grab match
Match match = (Match)e.Item.DataItem;
// grab controls
Literal litMatchIndex = (Literal)e.Item.FindControl("litMatchIndex");
Literal litPosition = (Literal)e.Item.FindControl("litPosition");
Literal litValue = (Literal)e.Item.FindControl("litValue");
// alternating row style
trRow.CssClass += (((e.Item.ItemIndex & 1) == 0) ? "odd" : "even");
// set literals
litMatchIndex.Text = e.Item.ItemIndex.ToString();
litPosition.Text = match.Index.ToString();
litValue.Text = GetTextDisplay(match.Value, false);
if (cbReplacement.Checked)
{
// add cell for replacement
TableCell tcReplacement = new TableCell();
trRow.Cells.Add(tcReplacement);
// label with value
Literal litReplacementValue = new Literal();
litReplacementValue.Text = GetTextDisplay(match.Result(txtReplacement.Text), false);
tcReplacement.Controls.Add(litReplacementValue);
}
// add a cell for each group value
for (int i = 1; i < numDisplayGroups; i++)
{
Group displayGroup = match.Groups[i];
// cell
TableCell tcGroupValue = new TableCell();
if (i == 1)
{
tcGroupValue.CssClass = "first_group";
}
// label with value
Literal litGroupValue = new Literal();
litGroupValue.Text = GetTextDisplay(displayGroup.Value, false);
tcGroupValue.Controls.Add(litGroupValue);
// if capture collection is not trivial (1) then show them
if (displayGroup.Captures.Count > 1)
{
// line break
tcGroupValue.Controls.Add(new LiteralControl("<br />"));
// captures count text (changed to toggle link if javascript on)
Label lblCapturesCount = new Label();
lblCapturesCount.Text = displayGroup.Captures.Count.ToString() + " captures";
lblCapturesCount.CssClass = "captures_count";
tcGroupValue.Controls.Add(lblCapturesCount);
// captures container
Panel pnlCapturesContainer = new Panel();
pnlCapturesContainer.CssClass = "captures";
tcGroupValue.Controls.Add(pnlCapturesContainer);
// ordered list
HtmlGenericControl hgcCapturesList = new HtmlGenericControl("ol");
hgcCapturesList.Attributes.Add("start", "0");
pnlCapturesContainer.Controls.Add(hgcCapturesList);
// captures within list
Repeater rptCaptures = new Repeater();
rptCaptures.ItemDataBound += new RepeaterItemEventHandler(rptCaptures_ItemDataBound);
rptCaptures.DataSource = displayGroup.Captures;
rptCaptures.DataBind();
hgcCapturesList.Controls.Add(rptCaptures);
if (displayGroup.Captures.Count > MAX_CAPTURES)
{
Panel pnlCapturesRemaining = new Panel();
pnlCapturesRemaining.CssClass = "captures_remaining";
pnlCapturesRemaining.Controls.Add(
new LiteralControl((displayGroup.Captures.Count - MAX_CAPTURES).ToString() + " more not shown"));
pnlCapturesContainer.Controls.Add(pnlCapturesRemaining);
}
}
trRow.Cells.Add(tcGroupValue);
}
}
else
{
// this row is beyond the matches limit, do not show
trRow.Visible = false;
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetDefaultShowBy(20);
int start = (CurrentPage - 1) * ShowBy + 1;
int end = CurrentPage * ShowBy;
string sql = string.Format(@"
SELECT
(SELECT V.[VERSION] FROM [FIPVERSION] V WHERE V.ID = T.TEST_FIPVERSIONID) [VERSION]
,SUM(T.TEST_DURATION) Duration
,SUM(T.TEST_DBERRORS) DBERRORS
,SUM(T.TEST_ERRORS) ERRORS
,SUM(T.TEST_EXCEPTIONS) EXCEPTIONS
,SUM(T.TEST_WARNINGS) WARNINGS
,SUM(T.TEST_OUTPUTERRORS) OUTPUTERRORS
FROM [TESTRUNS] T
WHERE T.TEST_FIPVERSIONID IN (SELECT VV.ID FROM (SELECT V.ID, ROW_NUMBER() OVER (ORDER BY ID DESC) ROWNUM FROM [FIPVERSION] V) VV WHERE VV.ROWNUM >= {0} AND VV.ROWNUM <= {1})
GROUP BY T.TEST_FIPVERSIONID
ORDER BY T.TEST_FIPVERSIONID DESC
" , start, end);
object opages = DBHelper.GetValue(string.Format("SELECT COUNT(*) FROM FIPVERSION"));
int pages = (int)Math.Ceiling((double)Convert.ToInt32(opages) / ShowBy);
TTable.Attributes["pages"] = pages.ToString();
int index = start;
using (DataTable dt = DBHelper.GetDataTable(sql))
{
int colcount = dt.Columns.Count;
TableHeaderRow th = new TableHeaderRow();
th.TableSection = TableRowSection.TableHeader;
th.Cells[th.Cells.Add(new TableHeaderCell())].Text = "#";
for (int i = 0; i < colcount; i++)
{
th.Cells[th.Cells.Add(new TableHeaderCell())].Text = dt.Columns[i].ToString();
}
TTable.Rows.Add(th);
foreach (DataRow dr in dt.Rows)
{
TableRow tr = new TableRow();
tr.CssClass = "versionrow";
tr.Cells[tr.Cells.Add(new TableCell())].Text = (index++).ToString();
for (int i = 0; i < colcount; i++)
{
string colname = th.Cells[i + 1].Text;
if (colname == "Duration")
{
double time = Convert.ToDouble(dr[i]);
double hours = Math.Floor(time);
double minutes = (time - hours) * 60.0;
tr.Cells[tr.Cells.Add(new TableCell())].Text = string.Format("{0}:{1}", hours.ToString("00"), minutes.ToString("00"));
}
else
{
TableCell c = tr.Cells[tr.Cells.Add(new TableCell())];
c.Text = dr[i].ToString();
if (c.Text != "0")
{
if (colname == "DBERRORS")
{
c.CssClass = "bstdberror";
}
else if (colname == "ERRORS")
{
c.CssClass = "bsterror";
}
else if (colname == "EXCEPTIONS")
{
c.CssClass = "bstexception";
}
else if (colname == "WARNINGS")
{
c.CssClass = "bstwarning";
}
else if (colname == "OUTPUTERRORS")
{
c.CssClass = "bstoutputerror";
}
}
}
}
TTable.Rows.Add(tr);
}
}
}
protected void ReadRequest()
{
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT R_ID, CITIZEN_ID, R_STATUS_ID, DATE_START, DATE_END, (SELECT TITLE_NAME_TH FROM TB_TITLENAME WHERE TB_TITLENAME.TITLE_ID = TB_REQUEST.TITLE_ID) TITLE_NAME, FIRSTNAME, LASTNAME, (SELECT GENDER_NAME FROM TB_GENDER WHERE TB_GENDER.GENDER_ID = TB_REQUEST.GENDER_ID) GENDER_NAME, TO_CHAR(ADD_MONTHS(BIRTHDAY_DATE,6516),'DD MON YYYY') BIRTHDAY_DATE, EMAIL, (SELECT NATION_NAME_EN FROM TB_NATION WHERE TB_NATION.NATION_ID = TB_REQUEST.NATION_ID) NATION_NAME, (SELECT CAMPUS_NAME FROM TB_CAMPUS WHERE TB_CAMPUS.CAMPUS_ID = TB_REQUEST.CAMPUS_ID) CAMPUS_NAME, (SELECT FACULTY_NAME FROM TB_FACULTY WHERE TB_FACULTY.FACULTY_ID = TB_REQUEST.FACULTY_ID) FACULTY_NAME, (SELECT DIVISION_NAME FROM TB_DIVISION WHERE TB_DIVISION.DIVISION_ID = TB_REQUEST.DIVISION_ID) DIVISION_NAME, (SELECT WORK_NAME FROM TB_WORK_DIVISION WHERE TB_WORK_DIVISION.WORK_ID = TB_REQUEST.WORK_DIVISION_ID) WORK_DIVISION_NAME, (SELECT STAFFTYPE_NAME FROM TB_STAFFTYPE WHERE TB_STAFFTYPE.STAFFTYPE_ID = TB_REQUEST.STAFFTYPE_ID) STAFFTYPE_NAME, (SELECT TIME_CONTACT_NAME FROM TB_TIME_CONTACT WHERE TB_TIME_CONTACT.TIME_CONTACT_ID = TB_REQUEST.TIME_CONTACT_ID) TIME_CONTACT_NAME, (SELECT BUDGET_NAME FROM TB_BUDGET WHERE TB_BUDGET.BUDGET_ID = TB_REQUEST.BUDGET_ID) BUDGET_NAME, (SELECT SUBSTAFFTYPE_NAME FROM TB_SUBSTAFFTYPE WHERE TB_SUBSTAFFTYPE.SUBSTAFFTYPE_ID = TB_REQUEST.SUBSTAFFTYPE_ID) SUBSTAFFTYPE_NAME, (SELECT ADMIN_POSITION_NAME FROM TB_ADMIN_POSITION WHERE TB_ADMIN_POSITION.ADMIN_POSITION_ID = TB_REQUEST.ADMIN_POS_ID) ADMIN_POSITION_NAME, (SELECT POSITION_WORK_NAME FROM TB_POSITION_WORK WHERE TB_POSITION_WORK.POSITION_WORK_ID = TB_REQUEST.WORK_POS_ID) WORK_POS_NAME, TO_CHAR(ADD_MONTHS(INWORK_DATE,6516),'DD MON YYYY') INWORK_DATE, TO_CHAR(ADD_MONTHS(DATE_START_THIS_U,6516),'DD MON YYYY') DATE_START_THIS_U, SPECIAL_NAME, (SELECT ISCED_NAME FROM TB_ISCED WHERE TB_ISCED.ISCED_ID = TB_REQUEST.TEACH_ISCED_ID) TEACH_ISCED_NAME, (SELECT LEV_NAME_TH FROM TB_LEV WHERE TB_LEV.LEV_ID = TB_REQUEST.GRAD_LEV_ID) GRAD_LEV_NAME, GRAD_CURR, (SELECT ISCED_NAME FROM TB_ISCED WHERE TB_ISCED.ISCED_ID = TB_REQUEST.GRAD_ISCED_ID) GRAD_ISCED_NAME, (SELECT PROGRAM_NAME FROM TB_PROGRAM WHERE TB_PROGRAM.PROGRAM_ID_NEW = TB_REQUEST.GRAD_PROG_ID) GRAD_PROG_NAME, GRAD_UNIV, (SELECT NATION_NAME_EN FROM TB_NATION WHERE TB_NATION.NATION_ID = TB_REQUEST.GRAD_COUNTRY_ID) GRAD_COUNTRY_NAME, (SELECT DEFORM_NAME FROM TB_DEFORM WHERE TB_DEFORM.DEFORM_ID = TB_REQUEST.DEFORM_ID) DEFORM_NAME, (SELECT RELIGION_NAME FROM TB_RELIGION WHERE TB_RELIGION.RELIGION_ID = TB_REQUEST.RELIGION_ID) RELIGION_NAME, COMMENT_INFO, (SELECT R_STATUS_NAME FROM TB_REQUEST_STATUS WHERE TB_REQUEST_STATUS.R_STATUS_ID = TB_REQUEST.R_STATUS_ID) FROM TB_REQUEST WHERE R_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "' ORDER BY R_ID DESC", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
int i = 1;
while (reader.Read())
{
Table tb1 = new Table();
div1.Controls.Add(tb1);
{
TableHeaderRow row = new TableHeaderRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableHeaderCell cell = new TableHeaderCell();
cell.ColumnSpan = 2;
cell.Text = "วันที่อนุมัติ " + reader.GetDateTime(4).ToLongDateString() + " / ";
if (reader.GetValue(2).ToString() == "2" || reader.GetValue(2).ToString() == "3")
{
cell.Text += "<span style=\"color: rgb(34, 177, 76);\">อนุมัติ</span>";
}
else if (reader.GetValue(2).ToString() == "4" || reader.GetValue(2).ToString() == "5")
{
cell.Text += "<span style=\"color: rgb(237, 28, 36);\">ไม่อนุมัติ</span>";
}
row.Cells.Add(cell);
}
if (!reader.IsDBNull(0))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "รหัสคำร้องแก้ไขข้อมูล";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(0).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(5))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "คำนำหน้า";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(5).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(6))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ชื่อ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(6).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(7))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "นามสกุล";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(7).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(8))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "เพศ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(8).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(9))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "วันเกิด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(9).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(10))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "อีเมล";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(10).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(11))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "สัญชาติ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(11).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(12))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "วิทยาเขต";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(12).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(13))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "สำนัก/สถาบัน/คณะ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(13).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(14))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "กอง/สำนักงานเลขา/ภาควิชา";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(14).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(15))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "งาน/ฝ่าย";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(15).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(16))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ประเภทบุคลากร";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(16).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(17))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ระยะเวลาจ้าง";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(17).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(18))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ประเภทเงินจ้าง";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(18).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(19))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ประเภทบุคลากรย่อย";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(19).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(20))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ตำแหน่งทางบริหาร";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(20).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(21))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ตำแหน่งในสายงาน";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(21).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(22))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "วันที่เข้าทำงานครั้งแรก";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(22).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(23))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "วันที่เข้าทำงาน ณ สถานที่ปัจจุบัน";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(23).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(24))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "สาขางานที่เชี่ยวชาญ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(24).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(25))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "กลุ่มสาขาวิชาที่สอน(ISCED)";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(25).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(26))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ระดับการศึกษาที่จบสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(26).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(27))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "หลักสูตรที่จบการศึกษาสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(27).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(28))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "กลุ่มสาขาวิชาที่จบสูงสุด(ISCED)";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(28).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(29))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "สาขาวิชาที่จบสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(29).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(30))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ชื่อสถาบันที่จบการศึกษาสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(30).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(31))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ประเทศที่จบการศึกษาสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(31).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(32))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ความพิการ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(32).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(33))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ศาสนา";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(33).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(34))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "<strong>ความเห็น</strong>";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(34).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(35))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "<strong>ผลการอนุมัติ</strong>";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(35).ToString();
row.Cells.Add(cell);
}
}
}
}
}
}
protected void generateNotifTable(string id, bool loggedUser)
{
TableHeaderRow header = new TableHeaderRow();
header.Cells.Add(new TableHeaderCell {
CssClass = "text-center", Text = "Notifications"
});
header.Cells.Add(new TableHeaderCell {
CssClass = "text-center", Text = "Date Posted"
});
NotifTable.Rows.Add(header);
db = new SqlConnection("Data Source=(LocalDb)\\MSSQLLocalDB;Initial Catalog=aspnet-LTUBook-20190228033437;Integrated Security=True");
db.Open();
SqlCommand cmd = new SqlCommand("SELECT [UserId], [CreationUser], [FullName] as [CreatedName], [Content], [FriendReq], [DateCreated] FROM Notifications n JOIN AspNetUsers u ON n.CreationUser = u.Id WHERE UserId = '" + id + "' ORDER BY DateCreated DESC;", db);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string createdUserId = dr.GetValue(1).ToString();
string createdUser = dr.GetValue(2).ToString();
string NotifBody = dr.GetValue(3).ToString();
string isFriendReq = dr.GetValue(4).ToString();
string dateCreated = dr.GetValue(5).ToString();
TableRow row = new TableRow();
if (loggedUser)
{
if (isFriendReq.CompareTo("0") == 0)
{
row.Cells.Add(new TableCell {
Text = createdUser + " posted to your page: " + NotifBody
});
}
else
{
Button button = new Button {
Text = "Add Friend", CssClass = "btn btn-default", ID = createdUserId + "_add"
};
button.Click += AddFriend_Click;
Button button2 = new Button {
Text = "Delete Request", CssClass = "btn btn-default", ID = createdUserId + "_delete"
};
button2.Click += DeleteRequest_Click;
TableCell tc = new TableCell {
HorizontalAlign = HorizontalAlign.Right
};
tc.Controls.Add(button);
tc.Controls.Add(button2);
row.Cells.Add(new TableCell {
Text = createdUser + " added you as a friend!", VerticalAlign = VerticalAlign.Middle
});
row.Cells.Add(tc);
}
}
else
{
if (isFriendReq.CompareTo("0") == 0)
{
row.Cells.Add(new TableCell {
Text = createdUser + " posted to" + userLabel.Text.ToString() + "'s page: " + NotifBody
});
}
}
row.Cells.Add(new TableCell {
Text = dateCreated
});
NotifTable.Rows.Add(row);
}
db.Close();
}
private void BindlvTag()
{
int[] ID = new int[gvDrawOnMap.Rows.Count];
if (gvDrawOnMap.Rows.Count > 0)
{
TableHeaderRow tblHeadRow = new TableHeaderRow();
TableHeaderCell tblHeadCellID = new TableHeaderCell();
tblHeadCellID.Text = "ID";
tblHeadRow.Cells.Add(tblHeadCellID);
TableHeaderCell tblHeadCellveichleID = new TableHeaderCell();
tblHeadCellveichleID.Text = "ID vozila";
tblHeadRow.Cells.Add(tblHeadCellveichleID);
TableHeaderCell tblHeadCellAED = new TableHeaderCell();
tblHeadCellAED.Text = "AED";
tblHeadRow.Cells.Add(tblHeadCellAED);
TableHeaderCell tblHeadCellflash = new TableHeaderCell();
tblHeadCellflash.Text = "Ročna svetilka";
tblHeadRow.Cells.Add(tblHeadCellflash);
tblTag.Rows.Add(tblHeadRow);
for (int i = 0; i < gvDrawOnMap.Rows.Count; i++)
{
foreach (int x in ID)
{
if (x != Convert.ToInt32(gvDrawOnMap.Rows[i].Cells[1].Text))
{
ID[i] = x;
TableRow tr = new TableRow();
TableCell deviceID = new TableCell();
deviceID.Text = gvDrawOnMap.Rows[i].Cells[1].Text;
tr.Cells.Add(deviceID);
TableCell veichleID = new TableCell();
veichleID.Text = gvDrawOnMap.Rows[i].Cells[7].Text;
tr.Cells.Add(veichleID);
TableCell AED = new TableCell();
AED.Text = gvDrawOnMap.Rows[i].Cells[8].Text;
tr.Cells.Add(AED);
TableCell flash = new TableCell();
flash.Text = gvDrawOnMap.Rows[i].Cells[9].Text;
tr.Cells.Add(flash);
tblTag.Rows.Add(tr);
}
}
}
}
foreach (int x in ID)
{
ID[x] = 0;
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
MethodBase lmth = MethodBase.GetCurrentMethod();
string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;
SortedList sParams = new SortedList();
sParams.Add("@CampaignID", Master.CampaignID);
sParams.Add("@UserID", Master.UserID.ToString());
DataSet dsCampaigns = Classes.cUtilities.LoadDataSet("uspGetEventList", sParams, "LARPortal", Master.UserName, lsRoutineName);
DataView dvCampaigns = new DataView(dsCampaigns.Tables[0]);
DataTable dtEventList = dvCampaigns.ToTable(true, "CampaignName", "EventID", "EventName");
List <DateWithDescription> DateList = new List <DateWithDescription>();
foreach (DataRow dEventInfo in dsCampaigns.Tables[0].Rows)
{
string sCampaignName = dEventInfo["CampaignName"].ToString();
DateTime dtTemp;
int iEventID = 0;
int.TryParse(dEventInfo["EventID"].ToString(), out iEventID);
string sEventName = dEventInfo["EventName"].ToString();
string sEventDescription = dEventInfo["EventDescription"].ToString();
if (DateTime.TryParse(dEventInfo["RegistrationOpenDateTime"].ToString(), out dtTemp))
{
DateList.Add(new DateWithDescription(dtTemp, sCampaignName, iEventID, sEventName, _REGISTRATION_OPEN));
}
if (DateTime.TryParse(dEventInfo["RegistrationCloseDateTime"].ToString(), out dtTemp))
{
DateList.Add(new DateWithDescription(dtTemp, sCampaignName, iEventID, sEventName, _REGISTRATION_CLOSE));
}
if (DateTime.TryParse(dEventInfo["PaymentDueDate"].ToString(), out dtTemp))
{
DateList.Add(new DateWithDescription(dtTemp, sCampaignName, iEventID, sEventName, _PAYMENT_DUE));
}
if (DateTime.TryParse(dEventInfo["PreregistrationDeadline"].ToString(), out dtTemp))
{
DateList.Add(new DateWithDescription(dtTemp, sCampaignName, iEventID, sEventName, _PREREGISTRATION_DUE));
}
if (DateTime.TryParse(dEventInfo["PELDeadlineDate"].ToString(), out dtTemp))
{
DateList.Add(new DateWithDescription(dtTemp, sCampaignName, iEventID, sEventName, _PEL_DUE));
}
if (DateTime.TryParse(dEventInfo["InfoSkillDeadlineDate"].ToString(), out dtTemp))
{
DateList.Add(new DateWithDescription(dtTemp, sCampaignName, iEventID, sEventName, _INFO_SKILLS_DUE));
}
if (DateTime.TryParse(dEventInfo["StartDateTime"].ToString(), out dtTemp))
{
DateList.Add(new DateWithDescription(dtTemp, sCampaignName, iEventID, sEventName, _START_DATE));
}
}
// Build the list of campaigns.
// If doing 'My Campaigns' then build the list of campaigns.
if (Master.CampaignID == -101)
{
string sLabel = "";
// Using a for loop because we have to handle the first record and last record differently.
for (int i = 0; i < dsCampaigns.Tables[1].Rows.Count; i++)
{
if (i == 0)
{
sLabel = " - " + dsCampaigns.Tables[1].Rows[0]["CampaignName"].ToString();
}
else
{
if (i == dsCampaigns.Tables[1].Rows.Count - 1)
{
sLabel += " and " + dsCampaigns.Tables[1].Rows[i]["CampaignName"].ToString();
}
else
{
sLabel += ", " + dsCampaigns.Tables[1].Rows[i]["CampaignName"].ToString();
}
}
}
lblCampaignList.Text = sLabel;
}
else
{
// Not doing my campaigns so take whatever was selected in the drop down list.
lblCampaignList.Text = " - " + Master.CampaignName;
}
if (DateList.Count == 0)
{
tabCalendar.Visible = false;
lblCalendar.Text = "<h1>There are no upcoming events for this campaign.</h1>";
lblCalendar.Visible = true;
return;
}
tabCalendar.Visible = true;
lblCalendar.Visible = false;
lblCalendar.Text = "";
var FirstDateList = DateList.OrderBy(x => x.DateValue).First();
var LastDateList = DateList.OrderByDescending(x => x.DateValue).First();
DateTime StartDate = FirstDateList.DateValue;
TableRow trDate = new TableRow();
TableRow trDesc = new TableRow();
TableHeaderRow trColumnHeader = new TableHeaderRow();
TableHeaderCell tcColumnHeader = new TableHeaderCell
{
Text = "Sunday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Monday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Tuesday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Wednesday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Thursday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Friday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Saturday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tabCalendar.Rows.Add(trColumnHeader);
bool bWroteAnchor = false;
if (StartDate.DayOfWeek != DayOfWeek.Sunday)
{
DateTime dtStartOfWeek = StartDate.AddDays((int)StartDate.DayOfWeek * -1);
for (int i = 0; i < (int)StartDate.DayOfWeek; i++)
{
TableCell tcHeader = new TableCell();
if (trDate.Cells.Count == 0)
{
tcHeader.Text = dtStartOfWeek.ToString("MMM") + " " + dtStartOfWeek.Day.ToString() + ", " + dtStartOfWeek.Year.ToString();
tcHeader.Font.Bold = true;
}
else
{
tcHeader.Text = dtStartOfWeek.Day.ToString();
}
tcHeader.CssClass = "cellHeader";
trDate.Cells.Add(tcHeader);
TableCell tcDesc = new TableCell
{
Text = "",
CssClass = "cellContents"
};
trDesc.Cells.Add(tcDesc);
dtStartOfWeek = dtStartOfWeek.AddDays(1);
}
}
while (StartDate <= LastDateList.DateValue)
{
TableCell tcHeader = new TableCell();
if (StartDate.Day == 1)
{
tcHeader.Text = StartDate.ToString("MMM") + StartDate.Day.ToString() + ", " + StartDate.Year.ToString();
tcHeader.Text = StartDate.Day.ToString();
TableHeaderRow tcMonthRow = new TableHeaderRow();
TableHeaderCell tcMonthCell = new TableHeaderCell
{
ColumnSpan = 7,
Text = StartDate.ToString("MMMM") + " " + StartDate.Year.ToString(),
CssClass = "CalendarMonth"
};
tcMonthRow.Cells.Add(tcMonthCell);
tabCalendar.Rows.Add(tcMonthRow);
trColumnHeader = new TableHeaderRow();
tcColumnHeader = new TableHeaderCell
{
Text = "Sunday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Monday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Tuesday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Wednesday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Thursday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Friday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tcColumnHeader = new TableHeaderCell
{
Text = "Saturday",
CssClass = "cellColumnHeader"
};
trColumnHeader.Cells.Add(tcColumnHeader);
tabCalendar.Rows.Add(trColumnHeader);
}
else
{
tcHeader.Text = StartDate.Day.ToString();
}
tcHeader.CssClass = "cellHeader";
if ((StartDate.Date >= DateTime.Today.AddDays(-14)) &&
(!bWroteAnchor))
{
tcHeader.Text += @"<a name=""ScrollToDate""></a>";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ScrollToToday", "ScrollToDate();", true);
bWroteAnchor = true;
}
if (StartDate.Date == DateTime.Today)
{
tcHeader.BackColor = System.Drawing.Color.AntiqueWhite;
}
trDate.Cells.Add(tcHeader);
TableCell tcDesc = new TableCell();
string sCellContent = "";
foreach (DataRow dEvent in dtEventList.Rows)
{
int iEventID;
if (int.TryParse(dEvent["EventID"].ToString(), out iEventID))
{
List <DateWithDescription> CampDesc = DateList.FindAll(x => ((x.DateValue.Date == StartDate.Date) && (x.EventID == iEventID)));
if (CampDesc.Count > 0)
{
sCellContent += @"<p class='Event" + iEventID.ToString() + "'><b>" + dEvent["CampaignName"].ToString() + " - " + dEvent["EventName"].ToString() + " :</b>";
foreach (DateWithDescription d in CampDesc)
{
if (d.DateType == _START_DATE)
{
sCellContent += @" <span style=""color: white; background-color: " + _EVENT_BACKGROUND_COLOR + @"""> " + DateLabels[d.DateType] + " </span>,";
}
else
{
sCellContent += " " + DateLabels[d.DateType] + ",";
}
}
sCellContent = sCellContent.Substring(0, sCellContent.Length - 1) + "</p>";
}
}
}
tcDesc = new TableCell
{
Text = sCellContent,
CssClass = "cellContents"
};
if (StartDate.Date == DateTime.Today)
{
tcDesc.BackColor = System.Drawing.Color.AntiqueWhite;
}
trDesc.Cells.Add(tcDesc);
if (StartDate.DayOfWeek == DayOfWeek.Saturday)
{
tabCalendar.Rows.Add(trDate);
trDate = new TableRow();
tabCalendar.Rows.Add(trDesc);
trDesc = new TableRow();
}
StartDate = StartDate.AddDays(1);
if (trDesc.Cells.Count > 0)
{
tabCalendar.Rows.Add(trDate);
tabCalendar.Rows.Add(trDesc);
}
}
string sPopup = "";
foreach (DataRow dRow in dtEventList.Rows)
{
int iEventID;
if (int.TryParse(dRow["EventID"].ToString(), out iEventID))
{
List <DateWithDescription> CampDesc = DateList.FindAll(x => x.EventID == iEventID).OrderBy(x => x.DateType).ToList();
sPopup += @"$(document).ready(function () {$('.Event" + iEventID.ToString() + @"').tooltip({ title: ""<table><tr><td colspan='2'>" + dRow["EventName"].ToString() +
"</td></tr>";
foreach (DateWithDescription DateDesc in CampDesc)
{
sPopup += @"<tr><td align='left'>" + DateLabels[DateDesc.DateType] + @"</td><td align='left'> " + DateDesc.DateValue.ToShortDateString() + "</td></tr>";
}
sPopup += @"</table>"", html: true, offset: '0 0' });});" + Environment.NewLine;
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", sPopup, true);
}
/// <summary>
/// Generates tables
/// </summary>
private void GenerateTable()
{
tblData.Controls.Clear();
Hashtable ht = data.ConvertToHashtable();
TableHeaderRow th = new TableHeaderRow()
{
TableSection = TableRowSection.TableHeader
};
TableHeaderCell ha = new TableHeaderCell();
TableHeaderCell hn = new TableHeaderCell();
TableHeaderCell hv = new TableHeaderCell();
th.CssClass = "unigrid-head";
ha.Text = GetString("unigrid.actions");
ha.CssClass = "unigrid-actions-header";
hn.Text = GetString("xmleditor.propertyname");
hn.Width = Unit.Pixel(180);
hv.Text = GetString("xmleditor.propertyvalue");
hv.Width = Unit.Pixel(500);
th.Cells.Add(ha);
th.Cells.Add(hn);
th.Cells.Add(hv);
tblData.Rows.Add(th);
ArrayList keys = new ArrayList(ht);
keys.Sort(new CustomStringComparer());
foreach (DictionaryEntry okey in keys)
{
String key = ValidationHelper.GetString(okey.Key, String.Empty);
String value = ValidationHelper.GetString(okey.Value, String.Empty);
bool isInvalid = (key == INVALIDTOKEN);
key = isInvalid ? invalidKey : key;
if (value == String.Empty)
{
continue;
}
TableRow tr = new TableRow();
// Actions
TableCell tna = new TableCell();
tna.CssClass = "unigrid-actions";
var imgEdit = new CMSGridActionButton();
imgEdit.OnClientClick = String.Format("displayEdit('{1}','{0}'); return false; ", key, ClientID);
imgEdit.IconCssClass = "icon-edit";
imgEdit.IconStyle = GridIconStyle.Allow;
imgEdit.ID = key + "_edit";
imgEdit.ToolTip = GetString("xmleditor.edititem");
var imgOK = new CMSGridActionButton();
imgOK.IconCssClass = "icon-check";
imgOK.IconStyle = GridIconStyle.Allow;
imgOK.OnClientClick = String.Format("approveCustomChanges('{0}','{1}');return false;", ClientID, key);
imgOK.ID = key + "_ok";
imgOK.ToolTip = GetString("xmleditor.approvechanges");
var imgDelete = new CMSGridActionButton();
imgDelete.OnClientClick = " if (confirm('" + GetString("xmleditor.deleteconfirm") + "')) {" + ControlsHelper.GetPostBackEventReference(tblData, "delete_" + key) + "} ;return false;";
imgDelete.IconCssClass = "icon-bin";
imgDelete.IconStyle = GridIconStyle.Critical;
imgDelete.ID = key + "_del";
imgDelete.ToolTip = GetString("xmleditor.deleteitem");
var imgUndo = new CMSGridActionButton();
imgUndo.OnClientClick = String.Format("if (confirm('" + GetString("xmleditor.confirmcancel") + "')) undoCustomChanges('{0}','{1}'); return false;", ClientID, key);
imgUndo.IconCssClass = "icon-arrow-crooked-left";
imgUndo.ID = key + "_undo";
imgUndo.ToolTip = GetString("xmleditor.undochanges");
tna.Controls.Add(imgEdit);
tna.Controls.Add(imgOK);
tna.Controls.Add(imgDelete);
tna.Controls.Add(imgUndo);
value = MacroSecurityProcessor.RemoveSecurityParameters(value, false, null);
// Labels
Label lblName = new Label();
lblName.ID = "sk" + key;
lblName.Text = key;
Label lblValue = new Label();
lblValue.ID = "sv" + key;
lblValue.Text = value;
// Textboxes
CMSTextBox txtName = new CMSTextBox();
txtName.Text = key;
txtName.ID = "tk" + key;
txtName.CssClass = "XmlEditorTextbox";
CMSTextBox txtValue = new CMSTextBox();
txtValue.Text = value;
txtValue.ID = "tv" + key;
txtValue.CssClass = "XmlEditorTextbox";
txtValue.Width = Unit.Pixel(490);
labels.Add(lblName);
labels.Add(lblValue);
textboxes.Add(txtName);
textboxes.Add(txtValue);
TableCell tcn = new TableCell();
tcn.Controls.Add(lblName);
tcn.Controls.Add(txtName);
TableCell tcv = new TableCell();
tcv.Controls.Add(lblValue);
tcv.Controls.Add(txtValue);
tr.Cells.Add(tna);
tr.Cells.Add(tcn);
tr.Cells.Add(tcv);
tblData.Rows.Add(tr);
lblValue.CssClass = String.Empty;
lblName.CssClass = "CustomEditorKeyClass";
if (isInvalid)
{
imgDelete.AddCssClass("hidden");
imgEdit.AddCssClass("hidden");
lblName.AddCssClass("hidden");
lblValue.AddCssClass("hidden");
RegisterEnableScript(false);
}
else
{
imgOK.AddCssClass("hidden");
imgUndo.AddCssClass("hidden");
txtName.CssClass += " hidden";
txtValue.CssClass += " hidden";
}
}
}
protected void DisplayStudentInfo(Student student, String type)
{
// Output the student's name and type to the page
lblStudentInfoName.Text = student.Name;
lblStudentInfoType.Text = student.ToString();
// Display the success page
studentInfo.Visible = true;
// Generate the table header
var tHead = new TableHeaderRow();
tblCourses.Rows.Add(tHead);
var tHeadCellCode = new TableHeaderCell();
var tHeadCellTitle = new TableHeaderCell();
var tHeadCellHours = new TableHeaderCell();
var tHeadCellFee = new TableHeaderCell();
tHeadCellCode.Text = "Course Code";
tHeadCellTitle.Text = "Course Title";
tHeadCellHours.Text = "Weekly Hours";
tHeadCellFee.Text = "Fee Payable";
tHead.Cells.Add(tHeadCellCode);
tHead.Cells.Add(tHeadCellTitle);
tHead.Cells.Add(tHeadCellHours);
tHead.Cells.Add(tHeadCellFee);
// Table generation loop
foreach (Course course in student.getEnrolledCourses())
{
// Start creating the table rows
var tRow = new TableRow();
tblCourses.Rows.Add(tRow);
// Now the table cells
var tCellCode = new TableCell();
var tCellTitle = new TableCell();
var tCellHours = new TableCell();
var tCellFee = new TableCell();
tCellCode.Text = course.Code;
tCellTitle.Text = course.Title;
tCellHours.Text = Convert.ToString(course.WeeklyHours);
tCellFee.Text = Convert.ToString(String.Format("{0:C0}", course.Fee));
tRow.Cells.Add(tCellCode);
tRow.Cells.Add(tCellTitle);
tRow.Cells.Add(tCellHours);
tRow.Cells.Add(tCellFee);
}
// Generate the table footer
var tFoot = new TableRow();
tblCourses.Rows.Add(tFoot);
var tFootTotalLabel = new TableCell();
var tFootTotalRows = new TableCell();
var tFootTotal = new TableCell();
tFootTotalLabel.Text = "Total";
tFootTotalLabel.HorizontalAlign = HorizontalAlign.Right;
tFootTotalLabel.ColumnSpan = 2;
tFootTotalRows.Text = Convert.ToString(student.totalWeeklyHours());
tFootTotal.Text = Convert.ToString(String.Format("{0:C0}", student.feePayable()));
tFoot.Cells.Add(tFootTotalLabel);
tFoot.Cells.Add(tFootTotalRows);
tFoot.Cells.Add(tFootTotal);
}
/* This method gets called when the user clicks the proceed button */
protected void proceedButton_Click(object sender, EventArgs e)
{
parseResultPlaceHolder.Controls.Clear();
errorMessageLabel.Text = "";
/* Create the WSDL utils proxy */
wsdlUtilsService.WSDLServiceClient
wsdlUtils = new wsdlUtilsService.WSDLServiceClient();
/* Extract the URL from the URL box */
string url = urlTextBox.Text;
wsdlUtilsService.MethodDetails[] methodsList;
try
{
/* Call the service to extract methods and parameters */
methodsList = wsdlUtils.ExtractWsdlOperation(url);
}
catch(Exception)
{
errorMessageLabel.Text = "Couldn't extract details. Check the link provided";
return;
}
Table parseResultsTable = new Table();
parseResultPlaceHolder.Controls.Add(parseResultsTable);
TableHeaderRow th = new TableHeaderRow();
Label methodNameHeaderLabel = new Label();
methodNameHeaderLabel.Text = "Method Name";
TableHeaderCell methodNameHeaderCell = new TableHeaderCell();
methodNameHeaderCell.Controls.Add(methodNameHeaderLabel);
th.Cells.Add(methodNameHeaderCell);
Label inputParamsHeaderLabel = new Label();
inputParamsHeaderLabel.Text = "Input Params";
TableHeaderCell inputParamsHeaderCell = new TableHeaderCell();
inputParamsHeaderCell.Controls.Add(inputParamsHeaderLabel);
th.Cells.Add(inputParamsHeaderCell);
Label outputParamsHeaderLabel = new Label();
outputParamsHeaderLabel.Text = "Output Params";
TableHeaderCell outputParamsHeaderCell = new TableHeaderCell();
outputParamsHeaderCell.Controls.Add(outputParamsHeaderLabel);
th.Cells.Add(outputParamsHeaderCell);
parseResultsTable.Rows.Add(th);
/* Parse through the result obtained by calling the service and create a list to be displayed */
foreach (wsdlUtilsService.MethodDetails method in methodsList)
{
string ipParamString;
string opParamString;
string methodName = method.methodName + "<br/>";
wsdlUtilsService.ParameterDetails[] ipParams = method.inputParameters;
wsdlUtilsService.ParameterDetails[] opParams = method.outputParameters;
if(ipParams.Length == 0)
{
ipParamString = "No input Params<br/>";
}
else
{
ipParamString = "Names: ";
foreach (wsdlUtilsService.ParameterDetails parameter in ipParams)
{
ipParamString += parameter.parameterName + ",";
}
ipParamString += "<br/>Types: ";
foreach (wsdlUtilsService.ParameterDetails parameter in ipParams)
{
ipParamString += parameter.parameterType + ",";
}
ipParamString += "<br/>";
}
if (opParams.Length == 0)
{
opParamString = "No output Params<br/>";
}
else
{
opParamString = "Names: ";
foreach (wsdlUtilsService.ParameterDetails parameter in opParams)
{
ipParamString += parameter.parameterName + ",";
}
opParamString += "<br/>Types: ";
foreach (wsdlUtilsService.ParameterDetails parameter in opParams)
{
opParamString += parameter.parameterType + ",";
}
opParamString += "<br/>";
}
TableRow tr = new TableRow();
Label methodNameLabel = new Label();
methodNameLabel.Text = methodName;
TableCell methodNameCell = new TableCell();
methodNameCell.Controls.Add(methodNameLabel);
tr.Cells.Add(methodNameCell);
Label inputParamsLabel = new Label();
inputParamsLabel.Text = ipParamString;
TableCell inputParamsCell = new TableCell();
inputParamsCell.Controls.Add(inputParamsLabel);
tr.Cells.Add(inputParamsCell);
Label outputParamsLabel = new Label();
outputParamsLabel.Text = opParamString;
TableCell outputParamsCell = new TableCell();
outputParamsCell.Controls.Add(outputParamsLabel);
tr.Cells.Add(outputParamsCell);
parseResultsTable.Rows.Add(tr);
}
wsdlUtils.Close();
}
/// <summary>
/// Page pre-render
/// </summary>
protected void Page_PreRender(object sender, EventArgs e)
{
if ((Version != null) && (VersionCompare != null))
{
// Prepare header with rollback controls
TableRow tr = new TableHeaderRow() { TableSection = TableRowSection.TableHeader };
tr.CssClass = "unigrid-head";
TableHeaderCell th = new TableHeaderCell();
th.Text = GetString("lock.versionnumber");
tr.Cells.Add(th);
// Switch header sides if necessary
if (VersionCompare.VersionID < Version.VersionID)
{
tr.Cells.Add(GetRollbackTableHeaderCell("compare", VersionCompare));
tr.Cells.Add(GetRollbackTableHeaderCell("source", Version));
}
else
{
tr.Cells.Add(GetRollbackTableHeaderCell("source", Version));
tr.Cells.Add(GetRollbackTableHeaderCell("compare", VersionCompare));
}
if ((viewDataSet.DataSet.Tables.Count <= 1) && (viewDataSet.CompareDataSet.Tables.Count <= 1))
{
viewDataSet.Table.Rows.RemoveAt(0);
}
viewDataSet.Table.Rows.AddAt(0, tr);
}
}
/// <summary>
/// Displays helper table with transformation examples.
/// </summary>
private void DisplayHelperTable()
{
// Add header row
TableHeaderRow headerRow = new TableHeaderRow
{
TableSection = TableRowSection.TableHeader,
CssClass = "unigrid-head"
};
headerRow.Cells.Add(new TableHeaderCell
{
Text = GetString("queryedit.helpcaption")
});
headerRow.Cells.Add(new TableHeaderCell
{
Text = GetString("queryedit.helpdescription"),
CssClass = "main-column-100"
});
tblHelp.Rows.Add(headerRow);
// Add macro rows
string[,] rows =
{
{ "##WHERE##", GetString("queryedit.help_where") },
{ "##TOPN##", GetString("queryedit.help_topn") },
{ "##ORDERBY##", GetString("queryedit.help_orderby") },
{ "##COLUMNS##", GetString("queryedit.help_columns") }
};
for (int i = 0; i <= rows.GetUpperBound(0); i++)
{
TableRow macroRow = new TableRow();
macroRow.Cells.Add(new TableCell
{
Text = rows[i, 0]
});
macroRow.Cells.Add(new TableCell
{
Text = rows[i, 1]
});
tblHelp.Rows.Add(macroRow);
}
// Make help table visible on click only
tblHelp.Attributes["style"] = "display: none;";
}
private void parseResponse(string soapResult, string action)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(soapResult);
XmlNamespaceManager manager = new XmlNamespaceManager(doc.NameTable);
manager.AddNamespace("ns", "http://www.nbrm.mk/klservice/");
XmlNode node = doc.DocumentElement.SelectSingleNode("//ns:GetExchangeRatesResult", manager);
string text = node.FirstChild.InnerText;
if (text.Contains("Formatot na parametarot"))
{
MyPanel.Visible = true;
MyTable.Visible = false;
return;
}
MyPanel.Visible = false;
MyTable.Visible = true;
string[] parts = text.Split(new string[] { "<KursZbir>", "</KursZbir>" }, StringSplitOptions.None);
MyTable.Rows.Clear();
TableHeaderRow row = new TableHeaderRow();
TableHeaderCell cell = new TableHeaderCell();
cell.Text = "Date";
cell.Style.Add("text-align", "center");
TableHeaderCell cell1 = new TableHeaderCell();
cell1.Text = "Currency";
cell1.Style.Add("text-align", "center");
TableHeaderCell cell2 = new TableHeaderCell();
cell2.Text = "Unit";
cell2.Style.Add("text-align", "center");
TableHeaderCell cell3 = new TableHeaderCell();
cell3.Text = "Buying rate";
cell3.Style.Add("text-align", "center");
TableHeaderCell cell4 = new TableHeaderCell();
cell4.Text = "Average rate";
cell4.Style.Add("text-align", "center");
TableHeaderCell cell5 = new TableHeaderCell();
cell5.Text = "Selling rate";
cell5.Style.Add("text-align", "center");
row.Cells.Add(cell);
row.Cells.Add(cell1);
row.Cells.Add(cell2);
row.Cells.Add(cell3);
row.Cells.Add(cell4);
row.Cells.Add(cell5);
MyTable.Rows.Add(row);
foreach (string part in parts)
{
if (part.Trim().Equals("") || part.StartsWith("<dsKurs>") || part.StartsWith("</dsKurs>"))
{
continue;
}
string[] otherParts = part.Split(new string[] { "<Datum>", "</Datum>" }, StringSplitOptions.None);
if (otherParts.Length > 0)
{
try
{
TableRow tempRow = new TableRow();
string datum = otherParts[1];
DateTime date = Convert.ToDateTime(datum);
TableCell tempCell1 = new TableCell();
if (date.Month <= 9)
{
tempCell1.Text = date.Day + ".0" + date.Month + "." + date.Year;
}
else
{
tempCell1.Text = date.Day + "." + date.Month + "." + date.Year;
}
tempCell1.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell1);
string[] partsS = otherParts[2].Split(new string[] { "<Oznaka>", "</Oznaka>" }, StringSplitOptions.None);
string oznaka = partsS[1];
TableCell tempCell = new TableCell();
tempCell.Text = oznaka;
tempCell.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell);
string[] parts2 = partsS[2].Split(new string[] { "<Nomin>", "</Nomin>" }, StringSplitOptions.None);
string nomin = parts2[1];
TableCell tempCell2 = new TableCell();
tempCell2.Text = nomin;
tempCell2.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell2);
string[] parts3 = parts2[2].Split(new string[] { "<Kupoven>", "</Kupoven>" }, StringSplitOptions.None);
string kupoven = parts3[1];
TableCell tempCell3 = new TableCell();
tempCell3.Text = kupoven;
tempCell3.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell3);
string[] parts4 = parts3[2].Split(new string[] { "<Sreden>", "</Sreden>" }, StringSplitOptions.None);
string sreden = parts4[1];
TableCell tempCell4 = new TableCell();
tempCell4.Text = sreden;
tempCell4.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell4);
string[] parts5 = parts4[2].Split(new string[] { "<Prodazen>", "</Prodazen>" }, StringSplitOptions.None);
string prodazen = parts5[1];
TableCell tempCell5 = new TableCell();
tempCell5.Text = prodazen;
tempCell5.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell5);
MyTable.Rows.Add(tempRow);
}
catch (Exception ex)
{
}
}
}
}
/// <summary>
/// Function that is always called to recreate the table
/// </summary>
private void GetArticleHistory()
{
tblResults.Rows.Clear();
lblEntryError.Text = String.Empty;
Count.Text = String.Empty;
int count = 0;
if (txtEntry.Text != String.Empty)
{
int h2g2ID = 0;
if (!Int32.TryParse(txtEntry.Text, out h2g2ID))
{
lblEntryError.Text = "Please enter a valid H2G2 ID";
return;
}
int entryID = h2g2ID / 10;
ArticleHistory articleHistory = new ArticleHistory(_basePage);
articleHistory.GetArticleHistoryXml(entryID);
TableHeaderRow headerRow = new TableHeaderRow();
headerRow.BackColor = Color.MistyRose;
int accountCount = 0;
foreach (XmlNode node in articleHistory.RootElement.SelectNodes(@"ARTICLEHISTORY/ITEMS/ITEM"))
{
TableRow row = new TableRow();
foreach (XmlNode data in node.ChildNodes)
{
TableCell dataCell = new TableCell();
if (data.LocalName == "USERID")
{
if (count == 0)
{
AddHeaderCell(headerRow, "User ID");
}
dataCell.HorizontalAlign = HorizontalAlign.Center;
string userIDText = data.InnerText;
dataCell.Text = userIDText;
accountCount++;
if (accountCount % 2 == 0)
row.BackColor = Color.LightGray;
else
row.BackColor = Color.Linen;
HyperLink link = new HyperLink();
link.NavigateUrl = "/dna/moderation/MemberDetails?userid=" + userIDText;
link.Text = "U" + userIDText;
dataCell.Controls.Add(link);
row.Cells.Add(dataCell);
}
else if (data.LocalName == "ACTION")
{
if (count == 0)
{
AddHeaderCell(headerRow, "Action");
}
dataCell.HorizontalAlign = HorizontalAlign.Center;
dataCell.Text = GetActionText(data.InnerText);
row.Cells.Add(dataCell);
}
else if (data.LocalName == "DATEPERFORMED")
{
if (count == 0)
{
AddHeaderCell(headerRow, "Date Performed");
}
dataCell.HorizontalAlign = HorizontalAlign.Center;
DateTime date = new DateTime();
string sortDate = String.Empty;
if (data.SelectSingleNode("DATE/@SORT") != null)
{
DateTimeFormatInfo UKDTFI = new CultureInfo("en-GB", false).DateTimeFormat;
sortDate = data.SelectSingleNode("DATE/@SORT").InnerText;
DateTime.TryParseExact(sortDate, "yyyyMMddHHmmss", UKDTFI, DateTimeStyles.NoCurrentDateDefault, out date);
dataCell.Text = date.ToString();
}
else
{
dataCell.Text = "";
}
row.Cells.Add(dataCell);
}
else if (data.LocalName == "COMMENT")
{
if (count == 0)
{
AddHeaderCell(headerRow, "Comments");
}
dataCell.HorizontalAlign = HorizontalAlign.Center;
dataCell.Text = data.InnerText;
row.Cells.Add(dataCell);
}
}
tblResults.Rows.Add(row);
count++;
}
if (count == 0)
{
TableRow nodatarow = new TableRow();
TableCell nodataCell = new TableCell();
nodataCell.ColumnSpan = 4;
nodataCell.Text = @"No data for those details";
nodatarow.Cells.Add(nodataCell);
tblResults.Rows.Add(nodatarow);
Count.Text = String.Empty;
}
else
{
Count.Text = String.Format(@"There are {0} entries.", count.ToString());
}
tblResults.Rows.AddAt(0, headerRow);
tblResults.CellSpacing = 5;
tblResults.BorderWidth = 2;
tblResults.BorderStyle = BorderStyle.Outset;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Redirect("Login.aspx");
}
else if (Session["type"].Equals("0"))
{
Response.Redirect("InstructorHomePage.aspx");
}
else if (Session["type"].Equals("2"))
{
Response.Redirect("StudentHomePage.aspx");
}
else
{
string connectionStr = WebConfigurationManager.ConnectionStrings["GUCera"].ToString();
SqlConnection connection = new SqlConnection(connectionStr);
SqlCommand adminViewAllCourses = new SqlCommand("AdminViewAllCourses", connection);
adminViewAllCourses.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = adminViewAllCourses.ExecuteReader();
TableHeaderRow headerRow = new TableHeaderRow();
TableHeaderCell col1 = new TableHeaderCell();
col1.Text = "Name";
col1.Scope = TableHeaderScope.Column;
TableHeaderCell col2 = new TableHeaderCell();
col2.Text = "Credit Hours";
col2.Scope = TableHeaderScope.Column;
TableHeaderCell col3 = new TableHeaderCell();
col3.Text = "Price";
col3.Scope = TableHeaderScope.Column;
TableHeaderCell col4 = new TableHeaderCell();
col4.Text = "Content";
col4.Scope = TableHeaderScope.Column;
TableHeaderCell col5 = new TableHeaderCell();
col5.Text = "Accepted";
col5.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(col1);
headerRow.Cells.Add(col2);
headerRow.Cells.Add(col3);
headerRow.Cells.Add(col4);
headerRow.Cells.Add(col5);
courses.Rows.Add(headerRow);
while (reader.Read())
{
TableRow row = new TableRow();
TableCell name = new TableCell();
TableCell creditHours = new TableCell();
TableCell price = new TableCell();
TableCell content = new TableCell();
TableCell accepted = new TableCell();
name.Text = reader["name"].ToString();
creditHours.Text = reader["creditHours"].ToString();
price.Text = reader["price"].ToString();
content.Text = reader["content"].ToString();
accepted.Text = reader["accepted"].ToString();
row.Cells.Add(name);
row.Cells.Add(creditHours);
row.Cells.Add(price);
row.Cells.Add(content);
row.Cells.Add(accepted);
courses.Rows.Add(row);
}
connection.Close();
}
}
private void DisplayUserStatistics(UserStatistics userStatistics)
{
int count = 0;
TableHeaderRow headerRow = new TableHeaderRow();
headerRow.BackColor = Color.MistyRose;
int previousForumID = 0;
int forumCount = 0;
foreach (XmlNode post in userStatistics.RootElement.SelectNodes(@"USERSTATISTICS/FORUM/THREAD/POST"))
{
XmlNode thread = post.ParentNode;
XmlNode forum = thread.ParentNode;
if (count == 0)
{
TableHeaderCell headerSiteCell = new TableHeaderCell();
headerSiteCell.Text = "Site";
headerSiteCell.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(headerSiteCell);
TableHeaderCell headerForumTitleCell = new TableHeaderCell();
headerForumTitleCell.Text = "ForumTitle";
headerForumTitleCell.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(headerForumTitleCell);
TableHeaderCell headerFirstSubjectCell = new TableHeaderCell();
headerFirstSubjectCell.Text = "Conversation First Subject";
headerFirstSubjectCell.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(headerFirstSubjectCell);
TableHeaderCell headerPostSubjectCell = new TableHeaderCell();
headerPostSubjectCell.Text = "Post Subject";
headerPostSubjectCell.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(headerPostSubjectCell);
TableHeaderCell headerPostTextCell = new TableHeaderCell();
headerPostTextCell.Text = "Post Text";
headerPostTextCell.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(headerPostTextCell);
TableHeaderCell headerDatePostedCell = new TableHeaderCell();
headerDatePostedCell.Text = "Date Posted";
headerDatePostedCell.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(headerDatePostedCell);
TableHeaderCell headerComplainCell = new TableHeaderCell();
headerComplainCell.Text = "Complain";
headerComplainCell.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(headerComplainCell);
}
TableRow row = new TableRow();
string forumID = forum.SelectSingleNode(@"@FORUMID").InnerText;
int currentForumID = Convert.ToInt32(forumID);
if (currentForumID != previousForumID)
{
forumCount++;
previousForumID = currentForumID;
}
if (forumCount % 2 == 0)
row.BackColor = Color.LightGray;
else
row.BackColor = Color.Linen;
string siteID = forum.SelectSingleNode(@"SITEID").InnerText;
string siteName = forum.SelectSingleNode(@"SITENAME").InnerText;
string commentURL = String.Empty;
bool isComment = false;
if (forum.SelectSingleNode(@"URL") != null && forum.SelectSingleNode(@"URL").InnerText != String.Empty)
{
commentURL = forum.SelectSingleNode(@"URL").InnerText;
isComment = true;
}
TableCell siteCell = new TableCell();
siteCell.HorizontalAlign = HorizontalAlign.Center;
siteCell.Text = siteName;
row.Cells.Add(siteCell);
TableCell forumTitleCell = new TableCell();
forumTitleCell.HorizontalAlign = HorizontalAlign.Center;
string subject = forum.SelectSingleNode(@"SUBJECT").InnerText;
forumTitleCell.Text = subject;
HyperLink forumTitleLink = new HyperLink();
if (!isComment)
{
forumTitleLink.NavigateUrl = GetBaseUrl() + siteName + @"/F" + forumID;
}
else
{
forumTitleLink.NavigateUrl = commentURL;
}
forumTitleLink.Text = subject;
forumTitleCell.Controls.Add(forumTitleLink);
row.Cells.Add(forumTitleCell);
TableCell firstSubjectCell = new TableCell();
firstSubjectCell.HorizontalAlign = HorizontalAlign.Center;
string firstSubject = thread.SelectSingleNode(@"SUBJECT").InnerText;
firstSubjectCell.Text = firstSubject;
string threadID = thread.SelectSingleNode(@"@THREADID").InnerText;
HyperLink firstSubjectLink = new HyperLink();
if (!isComment)
{
firstSubjectLink.NavigateUrl = GetBaseUrl() + siteName + @"/F" + forumID + "?thread=" + threadID;
}
else
{
firstSubjectLink.NavigateUrl = commentURL;
}
firstSubjectLink.Text = firstSubject;
firstSubjectCell.Controls.Add(firstSubjectLink);
row.Cells.Add(firstSubjectCell);
TableCell postSubjectCell = new TableCell();
postSubjectCell.HorizontalAlign = HorizontalAlign.Center;
string postSubject = post.SelectSingleNode(@"SUBJECT").InnerText;
postSubjectCell.Text = postSubject;
string postID = post.SelectSingleNode(@"@POSTID").InnerText;
HyperLink postLink = new HyperLink();
if (!isComment)
{
postLink.NavigateUrl = GetBaseUrl() + siteName + @"/F" + forumID + "?thread=" + threadID + @"&post=" + postID + "#p" + postID;
}
else
{
string postIndex = post.SelectSingleNode(@"POSTINDEX").InnerText;
postLink.NavigateUrl = commentURL + "#" + postIndex;
}
postLink.Text = postSubject;
postSubjectCell.Controls.Add(postLink);
row.Cells.Add(postSubjectCell);
TableCell postTextCell = new TableCell();
postTextCell.HorizontalAlign = HorizontalAlign.Center;
string text = post.SelectSingleNode(@"BODY").InnerText;
postTextCell.Text = text;
row.Cells.Add(postTextCell);
TableCell datePostedCell = new TableCell();
datePostedCell.HorizontalAlign = HorizontalAlign.Center;
string dateposted = post.SelectSingleNode(@"DATEPOSTED/DATE/@RELATIVE").InnerText;
datePostedCell.Text = dateposted;
row.Cells.Add(datePostedCell);
TableCell complaintCell = new TableCell();
complaintCell.HorizontalAlign = HorizontalAlign.Center;
string path = @"/dnaimages/boards/images/complain.gif";
HyperLink complaintLink = new HyperLink();
complaintLink.NavigateUrl = GetBaseUrl() + siteName + @"/comments/UserComplaintPage?s_start=1&PostID=" + postID;
complaintLink.ImageUrl = path;
complaintLink.Target = "_blank";
complaintCell.Controls.Add(complaintLink);
row.Cells.Add(complaintCell);
tblResults.Rows.Add(row);
count++;
}
XmlNode totalPosts = userStatistics.RootElement.SelectSingleNode(@"USERSTATISTICS/@TOTAL");
_total = 0;
if (totalPosts != null)
{
Int32.TryParse(totalPosts.InnerText, out _total);
}
if (count == 0)
{
TableRow nodatarow = new TableRow();
TableCell nodataCell = new TableCell();
nodataCell.ColumnSpan = 4;
nodataCell.Text = @"No data for those details";
nodatarow.Cells.Add(nodataCell);
tblResults.Rows.Add(nodatarow);
Count.Text = "";
}
else
{
Count.Text = String.Format(@"{0} entries out of {1} in total.", count.ToString(), _total.ToString());
}
tblResults.Rows.AddAt(0, headerRow);
tblResults.CellSpacing = 5;
tblResults.BorderWidth = 2;
tblResults.BorderStyle = BorderStyle.Outset;
ShowHideResultControls(true);
UpdatePagingControls();
StoreValues();
}
private void ListarUsuarios()
{
Table tabla = new Table();
tabla.Attributes.Add("class", "tabla_lista_usuarios");
TableHeaderCell h_celda_nombre_usuario = new TableHeaderCell();
h_celda_nombre_usuario.Text = "Usuario";
TableHeaderCell h_celda_password_usuario = new TableHeaderCell();
h_celda_password_usuario.Text = "Password";
TableCell h_celda_nombre = new TableCell();
h_celda_nombre.Text = "Nombre";
TableCell h_celda_apellido_paterno = new TableCell();
h_celda_apellido_paterno.Text = "Apellido Paterno";
TableCell h_celda_apellido_materno = new TableCell();
h_celda_apellido_materno.Text = "Apellido Materno";
TableHeaderCell h_celda_email = new TableHeaderCell();
h_celda_email.Text = "Email";
TableCell h_celda_enviar_email = new TableCell();
h_celda_enviar_email.Attributes.Add("data-sorter", "false");
h_celda_enviar_email.Text = "Enviar Email";
TableHeaderCell h_celda_rol = new TableHeaderCell();
h_celda_rol.Text = "Rol";
TableHeaderCell h_celda_boton_borrar = new TableHeaderCell();
//h_celda_boton_borrar.Attributes.Add("data-sorter", "false");
h_celda_boton_borrar.Text = "<span title='Editar'>E</span>";
TableHeaderCell h_celda_boton_editar = new TableHeaderCell();
//h_celda_boton_editar.Attributes.Add("data-sorter", "false");
h_celda_boton_editar.Text = "<span title='Borrar'>B</span>";
TableHeaderRow hrow = new TableHeaderRow();
hrow.TableSection = TableRowSection.TableHeader;
hrow.Cells.Add(h_celda_nombre_usuario);
hrow.Cells.Add(h_celda_password_usuario);
hrow.Cells.Add(h_celda_nombre);
hrow.Cells.Add(h_celda_apellido_paterno);
hrow.Cells.Add(h_celda_apellido_materno);
hrow.Cells.Add(h_celda_email);
hrow.Cells.Add(h_celda_enviar_email);
hrow.Cells.Add(h_celda_rol);
hrow.Cells.Add(h_celda_boton_editar);
hrow.Cells.Add(h_celda_boton_borrar);
tabla.Rows.Add(hrow);
MembershipUserCollection users = Membership.GetAllUsers();
IEnumerator lista_usuarios = users.GetEnumerator();
while (lista_usuarios.MoveNext())
{
try
{
//optenemos el usuario actual
string user = lista_usuarios.Current.ToString();
MembershipUser ms_user = Membership.GetUser(user);
string password = ms_user.GetPassword();
string email = ms_user.Email;
string rol = "";
//obtenemos el rol (o roles) del usuario. enb este caso solo debe de ser uno
string[] rolesuser = Roles.GetRolesForUser(user);
if (rolesuser.Length > 0)
{
rol = rolesuser[0];
}
string nombre = "";
string apellido_paterno = "";
string apellido_materno = "";
string enviar_email = "";
control_db.obtenerDatosUsuario(user, ref nombre, ref apellido_paterno, ref apellido_materno, ref enviar_email);
TableCell celda_nombre_usuario = new TableCell();
celda_nombre_usuario.Text = user;
TableCell celda_password_usuario = new TableCell();
celda_password_usuario.Text = password;
TableCell celda_nombre = new TableCell();
celda_nombre.Text = nombre;
TableCell celda_apellido_paterno = new TableCell();
celda_apellido_paterno.Text = apellido_paterno;
TableCell celda_apellido_materno = new TableCell();
celda_apellido_materno.Text = apellido_materno;
TableCell celda_email = new TableCell();
celda_email.Text = email;
TableCell celda_enviar_email = new TableCell();
celda_enviar_email.Text = (enviar_email.Equals("True")) ? "SI" : "";
TableCell celda_rol = new TableCell();
celda_rol.Text = rol;
TableCell celda_boton_borrar = new TableCell();
celda_boton_borrar.Text = "<img src='../Images/IconPack1/16x16/remove.png' style='cursor:pointer;' onclick='mostrarDialogoBorrarUsuario(\"" + user + "\")' />";
TableCell celda_boton_editar = new TableCell();
celda_boton_editar.Text = "<img src='../Images/IconPack1/16x16/notes_edit.png' style='cursor:pointer;' onclick='mostrarDialogoEditarUsuario(\"" + user + "\",\"" + password + "\",\"" + rol + "\",\"" + nombre + "\",\"" + apellido_paterno + "\",\"" + apellido_materno + "\",\"" + email + "\",\"" + enviar_email + "\")' />";
TableRow renglon = new TableRow();
renglon.TableSection = TableRowSection.TableBody;
renglon.Cells.Add(celda_nombre_usuario);
renglon.Cells.Add(celda_password_usuario);
renglon.Cells.Add(celda_nombre);
renglon.Cells.Add(celda_apellido_paterno);
renglon.Cells.Add(celda_apellido_materno);
renglon.Cells.Add(celda_email);
renglon.Cells.Add(celda_enviar_email);
renglon.Cells.Add(celda_rol);
renglon.Cells.Add(celda_boton_editar);
renglon.Cells.Add(celda_boton_borrar);
tabla.Rows.Add(renglon);
}
catch (Exception e)
{
Debug.WriteLine("ERROR: " + e.ToString());
}
}
Panel_Usuarios.Controls.Add(tabla);
}
/// <summary>
/// Generic Function to add a header cell to the table
/// </summary>
/// <param name="headerRow">The row that holds the header info</param>
/// <param name="headerText">Text to display</param>
private static void AddHeaderCell(TableHeaderRow headerRow, string headerText)
{
TableHeaderCell headerNextCell = new TableHeaderCell();
headerNextCell.Text = headerText;
headerNextCell.Scope = TableHeaderScope.Column;
headerRow.Cells.Add(headerNextCell);
}
private void loadtable(List <GENERATEREVIEW> filterlist)
{
if (filterlist.Count == 0)
{
Table1.Visible = false;
noreviewslabel.Visible = true;
}
else
{
noreviewslabel.Visible = false;
Table1.Visible = true;
}
for (int i = 1; i < Table1.Rows.Count; i++)
{
Table1.Rows.RemoveAt(i);
}
foreach (GENERATEREVIEW g in filterlist)
{
EMPLOYEE e = elist.Find(emp => emp.EmployeeId == g.EmployeeId);
PERSONALDETAILS pd = pdlist.Find(p => p.PersonalDetailId == e.PersonalDetailId);
TableRow row = new TableRow();
row.ID = g.GenerateReviewId.ToString();
TableCell employee = new TableCell();
employee.HorizontalAlign = HorizontalAlign.Center;
Label employeelabel = new Label();
employeelabel.Text = pd.FirstName + " " + pd.LastName;
employee.Controls.Add(employeelabel);
row.Cells.Add(employee);
TableCell duration = new TableCell();
duration.HorizontalAlign = HorizontalAlign.Center;
Label dlabel = new Label();
dlabel.Text = g.StartDate.ToShortDateString() + " to " + g.EndDate.ToShortDateString();
duration.Controls.Add(dlabel);
row.Cells.Add(duration);
TableCell dd = new TableCell();
Label ddlabel = new Label();
dd.HorizontalAlign = HorizontalAlign.Center;
ddlabel.Text = g.DueDate.ToShortDateString();
dd.Controls.Add(ddlabel);
row.Cells.Add(dd);
TableCell status = new TableCell();
status.HorizontalAlign = HorizontalAlign.Center;
Label statuslabel = new Label();
statuslabel.Text = g.Status;
status.Controls.Add(statuslabel);
row.Cells.Add(status);
TableCell review = new TableCell();
review.HorizontalAlign = HorizontalAlign.Center;
Table reviewtable = new Table();
reviewtable.GridLines = GridLines.Both;
TableHeaderRow hr = new TableHeaderRow();
TableHeaderCell h1 = new TableHeaderCell();
Label h1label = new Label();
h1label.Text = "Parameter";
h1.Controls.Add(h1label);
hr.Cells.Add(h1);
TableHeaderCell h2 = new TableHeaderCell();
Label h2label = new Label();
h2label.Text = "Rating";
h2.Controls.Add(h2label);
hr.Cells.Add(h2);
TableHeaderCell h3 = new TableHeaderCell();
Label h3label = new Label();
h3label.Text = "Comment";
h3.Controls.Add(h3label);
hr.Cells.Add(h3);
reviewtable.Rows.Add(hr);
List <REVIEW> rlist = getreviews(g.GenerateReviewId);
foreach (REVIEW r in rlist)
{
TableRow tr = new TableRow();
TableCell parameter = new TableCell();
parameter.HorizontalAlign = HorizontalAlign.Center;
parameter.Width = 200;
PERFORMANCEPARAMETER p = getparameter(r.PerameterId);
String pname = p.ParameterName;
Label parametername = new Label();
parametername.Text = pname;
parameter.Controls.Add(parametername);
tr.Cells.Add(parameter);
TableCell rating = new TableCell();
rating.HorizontalAlign = HorizontalAlign.Center;
rating.Width = 200;
double rate = ((double)r.Rating / ((double)p.MaxRating - (double)p.MinRating + 1)) * 100.0;
Label ratinglabel = new Label();
ratinglabel.Text = rate + "% ";
rating.Controls.Add(ratinglabel);
tr.Cells.Add(rating);
TableCell comment = new TableCell();
comment.HorizontalAlign = HorizontalAlign.Center;
comment.Width = 200;
Label commentlabel = new Label();
commentlabel.Text = r.Comment;
comment.Controls.Add(commentlabel);
tr.Cells.Add(comment);
reviewtable.Rows.Add(tr);
}
review.Controls.Add(reviewtable);
row.Cells.Add(review);
TableCell c1 = new TableCell();
c1.HorizontalAlign = HorizontalAlign.Center;
if (g.DueDate >= DateTime.Today)
{
Button edit = new Button();
edit.Text = "Edit";
edit.Command += new CommandEventHandler(editbutton_Click);
edit.CommandArgument = g.GenerateReviewId.ToString();
c1.Controls.Add(edit);
}
row.Cells.Add(c1);
Table1.Rows.Add(row);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string s1 = Request.QueryString[0];
string conStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlConnection dbConnection = new SqlConnection(conStr);
SqlCommand sqlcommand;
SqlDataReader reader;
try
{
dbConnection.Open();
string query = "SELECT STARTDATE, ENDDATE FROM TIMESHEET WHERE TIMESHEET_ID = '" + s1 + "'";
sqlcommand = new SqlCommand(query, dbConnection);
reader = sqlcommand.ExecuteReader();
if (reader.Read())
{
strt_date.Text = Convert.ToDateTime(reader["startdate"]).Date.ToString("d");
end_date.Text = Convert.ToDateTime(reader["enddate"]).Date.ToString("d");
TableHeaderRow t_row = new TableHeaderRow();
TableRow th_row = new TableRow();
table2.Rows.Add(t_row);
table2.Rows.Add(th_row);
reader.Close();
query = string.Empty;
//fetching the timesheet data
query = "SELECT DATE_HOURS,NO_HOURS FROM TIMESHEET_DETAILS WHERE TIMESHEET_ID = '" + s1 + "'";
sqlcommand = new SqlCommand(query, dbConnection);
reader = sqlcommand.ExecuteReader();
while (reader.Read())
{
TableCell thcell = new TableCell();
TableCell tcell = new TableCell();
Label hours_lb = new Label();
Label date_lb = new Label();
string curr_date = Convert.ToDateTime(reader["DATE_HOURS"]).Date.ToString("d");
date_lb.Text = curr_date;
hours_lb.Text = (String.Format("{0}", reader["NO_HOURS"]));
thcell.Controls.Add(date_lb);
tcell.Controls.Add(hours_lb);
t_row.Cells.Add(thcell);
th_row.Cells.Add(tcell);
}
}
}
catch (SqlException ex)
{
Label1.Text = "<p>Error Code" + ex.Number + ": " + ex.Message + "</p>";
}
finally
{
dbConnection.Close();
}
//try
//{
// dbConnection.Open();
// string query = "SELECT NO_HOURS FROM TIMESHEET_DETAILS WHERE TIMESHEET_ID=" + s1;
// sqlcommand = new SqlCommand(query, dbConnection);
// reader = sqlcommand.ExecuteReader();
// int counter = 1;
// TableRow th_row = new TableRow();
// table2.Rows.Add(th_row);
// while (reader.Read())
// {
// TableCell tcell = new TableCell();
// Label lb = new Label();
// lb.Text = (String.Format("{0}", reader[0]));
// tcell.Width = 20;
// tcell.Height = 25;
// tcell.Controls.Add(lb);
// th_row.Cells.Add(tcell);
// }
// //foreach(var x in (string)reader["NO_HOURS"])
// //{
// // Label1.Text += Convert.ToInt32(x).ToString();
// //}
//}
//catch (SqlException ex)
//{
// Label1.Text = "<p>Error Code" + ex.Number + ": " + ex.Message + "</p>";
//}
//finally
//{
// dbConnection.Close();
//}
}
protected void Page_Load(object sender, EventArgs e)
{
Input = string.Format("{0}", Request.QueryString["Input"]); //get the topic Id
U = string.Format("{0}", Request.QueryString["U"]);
/*Table info initialization*/
TableHeaderRow header = new TableHeaderRow();
TableCell Title = new TableCell();
TableCell Content = new TableCell();
TableRow row = new TableRow();
header.ForeColor = ColorTranslator.FromHtml("#a4d5f7");
header.Font.Bold = true;
header.Font.Name = "Calibri";
Title.Text = "Search Results for \"" + Input + "\" :";
Title.HorizontalAlign = HorizontalAlign.Left;
Content.BackColor = ColorTranslator.FromHtml("#ece9e9");
/*Block for different search result*/
if (Input != "") // not a empty value
{
int Inlen = Input.Length;
if (Input.Contains("user ") && Input.IndexOf("user ") + 5 != Inlen)
{
Content.Text = "<br/>Found Users: <br/><br/>" + SearchUser(Input.Substring(Input.IndexOf("user ") + 5, Inlen - Input.IndexOf("user ") - 5));
}
else if (Input.Contains("topic ") && Input.IndexOf("topic ") + 6 != Inlen)
{
Content.Text = "<br/>Found Topics: <br/><br/>" + SearchTopic(Input.Substring(Input.IndexOf("topic ") + 6, Inlen - Input.IndexOf("topic ") - 6));
}
else if (Input.Contains("comment ") && Input.IndexOf("comment ") + 8 != Inlen)
{
Content.Text = "<br/>Found Comments: <br/><br/>" + SearchComment(Input.Substring(Input.IndexOf("comment ") + 8, Inlen - Input.IndexOf("comment ") - 8));
}
else if (Input.Contains("band ") && Input.IndexOf("band ") + 5 != Inlen)
{
Content.Text = "<br/>Found Bands: <br/><br/>" + SearchBand(Input.Substring(Input.IndexOf("band ") + 5, Inlen - Input.IndexOf("band ") - 5));
}
else if (Input.Contains("song ") && Input.IndexOf("song ") + 5 != Inlen)
{
Content.Text = "<br/>Found Songs: <br/><br/>" + SearchSong(Input.Substring(Input.IndexOf("song ") + 5, Inlen - Input.IndexOf("song ") - 5));
}
else if (Input.Contains("album ") && Input.IndexOf("album ") + 6 != Inlen)
{
Content.Text = "<br/>Found Albums: <br/><br/>" + SearchAlbum(Input.Substring(Input.IndexOf("album ") + 6, Inlen - Input.IndexOf("album ") - 6));
}
else if (Input.Contains("User ") && Input.IndexOf("User ") + 5 != Inlen)
{
Content.Text = "<br/>Found Users: <br/><br/>" + SearchUser(Input.Substring(Input.IndexOf("User ") + 5, Inlen - Input.IndexOf("User ") - 5));
}
else if (Input.Contains("Topic ") && Input.IndexOf("Topic ") + 6 != Inlen)
{
Content.Text = "<br/>Found Topics: <br/><br/>" + SearchTopic(Input.Substring(Input.IndexOf("Topic ") + 6, Inlen - Input.IndexOf("Topic ") - 6));
}
else if (Input.Contains("Comment ") && Input.IndexOf("Comment ") + 8 != Inlen)
{
Content.Text = "<br/>Found Comments: <br/><br/>" + SearchComment(Input.Substring(Input.IndexOf("Comment ") + 8, Inlen - Input.IndexOf("Comment ") - 8));
}
else if (Input.Contains("Band ") && Input.IndexOf("Band ") + 5 != Inlen)
{
Content.Text = "<br/>Found Bands: <br/><br/>" + SearchBand(Input.Substring(Input.IndexOf("Band ") + 5, Inlen - Input.IndexOf("Band ") - 5));
}
else if (Input.Contains("Song ") && Input.IndexOf("Song ") + 5 != Inlen)
{
Content.Text = "<br/>Found Songs: <br/><br/>" + SearchSong(Input.Substring(Input.IndexOf("Song ") + 5, Inlen - Input.IndexOf("Song ") - 5));
}
else if (Input.Contains("Album ") && Input.IndexOf("Album ") + 6 != Inlen)
{
Content.Text = "<br/>Found Albums: <br/><br/>" + SearchAlbum(Input.Substring(Input.IndexOf("Album ") + 6, Inlen - Input.IndexOf("Album ") - 6));
}
else
{
Content.Text = "<br/>Found Users: <br/><br/>" + SearchUser(Input) //Comprehensive results
+ "<br/>Found Topics: <br/><br/>" + SearchTopic(Input)
+ "<br/>Found Comments: <br/><br/>" + SearchComment(Input)
+ "<br/>Found Bands: <br/><br/>" + SearchBand(Input)
+ "<br/>Found Songs: <br/><br/>" + SearchSong(Input)
+ "<br/>Found Albums: <br/><br/>" + SearchAlbum(Input);
}
}
/*Add Result to table*/
header.Cells.Add(Title);
row.Cells.Add(Content);
SearchTable.Rows.Add(header);
SearchTable.Rows.Add(row);
SearchTable.CellPadding = 15; // Content Indent
SearchTable.Style.Add("width", "90% !important"); // Inline percentage of table width
}
/* This method gets called when the user clicks the search button */
protected void searchButton_Click(object sender, EventArgs e)
{
try
{
/* Clear previously rendered results */
errorMessageLabel.Text = "";
searchResultsPlaceHolder.Controls.Clear();
/* Extract keywords from the keyword text box */
string keyword = searchTextBox.Text;
/* Create the URL string */
string url = "http://webstrar45.fulton.asu.edu/Page0/WSDLSearchService.svc/DiscoverWsdlServices?keywords=" + keyword;
/* Create a HTTP web request and extract the response */
HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;
HttpWebResponse response = request.GetResponse() as HttpWebResponse;
/* Load the response stream into an XML DOM object */
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(response.GetResponseStream());
XmlNode nodeRef = xmlDoc.DocumentElement;
/* Parse the XML DOM to obtain all the URL Infos */
parseResponseXML(nodeRef);
Table searchResultsTable = new Table();
searchResultsPlaceHolder.Controls.Add(searchResultsTable);
TableHeaderRow th = new TableHeaderRow();
Label titleLabel = new Label();
titleLabel.Text = "Title";
TableHeaderCell titleCell = new TableHeaderCell();
titleCell.Controls.Add(titleLabel);
th.Cells.Add(titleCell);
Label linkLabel = new Label();
linkLabel.Text = "Link";
TableHeaderCell linkCell = new TableHeaderCell();
linkCell.Controls.Add(linkLabel);
th.Cells.Add(linkCell);
searchResultsTable.Controls.Add(th);
/* Traverse through the entire list of URLs obtained, and create a list */
/* of URLs and their titles. */
foreach(var urlInfo in urlInfos)
{
if (urlInfo == null || urlInfo == "")
break;
TableRow tr = new TableRow();
string[] urlInfoDecoded = urlInfo.Split(new String[] {"-[TL-LNK-SEP]-"},
StringSplitOptions.None);
Label titleValue = new Label();
titleValue.Text = urlInfoDecoded[0];
TableCell titleValueCell = new TableCell();
titleValueCell.Controls.Add(titleValue);
tr.Cells.Add(titleValueCell);
HyperLink hyperlink = new HyperLink();
hyperlink.Text = urlInfoDecoded[1];
hyperlink.NavigateUrl = urlInfoDecoded[1];
hyperlink.Target = urlInfoDecoded[1];
TableCell linkValueCell = new TableCell();
linkValueCell.Controls.Add(hyperlink);
tr.Cells.Add(linkValueCell);
searchResultsTable.Controls.Add(tr);
}
}
catch (Exception)
{
/* Display an error message in case of an exception */
errorMessageLabel.Text = "Error - Reached Google Search API Max limit";
return;
}
}
private void creaGrilla(List <Movimiento> listMovs)
{
tableRes.Controls.Clear();
TableHeaderRow thr;
TableHeaderCell thc;
TableRow tr;
TableCell tc;
Label lbl;
LinkButton lnk;
Literal lit;
if (listMovs != null)
{
thr = new TableHeaderRow();
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Nombre";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Fecha";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Documento";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "Tipo";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
tableRes.Rows.Add(thr);
foreach (Movimiento item in listMovs)
{
tr = new TableRow();
tc = new TableCell();
lbl = new Label();
lbl.Text = item.apellidos + " " + item.nombres;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tc = new TableCell();
tc.CssClass = "";
lbl = new Label();
lbl.Text = item.fecha;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tc = new TableCell();
tc.CssClass = "";
lbl = new Label();
lbl.Text = item.documento;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tc = new TableCell();
tc.CssClass = "";
lbl = new Label();
switch (item.tipo)
{
case 1:
lbl.Text = "Peatonal";
break;
case 2:
lbl.Text = "Vehicular";
break;
case 3:
lbl.Text = "Proveedores";
break;
}
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
tableRes.Rows.Add(tr);
}
}
else
{
thr = new TableHeaderRow();
thc = new TableHeaderCell();
thc.CssClass = "";
lbl = new Label();
lbl.Text = "No se encontraron registros";
thc.Controls.Add(lbl);
thr.Cells.Add(thc);
tableRes.Rows.Add(thr);
}
}
/// <summary>
/// Adds all the banned emails to the table for display
/// </summary>
private void DisplayBannedEmails()
{
// Check to see if we're a super user. If not, hide the UI
if (!_basePage.ViewingUser.IsSuperUser)
{
// Remove the UI
foreach (Control control in form1.Controls)
{
control.Visible = false;
}
// Show the super user only message
DisplayUserMessage("This is a superuser only page!", false);
return;
}
// Get the emails from the database
BannedEmailsPageBuilder bannedEmails = new BannedEmailsPageBuilder(_basePage);
// Get the emails based on the search term
if (_letter.CompareTo("All") == 0)
{
_letter = "";
}
bool showSignInBannedOnly = rbFilterSignIn.Checked;
bool showComplaintBannedOnly = rbFilterComplaint.Checked;
bool showAll = rbFilterAll.Checked;
ArrayList bannedEmailArray = bannedEmails.GetBannedEmails(_skip,_show,_searchType,_letter,showSignInBannedOnly,showComplaintBannedOnly,showAll);
tblBannedEmails.Rows.Clear();
// Create the table header
TableHeaderRow headerRow = new TableHeaderRow();
TableCell emailCell = new TableCell();
string orderedBy = "by most recent";
if (_searchType == 1)
{
if (_letter == "")
{
orderedBy = "alphabetically";
}
else
{
orderedBy = "by the letter " + _letter.ToUpper();
}
}
emailCell.Text = "Email address ordered " + orderedBy;
emailCell.Font.Bold = true;
headerRow.Cells.Add(emailCell);
TableCell signInBan = new TableCell();
signInBan.Text = "Sign In Banned";
signInBan.Font.Bold = true;
headerRow.Controls.Add(signInBan);
TableCell complaintBan = new TableCell();
complaintBan.Text = "Complaint Banned";
complaintBan.Font.Bold = true;
headerRow.Controls.Add(complaintBan);
TableCell dateCell = new TableCell();
dateCell.Text = "Date Banned";
dateCell.Font.Bold = true;
headerRow.Cells.Add(dateCell);
TableCell addedByCell = new TableCell();
addedByCell.Text = "Added By";
addedByCell.Font.Bold = true;
headerRow.Cells.Add(addedByCell);
tblBannedEmails.Rows.Add(headerRow);
// Add a row to the table for each item
int i = 0;
foreach (BannedEmailDetails email in bannedEmailArray)
{
// Add the item
CreateTableEntryForEmailItem(email,i++);
}
// Set the total matches for this search
lbTotalResults.Text = bannedEmails.TotalEmails.ToString();
// Update the paging controls
int currentPage = ((_skip + 1) / _show) + 1;
int totalPages = 1;
if (bannedEmails.TotalEmails > 0)
{
totalPages = (int)Math.Ceiling((double)bannedEmails.TotalEmails / (double)_show);
}
btnFirst.Enabled = (_skip > 0);
btnPrevious.Enabled = (_skip > 0);
btnNext.Enabled = ((_skip + _show) < bannedEmails.TotalEmails);
btnLast.Enabled = ((_skip + _show) < bannedEmails.TotalEmails);
lbPage.Text = "Page " + currentPage + " of " + totalPages;
btnFirst2.Enabled = (_skip > 0);
btnPrevious2.Enabled = (_skip > 0);
btnNext2.Enabled = ((_skip + _show) < bannedEmails.TotalEmails);
btnLast2.Enabled = ((_skip + _show) < bannedEmails.TotalEmails);
lbPage2.Text = "Page " + currentPage + " of " + totalPages;
}
protected void Page_Load(object sender, EventArgs e)
{
//根据传过来的工作流ID，加载对应的实例
crowdTaskService = new CrowdTaskService();
taskParentWorkflowId = Request.Params["parentWorkflowId"];
taskWorkflowId = Request.Params["taskWorkflowId"];
//得到需要分解任务实例
CrowdTask crowdTask = crowdTaskService.findCrowdTaskByWorkflowId(taskWorkflowId);
TextBox1.Text = crowdTask.taskName;
TextBox2.Text = crowdTask.taskDescription;
TextBox3.Text = crowdTask.taskWorkflowId;
//根据当前投票任务的名字，来查找分解任务有哪些，在根据这些分解任务的ID，去decomposeResult 里面查找对应的结果
list = crowdTaskService.findAllSonCrowdTaskByParentTaskNameAndTaskDescriptionAndTaskType(crowdTask.taskName, crowdTask.taskDescription, TaskType.decomposeTask, crowdTask.mainTaskId);
foreach (CrowdTask ct in list)
{
ArrayList decomposeResult = crowdTaskService.findDecomposeResultByWorkflowId(ct.taskWorkflowId, crowdTask.mainTaskId);
//创建显示分解结果的表格
Table table = new Table();
table.BorderWidth = 1;
TableHeaderRow tableHeaderRow = new TableHeaderRow();
TableHeaderCell tableHeaderCell1 = new TableHeaderCell();
tableHeaderCell1.Text = "工作流ID：";
TableHeaderCell tableHeaderCell2 = new TableHeaderCell();
tableHeaderCell2.Text = ct.taskWorkflowId;
TableHeaderCell tableHeaderCell3 = new TableHeaderCell();
RadioButton radioButton = new RadioButton();
radioButton.GroupName = "vote";
radioButton.ID = ct.taskWorkflowId;
tableHeaderCell3.Controls.Add(radioButton);
tableHeaderRow.Cells.Add(tableHeaderCell1);
tableHeaderRow.Cells.Add(tableHeaderCell2);
tableHeaderRow.Cells.Add(tableHeaderCell3);
foreach (DecomposeResult dr in decomposeResult)
{
if (dr != null)
{
table.Rows.Add(tableHeaderRow);
}
}
foreach (DecomposeResult dr in decomposeResult)
{
TableRow tr = new TableRow();
TableCell tc = new TableCell();
tc.Text = dr.taskOrder;
TableCell tc1 = new TableCell();
tc1.Text = dr.taskName;
TableCell tc2 = new TableCell();
tc2.Text = dr.taskDescription;
tr.Cells.Add(tc);
tr.Cells.Add(tc1);
tr.Cells.Add(tc2);
table.Rows.Add(tr);
}
panel.Controls.Add(table);
}
}
protected void Page_Load(object sender, EventArgs e)
{
localhost.Service serviceObj = new localhost.Service();
localhost.TenantTableInfo obj = serviceObj.ReadData(11, 31);
string[] arr = obj.FieldNamesProperty;
List<string> array = new List<string>(arr);
string[] values = obj.FieldValuesProperty;
List<string> valuearr = new List<string>(values);
int countRow = valuearr.Count / array.Count;
int counter = 0;
TableRow row = new TableHeaderRow();
var cell1 = new TableCell();
row.TableSection = TableRowSection.TableHeader;
cell1.Text = "Global ID";
row.Cells.Add(cell1);
WfTable.Rows.Add(row);
row.TableSection = TableRowSection.TableHeader;
cell1 = new TableCell();
cell1.Text = "Workflow Name";
row.Cells.Add(cell1);
WfTable.Rows.Add(row);
row.TableSection = TableRowSection.TableHeader;
cell1 = new TableCell();
cell1.Text = "Selection";
row.Cells.Add(cell1);
WfTable.Rows.Add(row);
int addrow = 0;
for (int i = 0; i < countRow; i++)
{
addrow = 0;
row = new TableRow();
RadioButton rbnew = new RadioButton();
if (i == 0)
{
rbnew.Checked = true;
}
for (int j = 0; j < array.Count; j++)
{
TableCell cell = new TableCell();
if (arr[j].ToString() == "GUID")
{
cell.Text = valuearr[counter].ToString();
rbnew.ID = valuearr[counter].ToString();
rbnew.EnableViewState = true;
rbnew.CheckedChanged += new EventHandler(Changed);
rbnew.AutoPostBack = true;
rbnew.GroupName = "Check";
row.Cells.Add(cell);
}
if (arr[j].ToString() == "wfname")
{
cell.Text = valuearr[counter].ToString();
row.Cells.Add(cell);
}
if (arr[j].ToString() == "ownerid")
{
if (Convert.ToInt32(valuearr[counter]) == 11 || Convert.ToInt32(valuearr[counter]) == Convert.ToInt32(Session["OrgId"]))
{
addrow = 1;
}
}
counter++;
}
if (addrow == 1)
{
TableCell cellcheck = null;
row.Cells.Add(cellcheck = new TableCell());
((IParserAccessor)cellcheck).AddParsedSubObject(rbnew);
WfTable.Rows.Add(row);
}
}
}
//protected void DdlMonth_SelectedIndexChanged(object sender, EventArgs e)
//{
// try
// {
// generateCalander();
// ShowHideControlsForPrinter();
// }
// catch (Exception Ex)
// {
// // ExceptionHandler.HandleTrainingException(Ex, "DdlMonth_SelectedIndexChanged", false);
// }
//}
//protected void DdlCourse_SelectedIndexChanged(object sender, EventArgs e)
//{
// try
// {
// LblClassDuration.Text = string.Empty;
// // AppContext.TimeTableClassID = null;
// // AppContext.TimeTableCourseID = UtilityFunctions.MapValue<Int64>(DdlCourse.SelectedValue, typeof(long)); ;
// ClassesGetByCourseID();
// generateCalander();
// ShowHideControlsForPrinter();
// }
// catch (Exception Ex)
// {
// // ExceptionHandler.HandleTrainingException(Ex, "DdlCourse_SelectedIndexChanged", false);
// }
//}
//protected void DdlClass_SelectedIndexChanged(object sender, EventArgs e)
//{
// try
// {
// if (DdlClass.SelectedIndex > 0)
// ClassDuration(UtilityFunctions.MapValue<Int64>(DdlClass.SelectedValue, typeof(long)));
// // AppContext.TimeTableClassID = UtilityFunctions.MapValue<Int64>(DdlClass.SelectedValue, typeof(long));
// // AppContext.TimeTableCourseID = null;
// generateCalander();
// ShowHideControlsForPrinter();
// }
// catch (Exception Ex)
// {
// // ExceptionHandler.HandleTrainingException(Ex, "DdlClass_SelectedIndexChanged", false);
// }
//}
//private void ShowHideControlsForPrinter()
//{
// try
// {
// if (DdlClass.SelectedIndex > 0)
// {
// LblClassName.Text = DdlClass.SelectedItem.Text;
// LblClassName.Visible = DdlClass.SelectedIndex > 0;
// }
// if (DdlCourse.SelectedIndex > 0)
// {
// LblCourseName.Text = DdlCourse.SelectedItem.Text;
// LblCourseName.Visible = DdlCourse.SelectedIndex > 0;
// }
// LblCalenderSpan.Text = DdlYear.SelectedItem.Text + " - " + DdlMonth.SelectedItem.Text;
// }
// catch (Exception Ex)
// {
// // ExceptionHandler.HandleTrainingException(Ex, "ShowHideControlsForPrinter", false);
// }
//}
//private void BindDropDowns()
//{
// try
// {
// DropDownUtil.FillDropDown(DdlCourse, ddl.CourseDDLBAL(CurrentCulture, CompanyID), "Text", "Value", "Course");
// DropDownUtil.FillDropDown(DdlClass, ddl.ClassDDLBAL(CurrentCulture, CompanyID), "Text", "Value", "Class");
// UtilityFunctions.FillDropDownWithYears(DdlYear, 5, 20, false);
// UtilityFunctions.FillDropDownListFromEnumCollection(DdlMonth, EnumManager.GetEnumCollection(typeof(Month)), true, "Month");
// DdlYear.SelectedValue = DdlYear.Items.FindByText(UtilityFunctions.GetCurrentDateTime().Year.ToString()).ToString();
// DdlMonth.SelectedValue = UtilityFunctions.GetCurrentDateTime().Month.ToString();
// generateCalander();
// }
// catch (Exception)
// {
// throw;
// }
//}
/// <summary>
/// <para>Description:
/// This Method will get Classes of Course by CourseID and Rebind Class DropDown</para>
/// <para>Created By: Majid ali </para>
/// <para>Created Date: 9/26/2013 </para>
/// </summary>
//private void ClassesGetByCourseID()
//{
// try
// {
// if (DdlCourse.SelectedIndex > 0)
// {
// DropDownUtil.FillDropDown(DdlClass, ddl.Course_ClassDDLBAL(CurrentCulture, CompanyID, Convert.ToInt64(DdlCourse.SelectedValue)), "Text", "Value", "Class");
// }
// else
// {
// BindDropDowns();
// // UCReport.ClearReport();
// }
// }
// catch (Exception)
// {
// }
//}
/// <summary>
/// <para>Description:
/// This Method will Bind Timetable of Sessions</para>
/// <para>Created By: Majid ali </para>
/// <para>Created Date: 9/26/2013 </para>
/// </summary>
protected void generateCalander()
{
CalendarContainer.Controls.Clear();
try
{
long?ClassID = 0;
long?CourseID = 0;
if (ClassIDCall == null)
{
ClassID = 0;
}
else
{
ClassID = Convert.ToInt64(ClassIDCall);
}
if (CourseIDCall == null)
{
CourseID = 0;
}
else
{
CourseID = Convert.ToInt64(CourseIDCall);
}
DateTime now = Convert.ToDateTime(startDate);
var startDate1 = new DateTime(now.Year, now.Month, 1);
var endDate1 = startDate1.AddMonths(1).AddDays(-1);
DataTable list = _PersonBAL.SessionsByCourseAndClassID(CourseID, ClassID, CompanyID, startDate1, endDate1);
Table tb = new Table();
TableHeaderCell thSunday = new TableHeaderCell();
thSunday.Text = UtilityFunctions.GetEnumDescrptionFromObjectValue(typeof(Days), Days.Days_Sunday);
thSunday.Width = 120;
TableHeaderCell thMonday = new TableHeaderCell();
thMonday.Text = UtilityFunctions.GetEnumDescrptionFromObjectValue(typeof(Days), Days.Days_Monday);
thMonday.Width = 120;
TableHeaderCell thTuesday = new TableHeaderCell();
thTuesday.Text = UtilityFunctions.GetEnumDescrptionFromObjectValue(typeof(Days), Days.Days_Tuesday);
thTuesday.Width = 120;
TableHeaderCell thWednesday = new TableHeaderCell();
thWednesday.Text = UtilityFunctions.GetEnumDescrptionFromObjectValue(typeof(Days), Days.Days_Wednesday);
thWednesday.Width = 120;
TableHeaderCell thThursday = new TableHeaderCell();
thThursday.Text = UtilityFunctions.GetEnumDescrptionFromObjectValue(typeof(Days), Days.Days_Thursday);
thThursday.Width = 120;
TableHeaderCell thFriday = new TableHeaderCell();
thFriday.Text = UtilityFunctions.GetEnumDescrptionFromObjectValue(typeof(Days), Days.Days_Friday);
thFriday.Width = 120;
TableHeaderCell thSaturday = new TableHeaderCell();
thSaturday.Text = UtilityFunctions.GetEnumDescrptionFromObjectValue(typeof(Days), Days.Days_Saturday);
thSaturday.Width = 120;
TableHeaderRow th = new TableHeaderRow();
th.Cells.Add(thSunday);
th.Cells.Add(thMonday);
th.Cells.Add(thTuesday);
th.Cells.Add(thWednesday);
th.Cells.Add(thThursday);
th.Cells.Add(thFriday);
th.Cells.Add(thSaturday);
tb.Rows.Add(th);
for (int i = 0; i < 6; i++)
{
TableRow tr = new TableRow();
for (int j = 0; j < 7; j++)
{
TableCell tc1 = new TableCell();
tc1.Height = 120;
tr.Cells.Add(tc1);
}
tr.Height = 50;
tb.GridLines = GridLines.Both;
tb.CssClass = "timetable";
tb.Rows.Add(tr);
}
CalendarContainer.Controls.Add(tb);
//***********************************************
String str = startDate;
var words = str.Split(@"/");
int monthDDl = Convert.ToInt32(words[0]);
int yearDDl = Convert.ToInt32(words[1]);
DateTime dt = new DateTime(Convert.ToInt32(words[1]), Convert.ToInt32(words[0]), 1);
//int fDay = (int)dt.DayOfWeek + 1;
int fDay = (int)dt.DayOfWeek;
int totalDaysInMonth = DateTime.DaysInMonth(Convert.ToInt32(words[1]), Convert.ToInt32(words[0]));
int day = 0;
int indexOfCalender = 0;
int nextMontDays = 0;
int TotalDaysInlastMonth = 0;
int month = int.Parse(words[0]);
int year = int.Parse(words[1]);
int LnkBtnID = 0;
if (Convert.ToInt32(words[0]) == 1)
{
TotalDaysInlastMonth = DateTime.DaysInMonth(Convert.ToInt32(words[1]), 12);
}
else
{
TotalDaysInlastMonth = DateTime.DaysInMonth(Convert.ToInt32(words[1]), Convert.ToInt32(words[0]));
}
int count = tb.Rows.Count * tb.Rows[0].Cells.Count;
for (int dayOfWeek = 1; dayOfWeek < 7; dayOfWeek++)
{
for (int weekOfMonth = 0; weekOfMonth < 7; weekOfMonth++)
{
++indexOfCalender;
if (indexOfCalender == (DateTime.Now.Day + fDay) && (words[0] == DateTime.Now.Month.ToString()) && (words[1] == DateTime.Now.Year.ToString()))
{
tb.Rows[dayOfWeek].Cells[weekOfMonth].Style.Add("background-color", "LimeGreen");// = System.Drawing.Color.LimeGreen;
}
if (indexOfCalender <= fDay && day < totalDaysInMonth)
{
LinkButton linkbutton = new LinkButton();
TotalDaysInlastMonth++;
linkbutton.Text = (TotalDaysInlastMonth - fDay).ToString() + "<br/>";
tb.Rows[dayOfWeek].Cells[weekOfMonth].Controls.Add(linkbutton);
linkbutton.Enabled = false;
int TempYear = month == 1 ? (year) : year;
int TempMonth = month == 1 ? 12 : month;
int TempDay = (TotalDaysInlastMonth - fDay);
SetControlsInCells(list, indexOfCalender, TempYear, TempMonth, TempDay, linkbutton, LnkBtnID, tb, dayOfWeek, weekOfMonth);
}
else if (indexOfCalender > fDay && day < totalDaysInMonth)
{
++day;
LinkButton linkbutton = new LinkButton();
if (indexOfCalender - 1 == fDay)
{
string monthName1 = new DateTime(yearDDl, monthDDl, 1)
.ToString("MMMM", CultureInfo.CreateSpecificCulture("en"));
linkbutton.Text = monthName1 + "<br/> " + day.ToString() + "<br/>";
}
else
{
linkbutton.Text = day.ToString() + "<br/>";
}
tb.Rows[dayOfWeek].Cells[weekOfMonth].Controls.Add(linkbutton);
linkbutton.Enabled = false;
SetControlsInCells(list, indexOfCalender, year, month, day, linkbutton, LnkBtnID, tb, dayOfWeek, weekOfMonth);
}
else if (indexOfCalender > totalDaysInMonth)
{
++nextMontDays;
LinkButton linkbutton = new LinkButton();
if (nextMontDays == 1)
{
if (words[0] == "12")
{
linkbutton.Text = UtilityFunctions.GetEnumDescrptionFromObjectValue(typeof(Month), Month.Month_January) + "<br/>" + nextMontDays.ToString() + "<br/>";
}
else
{
if (12 > monthDDl)
{
string monthName1 = new DateTime(yearDDl, monthDDl + 1, 1)
.ToString("MMMM", CultureInfo.CreateSpecificCulture("en"));
linkbutton.Text = monthName1 + "<br/>" + nextMontDays.ToString() + "<br/>";
}
else
{
linkbutton.Text = UtilityFunctions.GetEnumDescrptionFromObjectValue(typeof(Month), Month.Month_January) + "<br/>" + nextMontDays.ToString() + "<br/>";
}
}
}
else
{
linkbutton.Text = nextMontDays.ToString() + "<br/>";
}
tb.Rows[dayOfWeek].Cells[weekOfMonth].Controls.Add(linkbutton);
linkbutton.Enabled = false;
int TempYear = month == 12 ? (year + 1) : year;
int TempMonth = month == 12 ? 1 : month + 1;
int TempDay = nextMontDays;
SetControlsInCells(list, indexOfCalender, TempYear, TempMonth, TempDay, linkbutton, LnkBtnID, tb, dayOfWeek, weekOfMonth);
}
}
}
if (Convert.ToInt32(monthDDl) == 1)
{
TotalDaysInlastMonth = DateTime.DaysInMonth(Convert.ToInt32(yearDDl), 12);
}
else
{
TotalDaysInlastMonth = DateTime.DaysInMonth(Convert.ToInt32(yearDDl), Convert.ToInt32(monthDDl));
}
//DateTime d1;//
//if (month == 1)
// d1 = new DateTime(year - 1, 12, TotalDaysInlastMonth - fDay + 1);
//else
// d1 = new DateTime(year, month - 1, TotalDaysInlastMonth - fDay + 1);
//DateTime d2;// = new DateTime(2012, 6, 8);
//if (month == 12)
// d2 = new DateTime(year + 1, 1, indexOfCalender - totalDaysInMonth - 1);
//else
// d2 = new DateTime(year, month + 1, indexOfCalender - totalDaysInMonth - 1);
foreach (var item in MyColorList)
{
item.Name = item.Name.Replace("#*#", string.Empty);
item.Name = item.Name.Replace("<br>", ", ");
}
rptColors.DataSource = MyColorList;
rptColors.DataBind();
rptColors.Visible = rptColors.Items.Count > 0;
//*******************************************
}
catch (System.Exception ex)
{
throw;
}
}
