TechnoArkay: January 2009

1 using System;

2 using System.Collections.Generic;

3 using System.Data;

4 using System.Linq;

6 using System.Web;

7 using System.Web.UI;

8 using System.Web.UI.WebControls;

9 using ReviewFrame;

11 public partial class PositionBuilder : System.Web.UI.Page

12 {

14 string gLastClicked = "";

15 List<string> gSkillSetIDList;

16 int gPositionID = 0;

18 private int DepartmentID { get { return (ddlDepartment.SelectedIndex > 0 ? Convert.ToInt32(ddlDepartment.SelectedItem.Value) : 0); } }

19 private int JobNameID { get { return (ddlJobName.SelectedIndex > 0 ? Convert.ToInt32(ddlJobName.SelectedItem.Value) : 0); } }

20 private int SkillSetID { get { return (ddlSkillSet.SelectedIndex > 0 ? Convert.ToInt32(ddlSkillSet.SelectedItem.Value) : 0); } }

21 string txtNestedTextBox = "<div>{0}</div><br/><input id='{1}' value='' class='nestedTextBox' type='text' runat='server' style='width:600px; font-size: 10pt' />";

23 protected override void OnInit(EventArgs e)

24 {

25 base.OnInit(e);

28 //// *** Read our custom client managed Form Var that holds the tab selection

29 try

30 {

31 StatusBar1.addNewLine("BEGIN OnInit");

33 //LoadTab();

34 // MeasurementTabRow.Visible = false;

35 //loadMeasurement();

37 StatusBar1.addNewLine("END OnInit");

38 }

39 catch (Exception ex)

40 {

41 InsertError(ex);

42 }

43 }

45 protected void Page_Load(object sender, EventArgs e)

46 {

47 #region IsPostBack

48 if (Page.IsPostBack)

49 {

51 }

52 else

53 {

54 //LoadExistingUserData();

55 StatusBar1.addNewLine("not postback");

56 loadDepartment();

57 loadJobName();

58 // loadSkillSet();

59 StatusBar1.addNewLine(ddlJobName.SelectedIndex.ToString());

60 lblCreatedDate.Text = (lblCreatedDate.Text == string.Empty ? DateTime.Now.ToShortDateString() : lblCreatedDate.Text);

61 }

62 #endregion IsPostBack

63 }

65 private SSM_Cache FieldValues

66 {

67 get

68 {

69 SSM_Cache TableObject = new SSM_Cache()

70 {

71 DepartmentID = (ddlDepartment.SelectedIndex > 0 ? Convert.ToInt32(ddlDepartment.SelectedItem.Value) : 0),

72 JobNameID = (ddlJobName.SelectedIndex > 0 ? Convert.ToInt32(ddlJobName.SelectedItem.Value) : 0),

73 SkillSetID = (ddlSkillSet.SelectedIndex > 0 ? Convert.ToInt32(ddlSkillSet.SelectedItem.Value) : 0),

74 SessionID = Session.SessionID

75 };

77 return TableObject;

79 //TableObject.DepartmentID = Convert.ToInt32(ddlDepartment.SelectedItem.Value);

80 //TableObject.JobNameID = Convert.ToInt32(ddlJobName.SelectedValue);

81 //TableObject.MeasurementID = Convert.ToInt32(ddlSkillSet.SelectedValue);

82 //TableObject.SkillSetID = Convert.ToInt32(ddlSkillSet.SelectedValue);

83 //TableObject.SessionID = Session.SessionID;

84 }

85 }

91 ///// <summary>

92 ///// Gets SSM_Cache Table Data Based on Current Session.SessionID

93 ///// </summary>

94 ///// <returns>

95 ///// <list type="bool">Exists</list>

96 ///// <list type="Object">Query</list>

97 ///// <list type="int">Count</list>

98 ///// </returns>

99 //private QueryReturnType GetSSMCache()

100 //{

101 // QueryReturnType Result = new QueryReturnType();

102 // var query = new GSRDB1DataContext().SSM_Caches.Where(o => o.SessionID == Session.SessionID);

103 // Result.Query = query;

104 // Result.Count = query.Count();

105 // return Result;

106 //}

107

108 #region DOM/JavaScript/Ajax/JSON

109 //====================================================================================

110 protected void PostBackReturn(object sender, EventArgs e)

111 {

112 __CodeBehindReturn.Value = __CodeBehindInput.Value;

113 string JSScript_LoadScrollPosition = String.Format("<script type='text/javascript'>alert('here PostBackReturn');</script>");

114 //return "you clicked it";

115

116 KSSMCache QR = new KSSMCache();

117 QR.SessionID = Session.SessionID.ToString();

118 //QR.DepartmentID = 1;

119 //QR.JobNameID = 1;

120 //QR.SkillSetID = 1;

121 QR.MeasurementID = 18;

122

123 UpdateSSMCached(QR);

124 }

125

126 private void JSShowModalBox()

127 {

128 string JSScript_LoadScrollPosition = String.Format("<script type='text/javascript'>ShowModal();</script>");

129 ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "temp", JSScript_LoadScrollPosition, false);

130 }

131

132 private void JS_MaintainScrollPosition()

133 {

134 string JSScript_LoadScrollPosition = "<script type='text/javascript'>LoadScrollPosition();</script>";

135 ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "temp", JSScript_LoadScrollPosition, false);

136 }

137

138 private void JS_GetDescriptionTextFieldValue(string counter)

139 {

140 string JSScript_LoadScrollPosition = String.Format("<script type='text/javascript'>getDescriptionTextFieldValue('{0}');</script>", counter);

141 ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "temp", JSScript_LoadScrollPosition, false);

142 }

143

144 private void JavaScriptCall(string JScript)

145 {

146 ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "temp", JScript, false);

147 }

148 //====================================================================================

149 #endregion

150

151

152

153 private Position PositionFieldValues

154 {

155 get

156 {

157 Position tPosition = new Position() { Description = txtDescription.Text, CreatedDate = Convert.ToDateTime(lblCreatedDate.Text) };

158

159 return tPosition;

160 //tPosition.Description = txtDescription.Text;

161 //tPosition.CreatedDate = Convert.ToDateTime(lblCreatedDate.Text);

162 }

163 }

164

165 public void ConvertData(object sender, EventArgs e)

166 {

167 StatusBar1.addNewLine("here ConvertData");

168

169 KSSMCache QR = new KSSMCache();

170 GSRDB1DataContext db = new GSRDB1DataContext();

171 SSM_Cache oSSMCache = new SSM_Cache();

172

173 int UserID = Convert.ToInt32(Session["UserID"]);

174

175 var query = from p in db.SSM_Caches

176 where p.UserID == Convert.ToInt32(UserID)

177 select p;

178 foreach (var x in query)

179 {

180 StatusBar1.addNewLine(x.MeasurementID.ToString());

181 }

182

183 }

184

185 protected void InsertWrongData(object sender, EventArgs e)

186 {

187 KSSMCache QR = new KSSMCache();

188 QR.InsertWrongData(11849, "5xlbyc45xv4klxvmgbep1e40");

189 }

190 // if SSM Cache Exists

191 private void LoadExistingUserData()

192 {

193 KSSMCache QR = new KSSMCache();

194

195 int UserID = Convert.ToInt32(Session["UserID"]);

196

197 QR.UserID = UserID;

198 QR.SessionID = Session.SessionID;

199

200

201

202 var query = QR.GetUserData(UserID);

203

204 int CountByUserID = query.Count();

205 int CountBySessionID = query.Where(o => o.SessionID == Session.SessionID).Count();

206

207 int isBlankSessionID = QR.HasBlankedSessionID();

208

209

210 bool ByUserIDExists = QR.UserIDExists;

211 bool BySessionIDUserIDExists = QR.SessionIDExists;

212

213

214 if (CountByUserID == CountBySessionID)

215 {

216 // Good to go...

217 // nothing needs to be done...

218 LoadTab();

219 UpdatePanel1.Update();

220 }

221

222 if (CountByUserID != CountBySessionID)

223 {

224 //needs fixing

225 __SessionIDBlank.Value = isBlankSessionID.ToString();

226 __UserIDExists.Value = QR.UserIDExists.ToString().ToLower();

227 __SessionIDExists.Value = QR.SessionIDExists.ToString().ToLower();

228 __UserID.Value = UserID.ToString();

229 string Message = "\n" + "You have an Existing Data but the data doesn't match your session ID" + "\n" + "Would you like to recover the data?";

230 divMessageByServer.InnerText = Message;

231 }

232

233

234 if (ByUserIDExists && (isBlankSessionID > 0))

235 {

236 __SessionIDBlank.Value = isBlankSessionID.ToString();

237 __UserIDExists.Value = "true";

238 __SessionIDExists.Value = "true";

239 __ItemClicked.Value = "true";

240 __UserID.Value = UserID.ToString();

241

242 int UpdateCount = QR.UpdateWithCurrentSessionID(UserID, QR.SessionID);

243

244 string Message = "\n" + "Data Has Been Converted: " + UpdateCount.ToString();

245

246 divResponseMessage.InnerText = Message;

247

248 System.Threading.Thread.Sleep(1000);

249

250 UpdatePanel1.Update();

251

252 System.Threading.Thread.Sleep(1000);

253

254 ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "temp", "<script>window.location.reload();</script>", false);

255 }

256

257 StatusBar1.addNewLine(UserID.ToString());

258 StatusBar1.addNewLine("userid count: " + CountByUserID.ToString());

259 StatusBar1.addNewLine("session count: " + CountBySessionID.ToString());

260

261 }

262

263 private void loadMeasurement2(string alpha)

264 {

265 KMeasurement oMeasurement = new KMeasurement();

266

267 var query = oMeasurement.getMeasurements().Where(o => o.Name.ToLower().StartsWith(alpha.ToLower()));

268

269 ddlMeasurement.Items.Clear();

270 ddlMeasurement.Items.Add("");

271

272 cblMeasurement.Items.Clear();

273 cblMeasurement.Items.Add("");

274

275 foreach (var x in query)

276 {

277 ListItem newItem = new ListItem();

278 newItem.Text = x.Name;

279 newItem.Value = x.ID.ToString();

280 ddlMeasurement.Items.Add(newItem);

281 cblMeasurement.Items.Add(newItem);

282 }

283 }

284

285

286 #region preload/clear

287 //====================================================================================

288 private void refreshForm()

289 {

290 StatusBar1.addNewLine("refreshForm BEGINS -----");

291 //updateGrids();

292 loadGridValues();

293 StatusBar1.addNewLine("refreshForm ENDS -----");

294 }

295

296 /// <summary>

297 /// loads form fields

298 /// doesn't not load table weight values

299 /// </summary>

300 /// <returns></returns>

301 private bool getCurrentValues()

302 {

303 bool success = false;

304

305 int DepartmentIndex = Convert.ToInt32(ddlDepartment.SelectedValue);

306 int JobNameIndex = Convert.ToInt32(ddlJobName.SelectedValue);

307

308 GSRDB1DataContext db = new GSRDB1DataContext();

309

310 var query = from p in db.Positions

311 where p.DepartmentID == DepartmentIndex && p.JobNameID == JobNameIndex

312 select p;

313

314 StatusBar1.addNewLine("getCurrentValues() query: " + query.Count().ToString() + " " + DepartmentIndex + " " + JobNameIndex);

315

316 if (query.Count() > 0)

317 {

318 lblPositionID.Text = query.First().ID.ToString();

319

320 if (query.First().ID > 0)

321 {

322 ddlDepartment.BackColor = System.Drawing.Color.LightGreen;

323 ddlJobName.BackColor = System.Drawing.Color.LightGreen;

324 lblCreatedDate.Text = query.First().CreatedDate.ToString();

325 txtDescription.Text = query.First().Description;

326 success = true;

327 }

328 }

329 else

330 {

331 ddlDepartment.BackColor = System.Drawing.Color.White;

332 ddlJobName.BackColor = System.Drawing.Color.White;

333 lblCreatedDate.Text = "";

334 txtDescription.Text = "";

335 success = false;

336 }

337 return success;

338 }

339

340 class MyDropDownList : System.Web.UI.WebControls.DropDownList

341 {

342 public void Reset()

343 {

344 this.Items.Clear();

345 this.Items.Add("");

346 this.SelectedIndex = - 1;

347 }

348 }

349

350

351

352 private void loadSkillSet(IQueryable<SkillSetMeasurement> querySSM)

353 {

354 //ddlSkillSet.reset();

355 //ddlSkillSet.DataSource = new KSkillSet().ListItems;

356 //ddlSkillSet.DataBind();

357 var query = querySSM.GroupBy(o => o.SkillSetID);

358 foreach (var x in (new GSRDB1DataContext().SkillSets.OrderBy(o => o.Name)))

359 {

360 //ListItem ListItem1 = new ListItem();

361 if (querySSM.Where(o => o.SkillSetID == x.ID).Count() > 0)

362 {

363 StatusBar1.addNewLine("loadSkillSet querySSM search found");

364 ddlSkillSet.Items.Add(new ListItem(x.Name + " [Exists]", x.ID.ToString()));

365 }

366 else

367 {

368 ddlSkillSet.Items.Add(new ListItem(x.Name, x.ID.ToString()));

369 }

370 //ListItem1.Text = x.Name;

371 //ListItem1.Value = x.ID.ToString();

372

373 }

374 ddlSkillSet.SelectedIndex = -1;

375 }

376

377 private void loadPosition()

378 {

379 GSRDB1DataContext db = new GSRDB1DataContext();

380

381 var query = db.Positions.Where(o => o.JobNameID == Convert.ToInt16(ddlJobName.SelectedItem.Value)).First();

382

383 lblCreatedDate.Text = query.CreatedDate.ToString();

384 txtDescription.Text = query.Description;

385 }

386

387 private void fillddlMeasurement()

388 {

389 try

390 {

391 GSRDB1DataContext db = new GSRDB1DataContext();

392 KMeasurement oMeasurement = new KMeasurement();

393

394 var query = oMeasurement.getMeasurements();

395

396 ddlMeasurement.Items.Clear();

397 ddlMeasurement.Items.Add("");

398

399 foreach (var x in query)

400 {

401 ListItem newItem = new ListItem();

402 newItem.Text = x.Name;

403 newItem.Value = x.ID.ToString();

404 ddlMeasurement.Items.Add(newItem);

405 }

406 }

407 catch (Exception ex)

408 {

409 InsertError(ex);

410 }

411 }

412

413 private void loadGridValues()

414 {

415 try

416 {

417 StatusBar1.addNewLine("loadGridValues BEGIN");

418 if (gPositionID == 0)

419 {

420 gPositionID = GetCurrentPositionID();

421 }

422

423 GSRDB1DataContext db = new GSRDB1DataContext();

424 var query = db.Positions.SingleOrDefault(o => o.ID == gPositionID);

425

426 if (query != null)

427 {

428 txtDescription.Text = query.Description.ToString().Replace("\n", "<br/>");

429 }

430

431 var queryPGP = from p in db.PositionGradingPercentages

432 where p.PositionID == gPositionID

433 select p;

434

435 UInt32 SkillSetID = 0;

436

437 foreach (string x in getTextBoxNameList())

438 {

439 TextBox TextA = (TextBox)PlaceHolder1.FindControl("txtPercentage_A_" + x.ToString());

440 TextBox TextB = (TextBox)PlaceHolder1.FindControl("txtPercentage_B_" + x.ToString());

441

442 SkillSetID = Convert.ToUInt32(x);

443 PositionGradingPercentage oPGP = queryPGP.SingleOrDefault(o => o.SkillSetID == SkillSetID);

444

445 if (oPGP != null)

446 {

447 TextA.Text = oPGP.Percentage.ToString();

448 TextB.Text = oPGP.Percentage2.ToString();

449 }

450 }

451

452 StatusBar1.addNewLine("loadGridValues END");

453 }

454 catch (Exception ex)

455 {

456 InsertError(ex);

457 }

458 }

459

460 private void loadJobName()

461 {

462 ddlJobName.Items.Clear();

463 ddlJobName.Items.Add("");

464

465 GSRDB1DataContext db = new GSRDB1DataContext();

466 var query = from p in db.JobNames

467 select p;

468

469 try

470 {

471 foreach (var x in query.OrderBy(o => o.Name))

472 {

473 ddlJobName.Items.Add(new ListItem(x.Name, x.ID.ToString()));

474 }

475 }

476 catch (Exception ex)

477 {

478 InsertError(ex);

479 }

480

481

482 }

483

484 private void loadDepartment()

485 {

486 // var departments = ((IQueryable<Department>)oDept.List).OrderBy(o => o.Name);

487 try

488 {

489 ddlDepartment.Items.Clear(); ddlDepartment.Items.Add(String.Empty);

490 foreach (var x in new GSRDB1DataContext().Departments.AsQueryable())

491 {

492 ddlDepartment.Items.Add(new ListItem(x.Name, x.ID.ToString()));

493 }

494 }

495 catch (Exception ex)

496 {

497 InsertError(ex);

498 }

499 }

500

501 // loads ssm_cache

502 private void LoadTab()

503 {

504 try

505 {

506 GSRDB1DataContext db = new GSRDB1DataContext();

507

508 KDepartment oDepartment = new KDepartment();

509 KMeasurement oMeasurement = new KMeasurement();

510 KSkillSet oSkillSet = new KSkillSet();

511

512 //KSSMCache oCache = new KSSMCache

513 // SessionIDExists DepartmentIDExists JobNameIDExists SkillSetIDExists MeasurementIDExists UserIDExists

514 //StatusBar1.addNewLine(oCache.s

515 Panel newPanel = new Panel();

516 StatusBar1.addNewLine(ddlDepartment.SelectedIndex.ToString());

517 StatusBar1.addNewLine(ddlJobName.SelectedIndex.ToString());

518

519 StatusBar1.addNewLine("department : " + ddlDepartment.SelectedValue);

520 StatusBar1.addNewLine("jobname: " + ddlJobName.SelectedValue);

521

522 foreach (ListItem x in ddlDepartment.Items)

523 {

524 StatusBar1.addNewLine(x.Text + " " + x.Value);

525 }

526

527 foreach (var x in new GSRDB1DataContext().Departments)

528 {

529 StatusBar1.addNewLine(x.Name + " " + x.ID.ToString());

530 }

531

532 var queryJobName = db.Positions.Where(o => o.DepartmentID == DepartmentID && o.JobNameID == JobNameID);

533 StatusBar1.addNewLine("LoadTab queryJobName.Count() " + queryJobName.Count().ToString());

534

535 if (queryJobName != null)

536 {

537 // StatusBar1.addNewLine("LoadTab querySSM.Count() " + queryJobName.Count().ToString());

538 }

539

540 var query = db.SSM_Caches.Where(o => o.SessionID == Session.SessionID);

541

542 //load txtdescription if exists

543 var queryDescription = (query.Where(o => o.Description != null).Count() == 0 ? null : query.Where(o => o.Description != null).First().Description);

544 var queryQualification = (query.Where(o => o.Qualification != null).Count() == 0 ? null : query.Where(o => o.Qualification != null).First().Qualification);

545 //.First().Description;

546 txtDescription.Text = (queryDescription == null ? "" : queryDescription);

547 txtQualification.Text = (queryQualification == null ? "" : queryQualification);

548 // StatusBar1.addNewLine(Session.SessionID + " " + query.Count().ToString());

549 short TabIndex = 100;

550 string strGrade = "";

551 if (query.Count() > 0)

552 {

553 foreach (var x in query.GroupBy(o => o.SkillSetID))

554 {

555 AjaxControlToolkit.TabPanel newTab = new AjaxControlToolkit.TabPanel();

556

557 newTab.ID = x.Key.Value.ToString();

558 newTab.Visible = true;

559 newTab.HeaderText = oSkillSet.GetName(x.Key.Value) + " [" + x.Count().ToString() + "]";

560 newTab.Attributes.Add("overflow", "auto");

561 newTab.ScrollBars = ScrollBars.Vertical;

562 newTab.Attributes.Add("runat", "server");

563 newTab.CssClass = "header";

564

565 //newTab.HeaderTemplate = (new TextBoxCreator(oSkillSet.GetName(x.Key.Value) + " [" + x.Count().ToString() + "]", x.Key.Value.ToString(), Unit.Pixel(50), "header"));

566

567 //string strBabTextBoxA = string.Format(" <asp:TextBox runat='server' CssClass='{0}' EnableViewState='true' ></asp:TextBox>", "txtManager");

568 //string strBabTextBoxB = string.Format(" <asp:TextBox runat='server' CssClass='{0}' EnableViewState='true' ></asp:TextBox>", "txtOther");

569

570 //string strBabTextBox1 = string.Format("<input type='TextBox' runat='server' class='{0}' EnableViewState='true'></input>","txtManager");

571 //string strBabTextBox2 = string.Format("<input type='TextBox' runat='server' class='{0}' EnableViewState='true'></input>", "txtOther");

572 newTab.HeaderText = oSkillSet.GetName(x.Key.Value); // +" [" + x.Count().ToString() + "]";

573

574 Table newTable = new Table();

575 TableRow newRow = new TableRow();

576 newTable.Attributes.Add("width", "400px");

577

578 #region Add Button and Two fields

579 //Button btnUpdate4SkillSet = new Button();

580 //btnUpdate4SkillSet.Text = "Update";

581 //btnUpdate4SkillSet.ID = "btnUpdate4SkillSet";

582 //btnUpdate4SkillSet.Style.Add("cursor", "pointer");

583 //btnUpdate4SkillSet.ToolTip = "Update for " + x.Key.Value.ToString();

584 //btnUpdate4SkillSet.Click += btnUpdate4SkillSet_Click;

585 //btnUpdate4SkillSet.Attributes.Add("runat", "server");

586

587 LiteralControl lblManager = new LiteralControl(String.Format("<span class='{0}' >Manager: </span>", "ManagerLabelCell"));

588 LiteralControl lblOther = new LiteralControl(String.Format("<span class='{0}' >Other: </span>", "OthersLabelCell"));

589

590 TextBox TextBox1 = new TextBox();

591 TextBox1.ID = "txtPercentage_A_" + x.Key.Value.ToString();

592 TextBox1.ToolTip = "txtPercentage_A_" + x.Key.Value.ToString();

593 TextBox1.CssClass = "txtPercentage";

594 TextBox1.Width = Unit.Pixel(30);

595 TextBox1.Height = Unit.Pixel(15);

596 TextBox1.EnableViewState = true;

597 TextBox1.TabIndex = TabIndex;

598 strGrade = (x.Where(o => o.Manager1 != null).Count() != 0 ? x.Where(o => o.Manager1 != null).First().Peer1.Value.ToString() : "0");

599 TextBox1.Text = strGrade;

600 TabIndex++;

601

602 TextBox TextBox2 = new TextBox();

603 TextBox2.ID = "txtPercentage_B_" + x.Key.Value.ToString();

604 TextBox2.ToolTip = "txtPercentage_B_" + x.Key.Value.ToString();

605 TextBox2.CssClass = "txtPercentage";

606 TextBox2.Width = Unit.Pixel(30);

607 TextBox2.Height = Unit.Pixel(15);

608 TextBox2.EnableViewState = true;

609 TextBox2.TabIndex = TabIndex;

610 strGrade = (x.Where(o => o.Self != null).Count() != 0 ? x.Where(o => o.Self != null).First().Self.Value.ToString() : "0");

611 TextBox2.Text = strGrade;

612 TabIndex++;

613

614 TableCell newCell = new TableCell();

615

616 //TableCell newCell = new TableCell();

617 //newCell.Width = Unit.Pixel(30);

618 //newCell.Text = "Manager: ";

619 //newRow.Cells.Add(newCell);

620

621 newCell = new TableCell();

622 newCell.Width = Unit.Pixel(30);

623 //newCell.Controls.Add(lblManager);

624 newCell.Controls.Add(TextBox1);

625 newRow.Cells.Add(newCell);

626

627 // newCell = new TableCell();

628 //newCell.Width = Unit.Pixel(30);

629 //newCell.Text = "Other: ";

630 //newRow.Cells.Add(newCell);

631

632 newCell = new TableCell();

633 newCell.Width = Unit.Pixel(30);

634 newCell.Controls.Add(TextBox2);

635 newRow.Cells.Add(newCell);

636

637 //newCell = new TableCell();

638 //newCell.Width = Unit.Pixel(425);

639 //newCell.HorizontalAlign = HorizontalAlign.Right;

640 //newCell.Controls.Add(btnUpdate4SkillSet);

641 //newRow.Cells.Add(newCell);

642

643 newTable.Rows.Add(newRow);

644 newTab.Controls.Add(newTable);

645 #endregion

646

647 GridView GridView1 = new GridView();

648

649 GridView1.CssClass = "grid1";

650 GridView1.ID = "SSM_" + x.Key.Value.ToString();

651 GridView1.Width = Unit.Pixel(920);

652 GridView1.RowCommand += Grid_RowCommand;

653 //GridView1.PageIndexChanging += Grid_PageIndexChanging;

654 GridView1.RowDeleting += Grid_RowDeleting;

655 //GridView1.AllowPaging = true;

656 GridView1.AutoGenerateColumns = false;

657 GridView1.GridLines = GridLines.None;

658

659 var query1 = from p in query

660 where p.SkillSetID == x.Key

661 select new

662 {

663 Selected = true,

664 SkillSetID = p.SkillSetID,

665 MeasurementID = p.MeasurementID,

666 MeasurementName = oMeasurement.getMeasurementByID(p.MeasurementID.Value)

667 };

668

669 foreach (var y in query1)

670 {

671

672 }

673

674 HTMLUtility oHTMLUtility = new HTMLUtility();

675

676 ButtonField DeleteButton = oHTMLUtility.CreateImageButtonField("Delete", "Delele", 50);

677 BoundField MeasurementField = oHTMLUtility.CreateBoundField("Name", "Measurement Name", "Name", 525);

678 BoundField MeasurementIDField = oHTMLUtility.CreateBoundField("MeasurementID", "ID", "Name", 25);

679 MeasurementField.ControlStyle.CssClass = "Measurement";

680 MeasurementField.ItemStyle.HorizontalAlign = HorizontalAlign.Left;

681 MeasurementIDField.ControlStyle.CssClass = "Measurement";

682 MeasurementIDField.ItemStyle.HorizontalAlign = HorizontalAlign.Left;

683

684 TemplateField TemplateField1 = new TemplateField();

685 TemplateField1.ItemTemplate = new GridViewTemplate4Measurement(DataControlRowType.DataRow, "Name", Unit.Pixel(750), "");

686 TemplateField1.HeaderTemplate = new GridViewTemplate4Measurement(DataControlRowType.Header, "Name", Unit.Pixel(750), "");

687

688 GridViewTemplate4Measurement xx = new GridViewTemplate4Measurement(DataControlRowType.Header, "Name", Unit.Pixel(750), "");

689

690 GridView1.Columns.Add(DeleteButton);

691 GridView1.Columns.Add(TemplateField1);

692 //GridView1.Columns.Add(MeasurementField);

693 GridView1.Columns.Add(MeasurementIDField);

694

695 GridView1.DataSource = query1;

696 GridView1.DataBind();

697

698 //CheckBoxList CBL = new CheckBoxList();

699 //foreach (var y in query.Where(o => o.SkillSetID == x.Key))

700 //{

701 // string MeasurementName = oMeasurement.getMeasurementByID(y.MeasurementID.Value);

702 // ListItem ListItem1 = new ListItem(MeasurementName, y.MeasurementID.ToString());

703 // ListItem1.Selected = true;

704 // ListItem1.Attributes.Add("textvalue", MeasurementName);

705 // CBL.Items.Add(ListItem1);

706 //}

707 //CBL.Attributes.Add("runat", "server");

708 //newTab.Controls.Add(CBL);

709

710 newTab.Controls.Add(GridView1);

711 TabContainer1.Controls.Add(newTab);

712 }

713 TabContainer1.ActiveTabIndex = 0;

714 }

715 }

716 catch (Exception ex)

717 {

718 InsertError(ex);

719 }

720 }

721

722 //loads ssm

723 private void LoadTab(IQueryable<SkillSetMeasurement> querySSM, IQueryable<Position> queryPosition)

724 {

725 try

726 {

727 GSRDB1DataContext db = new GSRDB1DataContext();

728

729 KDepartment oDepartment = new KDepartment();

730 KMeasurement oMeasurement = new KMeasurement();

731 KSkillSet oSkillSet = new KSkillSet();

732

733 Panel newPanel = new Panel();

734 var queryPGP = db.PositionGradingPercentages.Where(o => o.PositionID == queryPosition.First().ID);

735

736

737

738 var queryJobName = queryPosition.Where(o => o.DepartmentID == DepartmentID && o.JobNameID == JobNameID);

739

740

741 foreach (var x in querySSM.GroupBy(o=>o.SkillSetID) )

742 {

743

744 var query1 = from p in querySSM

745 where p.SkillSetID == x.Key

746 select new

747 {

748 Selected = true,

749 SkillSetID = p.SkillSetID,

750

751

752 MeasurementID = p.MeasurementID,

753 MeasurementName = oMeasurement.getMeasurementByID(p.MeasurementID),

754

755 Manager1 = queryPGP.SingleOrDefault(o => o.SkillSetID == p.SkillSetID).Percentage,

756 Self = queryPGP.SingleOrDefault(o => o.SkillSetID == p.SkillSetID).Percentage2

757 };

758

759

760 //var querySSM2 = from p in querySSM.AsQueryable<SkillSetMeasurement>()

761 // select new

762 // {

763 // SkillSetID = p.SkillSetID,

764 // SkillSetName = db.SkillSets.SingleOrDefault(o => o.ID == p.SkillSetID).Name,

765

766 // MeasurementID = p.MeasurementID,

767 // MeasurementName = db.Measurements.SingleOrDefault(o => o.ID == p.MeasurementID).Name,

768

769 // Manager1 = queryPGP.SingleOrDefault(o => o.SkillSetID == p.SkillSetID).Percentage,

770 // Self = queryPGP.SingleOrDefault(o => o.SkillSetID == p.SkillSetID).Percentage2

771 // };

772

773

774 StatusBar1.addNewLine(query1.Count().ToString());

775 }

776

777 //if (queryJobName != null)

778 //{

779 // StatusBar1.addNewLine("LoadTab querySSM.Count() " + queryJobName.Count().ToString());

780 //}

781

782 //StatusBar1.addNewLine("LoadTab queryPosition.First().Description " + queryPosition.First().Description);

783 //StatusBar1.addNewLine("LoadTab queryPosition.First().Qualification " + queryPosition.First().Qualification);

784 ////.First().Description;

785 //txtDescription.Text = (queryPosition == null ? "" : queryPosition.First().Description);

786 //txtQualification.Text = (queryPosition == null ? "" : queryPosition.First().Qualification);

787 //// StatusBar1.addNewLine(Session.SessionID + " " + query.Count().ToString());

788 //short TabIndex = 100;

789 //string strGrade = "";

790 //if (querySSM2.Count() > 0)

791 //{

792 // StatusBar1.addNewLine("querySSM2 count: " + querySSM2.Count().ToString());

793

794 // foreach (var x in querySSM2.GroupBy(o => o.SkillSetID))

795 // {

796 // AjaxControlToolkit.TabPanel newTab = new AjaxControlToolkit.TabPanel();

797

798 // newTab.ID = x.Key.ToString();

799 // newTab.Visible = true;

800 // newTab.HeaderText = oSkillSet.GetName(x.Key) + " [" + x.Count().ToString() + "]";

801 // newTab.Attributes.Add("overflow", "auto");

802 // newTab.ScrollBars = ScrollBars.Vertical;

803 // newTab.Attributes.Add("runat", "server");

804 // newTab.CssClass = "header";

805

806 // //newTab.HeaderTemplate = (new TextBoxCreator(oSkillSet.GetName(x.Key.Value) + " [" + x.Count().ToString() + "]", x.Key.Value.ToString(), Unit.Pixel(50), "header"));

807

808 // //string strBabTextBoxA = string.Format(" <asp:TextBox runat='server' CssClass='{0}' EnableViewState='true' ></asp:TextBox>", "txtManager");

809 // //string strBabTextBoxB = string.Format(" <asp:TextBox runat='server' CssClass='{0}' EnableViewState='true' ></asp:TextBox>", "txtOther");

810

811 // //string strBabTextBox1 = string.Format("<input type='TextBox' runat='server' class='{0}' EnableViewState='true'></input>","txtManager");

812 // //string strBabTextBox2 = string.Format("<input type='TextBox' runat='server' class='{0}' EnableViewState='true'></input>", "txtOther");

813 // newTab.HeaderText = oSkillSet.GetName(x.Key); // +" [" + x.Count().ToString() + "]";

814

815 // Table newTable = new Table();

816 // TableRow newRow = new TableRow();

817 // newTable.Attributes.Add("width", "400px");

818

819 // #region Add Button and Two fields

820 // //Button btnUpdate4SkillSet = new Button();

821 // //btnUpdate4SkillSet.Text = "Update";

822 // //btnUpdate4SkillSet.ID = "btnUpdate4SkillSet";

823 // //btnUpdate4SkillSet.Style.Add("cursor", "pointer");

824 // //btnUpdate4SkillSet.ToolTip = "Update for " + x.Key.Value.ToString();

825 // //btnUpdate4SkillSet.Click += btnUpdate4SkillSet_Click;

826 // //btnUpdate4SkillSet.Attributes.Add("runat", "server");

827

828 // LiteralControl lblManager = new LiteralControl(String.Format("<span class='{0}' >Manager: </span>", "ManagerLabelCell"));

829 // LiteralControl lblOther = new LiteralControl(String.Format("<span class='{0}' >Other: </span>", "OthersLabelCell"));

830

831 // TextBox TextBox1 = new TextBox();

832 // TextBox1.ID = "txtPercentage_A_" + x.Key.ToString();

833 // TextBox1.ToolTip = "txtPercentage_A_" + x.Key.ToString();

834 // TextBox1.CssClass = "txtPercentage";

835 // TextBox1.Width = Unit.Pixel(30);

836 // TextBox1.Height = Unit.Pixel(15);

837 // TextBox1.EnableViewState = true;

838 // TextBox1.TabIndex = TabIndex;

839 // strGrade = (x.Where(o => o.Manager1 != null).Count() != 0 ? x.Where(o => o.Manager1 != null).First().Manager1.ToString() : "0");

840 // TextBox1.Text = strGrade;

841 // TabIndex++;

842

843 // TextBox TextBox2 = new TextBox();

844 // TextBox2.ID = "txtPercentage_B_" + x.Key.ToString();

845 // TextBox2.ToolTip = "txtPercentage_B_" + x.Key.ToString();

846 // TextBox2.CssClass = "txtPercentage";

847 // TextBox2.Width = Unit.Pixel(30);

848 // TextBox2.Height = Unit.Pixel(15);

849 // TextBox2.EnableViewState = true;

850 // TextBox2.TabIndex = TabIndex;

851 // strGrade = (x.Where(o => o.Self != null).Count() != 0 ? x.Where(o => o.Self != null).First().Self.Value.ToString() : "0");

852 // TextBox2.Text = strGrade;

853 // TabIndex++;

854

855 // TableCell newCell = new TableCell();

856

857 // //TableCell newCell = new TableCell();

858 // //newCell.Width = Unit.Pixel(30);

859 // //newCell.Text = "Manager: ";

860 // //newRow.Cells.Add(newCell);

861

862 // newCell = new TableCell();

863 // newCell.Width = Unit.Pixel(30);

864 // //newCell.Controls.Add(lblManager);

865 // newCell.Controls.Add(TextBox1);

866 // newRow.Cells.Add(newCell);

867

868 // // newCell = new TableCell();

869 // //newCell.Width = Unit.Pixel(30);

870 // //newCell.Text = "Other: ";

871 // //newRow.Cells.Add(newCell);

872

873 // newCell = new TableCell();

874 // newCell.Width = Unit.Pixel(30);

875 // newCell.Controls.Add(TextBox2);

876 // newRow.Cells.Add(newCell);

877

878 // //newCell = new TableCell();

879 // //newCell.Width = Unit.Pixel(425);

880 // //newCell.HorizontalAlign = HorizontalAlign.Right;

881 // //newCell.Controls.Add(btnUpdate4SkillSet);

882 // //newRow.Cells.Add(newCell);

883

884 // newTable.Rows.Add(newRow);

885 // newTab.Controls.Add(newTable);

886 // #endregion

887

888 // GridView GridView1 = new GridView();

889

890 // GridView1.CssClass = "grid1";

891 // GridView1.ID = "SSM_" + x.Key.ToString();

892 // GridView1.Width = Unit.Pixel(920);

893 // GridView1.RowCommand += Grid_RowCommand;

894 // //GridView1.PageIndexChanging += Grid_PageIndexChanging;

895 // GridView1.RowDeleting += Grid_RowDeleting;

896 // //GridView1.AllowPaging = true;

897 // GridView1.AutoGenerateColumns = false;

898 // GridView1.GridLines = GridLines.None;

899

900 // //var query1 = from p in querySSM2

901 // // where p.SkillSetID == x.Key

902 // // select new

903 // // {

904 // // Selected = true,

905 // // SkillSetID = p.SkillSetID,

906 // // MeasurementID = p.MeasurementID,

907 // // MeasurementName = oMeasurement.getMeasurementByID(p.MeasurementID.Value)

908 // // };

909

910 // HTMLUtility oHTMLUtility = new HTMLUtility();

911

912 // ButtonField DeleteButton = oHTMLUtility.CreateImageButtonField("Delete", "Delele", 50);

913 // BoundField MeasurementField = oHTMLUtility.CreateBoundField("MeasurementName", "Measurement Name", "Name", 525);

914 // BoundField MeasurementIDField = oHTMLUtility.CreateBoundField("MeasurementID", "ID", "Name", 25);

915 // MeasurementField.ControlStyle.CssClass = "Measurement";

916 // MeasurementField.ItemStyle.HorizontalAlign = HorizontalAlign.Left;

917 // MeasurementIDField.ControlStyle.CssClass = "Measurement";

918 // MeasurementIDField.ItemStyle.HorizontalAlign = HorizontalAlign.Left;

919

920 // TemplateField TemplateField1 = new TemplateField();

921 // TemplateField1.ItemTemplate = new GridViewTemplate4Measurement(DataControlRowType.DataRow, "Name", Unit.Pixel(750), "");

922 // TemplateField1.HeaderTemplate = new GridViewTemplate4Measurement(DataControlRowType.Header, "Name", Unit.Pixel(750), "");

923

924 // GridViewTemplate4Measurement xx = new GridViewTemplate4Measurement(DataControlRowType.Header, "Name", Unit.Pixel(750), "");

925

926 // GridView1.Columns.Add(DeleteButton);

927 // GridView1.Columns.Add(TemplateField1);

928 // //GridView1.Columns.Add(MeasurementField);

929 // GridView1.Columns.Add(MeasurementIDField);

930

931 // GridView1.DataSource = querySSM2;

932 // GridView1.DataBind();

933

934 // //CheckBoxList CBL = new CheckBoxList();

935 // //foreach (var y in query.Where(o => o.SkillSetID == x.Key))

936 // //{

937 // // string MeasurementName = oMeasurement.getMeasurementByID(y.MeasurementID.Value);

938 // // ListItem ListItem1 = new ListItem(MeasurementName, y.MeasurementID.ToString());

939 // // ListItem1.Selected = true;

940 // // ListItem1.Attributes.Add("textvalue", MeasurementName);

941 // // CBL.Items.Add(ListItem1);

942 // //}

943 // //CBL.Attributes.Add("runat", "server");

944 // //newTab.Controls.Add(CBL);

945

946 // newTab.Controls.Add(GridView1);

947 // TabContainer1.Controls.Add(newTab);

948 // }

949 //TabContainer1.ActiveTabIndex = 0;

950 //}

951 }

952 catch (Exception ex)

953 {

954 InsertError(ex);

955 }

956 }

957

958 private void LoadAlphabetTab()

959 {

960 //try

961 //{

962 // KMeasurement oMeasurement = new KMeasurement();

963 // var query = oMeasurement.FirstLetterList;

964 // HTMLUtility oHU = new HTMLUtility();

965

966 // foreach (var x in query)

967 // {

968 // AjaxControlToolkit.TabPanel newTab = new AjaxControlToolkit.TabPanel();

969

970 // newTab.ID = "btn" + x;

971 // newTab.Visible = true;

972 // newTab.HeaderText = x;

973

974 // newTab.Controls.Add(new LiteralControl(String.Format("<div class={0}>{1}</div>", "randomBox", "hello")));

975

976 // AlphabetTab.Tabs.Add(newTab);

977 // }

978 // AlphabetTab.ActiveTabIndex = 0;

979 //}

980 //catch (Exception ex)

981 //{

982 // StatusBar1.addNewLine(ex.Message + " " + ex.StackTrace);

983 //}

984 }

985 //====================================================================================

986 #endregion preload

987

988 // TextBox firstEmpty = accountDetails.Controls

989 //.All()

990 //.OfType<TextBox>()

991 //.Where(tb => tb.Text.Trim().Length == 0)

992 //.FirstOrDefault();

993

994 #region Short Routines

995 //====================================================================================

996

997 private List<string> getTextBoxNameList()

998 {

999 StatusBar1.addNewLine("getTextBoxNameList BEGIN");

1000

1001 if (gSkillSetIDList == null)

1002 {

1003 gSkillSetIDList = new List<string>();

1004

1005 StatusBar1.addNewLine("PlaceHolder1.Controls.Count: " + PlaceHolder1.Controls.Count.ToString());

1006

1007 foreach (Control x in PlaceHolder1.Controls)

1008 {

1009 if (x.ID != null)

1010 {

1011 //StatusBar1.addNewLine("getTextBoxNameList: PlaceHolder1 x.id " + x.ID);

1012

1013 if (x.ToString().Contains("Table"))

1014 {

1015 Table newTable = (Table)x;

1016

1017 StatusBar1.addNewLine("getTextBoxNameList table id? " + newTable.ID);

1018

1019 gSkillSetIDList.Add(newTable.ID);

1020 }

1021 }

1022 }

1023

1024 StatusBar1.addNewLine("getTextBoxNameList: Filled In *END" + gSkillSetIDList.Count.ToString());

1025 return gSkillSetIDList;

1026 }

1027 else

1028 {

1029 StatusBar1.addNewLine("getTextBoxNameList: Already Exists. *END" + gSkillSetIDList.Count.ToString());

1030 return gSkillSetIDList;

1031 }

1032 }

1033

1034 private int GetCurrentPositionID()

1035 {

1036 try

1037 {

1038 StatusBar1.addNewLine("getCurrentPositionID BEGIN===");

1039

1040 if (gPositionID == 0)

1041 {

1042 StatusBar1.addNewLine(gPositionID.ToString());

1043

1044 int DepartmentID = Convert.ToInt32(ddlDepartment.SelectedItem.Value);

1045 int JobNameID = Convert.ToInt32(ddlJobName.SelectedItem.Value);

1046

1047 GSRDB1DataContext db = new GSRDB1DataContext();

1048 gPositionID = db.Positions.Single(p => p.DepartmentID == DepartmentID && p.JobNameID == JobNameID).ID;

1049

1050 StatusBar1.addNewLine("getCurrentPositionID new END===: " + gPositionID.ToString() + " from "

1051 + DepartmentID.ToString() + " " + JobNameID.ToString());

1052 return gPositionID;

1053 }

1054 else

1055 {

1056 StatusBar1.addNewLine("getCurrentPositionID existing END===");

1057 return gPositionID;

1058 }

1059 }

1060 catch (Exception ex)

1061 {

1062 InsertError(ex);

1063 return -1;

1064 }

1065 }

1066

1067 #endregion Short Routines

1068

1069 private List<TextBox> GetTextBoxList()

1070 {

1071 List<TextBox> TextBoxList = new List<TextBox>();

1072

1073 foreach (AjaxControlToolkit.TabPanel x in TabContainer1.Controls)

1074 {

1075 foreach (var y in x.Controls)

1076 {

1077 if (y.ToString().Contains("Table"))

1078 {

1079 Table Table1 = (Table)y;

1080 foreach (var z in Table1.Controls[0].Controls)

1081 {

1082 TableCell TableCell1 = (TableCell)z;

1083 if (TableCell1.Controls[0].ToString().Contains("TextBox"))

1084 {

1085 TextBox TextBox1 = (TextBox)TableCell1.Controls[0];

1086 TextBoxList.Add(TextBox1);

1087 StatusBar1.addNewLine("GetTextBoxList(): " + TextBox1.ID + " " + TextBox1.Text);

1088 }

1089 }

1090 }

1091 }

1092 }

1093 return TextBoxList;

1094 }

1095

1096

1097 #region Measurement

1098

1099 private void loadMeasurement()

1100 {

1101 StatusBar1.addNewLine("loadMeasurement: " + DateTime.Now.ToString());

1102

1103 KMeasurement oMeasurement = new KMeasurement();

1104 //cblMeasurement.Items.Clear();

1105 //cblMeasurement.DataSource = new KMeasurement().ListItems;

1106 //cblMeasurement.DataBind();

1107 foreach (var x in oMeasurement.getMeasurements().OrderBy(o => o.Name))

1108 {

1109 cblMeasurement.Items.Add(new ListItem(x.Name, x.ID.ToString()));

1110 }

1111 }

1112

1113 protected void cblMeasurement_SelectedIndexChanged(object sender, EventArgs e)

1114 {

1115 CheckBoxList CBL = (CheckBoxList)sender;

1116 blMeasurement.Items.Clear();

1117 txtCheckListBoxData.Text = "";

1118 try

1119 {

1120 foreach (ListItem x in cblMeasurement.Items)

1121 {

1122 if (x.Selected)

1123 {

1124 blMeasurement.Items.Add(x);

1125 txtCheckListBoxData.Text += x.Value + " " + x.Text + "\n";

1126 }

1127 }

1128 Div4blMeasurement.Visible = true;

1129 Div4blMeasurement.Style.Add("height", (blMeasurement.Items.Count * 20).ToString());

1130 }

1131 catch (Exception ex)

1132 {

1133 InsertError(ex);

1134 }

1135 JS_MaintainScrollPosition();

1136 }

1137

1138 //====================================================================================

1139 #endregion

1140

1141

1142 #region Dropdown events

1143 //====================================================================================

1144

1145 protected void ddlDepartment_SelectedIndexChanged(object sender, EventArgs e)

1146 {

1147

1148 }

1149

1150 // CHECK IF THERE IS A POSITION EXISTING.

1151 protected void ddlJobName_SelectedIndexChanged(object sender, EventArgs e)

1152 {

1153 GSRDB1DataContext db = new GSRDB1DataContext();

1154

1155

1156 var queryPosition = db.Positions.Where(o=>o.DepartmentID == Convert.ToInt32(ddlDepartment.SelectedValue) && o.JobNameID == Convert.ToInt32(ddlJobName.SelectedValue));

1157 if (queryPosition.Count() > 0)

1158 {

1159 var querySSM = db.SkillSetMeasurements.Where(o => o.PositionID == queryPosition.First().ID);

1160

1161 loadSkillSet(querySSM);

1162 LoadTab(querySSM, queryPosition);

1163

1164

1165

1166 StatusBar1.addNewLine("querySSM.Count(: " + querySSM.Count().ToString());

1167

1168 //ddlSkillSet.SelectedValue = "";

1169 ddlDepartment.BackColor = System.Drawing.Color.Gray;

1170 ddlJobName.BackColor = System.Drawing.Color.ForestGreen;

1171 StatusBar1.addNewLine("has item");

1172 }

1173 else

1174 {

1175

1176 }

1177 //loadGridValues();

1178

1179

1180

1181 if ( ( ddlDepartment.SelectedIndex > 0 ) && ( ddlJobName.SelectedIndex > 0 ) )

1182 {

1183 MeasurementSelector.Visible = true;

1184 MeasurementCheckBoxListRow.Visible = true;

1185 MeasurementBulletedList.Visible = true;

1186 // MeasurementTabRow.Visible = true;

1187 }

1188 else

1189 {

1190 MeasurementSelector.Visible = false;

1191 MeasurementCheckBoxListRow.Visible = false;

1192 MeasurementBulletedList.Visible = false;

1193 //MeasurementTabRow.Visible = false;

1194 }

1195 }

1196

1197 protected void ddlSkillSet_SelectedIndexChanged(object sender, EventArgs e)

1198 {

1199 if (ddlSkillSet.SelectedIndex > 0)

1200 {

1201 loadMeasurement();

1202 }

1203 }

1204

1205 private ListItemCollection GetblMeasurementItems()

1206 {

1207 //return null;

1208 ListItemCollection Lists = new ListItemCollection();

1209

1210 foreach (ListItem x in blMeasurement.Items)

1211 {

1212 Lists.Add(x);

1213 }

1214

1215 return Lists;

1216 // cblMeasurement.

1217 }

1218

1219 protected void ToggleDebugPanel(object sender, EventArgs e)

1220 {

1221 Button CurrentButton = (Button)sender;

1222

1223 if (CurrentButton.Text == "-")

1224 {

1225 DebugPanel.Visible = false;

1226 }

1227 else

1228 {

1229 DebugPanel.Visible = true; ;

1230 CurrentButton.Text = "-";

1231 }

1232 //btnExpand.Attributes.Add("display", "block");

1233 //btnExpand.Attributes.Add("display", "none");

1234

1235 //btnCollapse.Attributes.Add("display", "block");

1236 //btnCollapse.Attributes.Add("display", "none");

1237

1238 }

1239

1240

1241

1242 //protected void ddlDepartment_TextChanged(object sender, EventArgs e)

1243 //{

1244 //}

1245

1246 //====================================================================================

1247 #endregion Dropdown events

1248

1249

1250

1251

1252 #region User Click Events

1253 //====================================================================================

1254

1255 protected void btnAlertOkay_Click(object sender, EventArgs e)

1256 {

1257 //AlertTable.Visible = false;

1258

1259 System.Threading.Thread.Sleep(2000);

1260 refreshForm();

1261 }

1262

1263 private void AlertBoxAdd(string Title, string Message)

1264 {

1265 //AlertTable.Visible = true;

1266 //lblAlertTitle.Text = Title;

1267 //lblAlertMessage.Text = Message;

1268

1269 }

1270

1271 private void AlertBoxAdd()

1272 {

1273 //AlertTable.Visible = true;

1274 }

1275

1276 //====================================================================================

1277 #endregion User Click Events

1278

1279

1280 #region SSMCache

1281 //====================================================================================

1282

1283 /// <summary>

1284 /// Returns the Query of [GetSSMCache(): SessionID], DepartmentID, JobNameID, SkillSetID

1285 /// </summary>

1286 /// <returns></returns>

1287 //private QueryReturnType SSMCacheExist()

1288 //{

1289 // QueryReturnType Result = new QueryReturnType();

1290

1291 // var query = from SSM_Cache p in (IEnumerable<SSM_Cache>)GetSSMCache().Query

1292 // where p.DepartmentID == DepartmentID &&

1293 // p.JobNameID == JobNameID &&

1294 // p.SkillSetID == SkillSetID

1295 // select p;

1296

1297 // Result.Query = query;

1298 // Result.Count = query.Count();

1299 // Result.Exists = (query.Count() > 0 ? true : false);

1300

1301 // return Result;

1302 //}

1303

1304 //private QuerySSMReturnType SSMCache()

1305 //{

1306 // QuerySSMReturnType Result = new QuerySSMReturnType(Session.SessionID, DepartmentID, JobNameID);

1307

1308 // return Result;

1309 //}

1310

1311 // //MeasurementSelector MeasurementBulletedList MeasurementTabRow MeasurementCheckBoxListRow

1312

1313 private void TruncateSSMCache()

1314 {

1315 new GSRDB1DataContext().Truncate_SSM_Cache();

1316 }

1317

1318

1319 private TableRow GetTableRow(string Header, string session, string department, string jobname, string skillset, string measurement)

1320 {

1321 TableRow newRow = new TableRow();

1322 TableCell newCell;

1323 {

1324 newCell = new TableCell(); newCell.Font.Bold = true; newCell.Text = Header; newRow.Cells.Add(newCell);

1325 }

1326 {

1327 newCell = new TableCell(); newCell.Text = session; newRow.Cells.Add(newCell);

1328 }

1329 {

1330 newCell = new TableCell(); newCell.Text = department; newRow.Cells.Add(newCell);

1331 }

1332 {

1333 newCell = new TableCell(); newCell.Text = jobname; newRow.Cells.Add(newCell);

1334 }

1335 {

1336 newCell = new TableCell(); newCell.Text = skillset; newCell.Text = skillset; newCell.Text = skillset;

1337 }

1338 {

1339 newCell = new TableCell(); newCell.Text = measurement; newCell.Text = measurement;

1340 }

1341 return newRow;

1342 }

1343 private Table GetTable()

1344 {

1345 KSSMCache QueryObject = new KSSMCache(Session.SessionID, DepartmentID, JobNameID, SkillSetID, 0);

1346 Table newTable = new Table();

1347 TableRow newRow = new TableRow();

1348

1349 //Session Department JobName SkillSet Measurement

1350 newTable.Style.Add("width", "640px");

1351 newTable.Style.Add("font-size", "10pt");

1352 newTable.Style.Add("background", "#ccffcc");

1353 newTable.Style.Add("color", "000000");

1354

1355 #region Title

1356 {

1357 newRow = GetTableRow("", "Session", "Department", "JobName", "SkillSet", "Measurement");

1358 newRow.Font.Bold = true;

1359 newTable.Rows.Add(newRow);

1360 }

1361 #endregion

1362

1363 #region IDs

1364 {

1365 newTable.Rows.Add(GetTableRow("Current Value", QueryObject.SessionID, QueryObject.DepartmentID.ToString(), QueryObject.JobNameID.ToString(),

1366 QueryObject.SkillSetID.ToString(), QueryObject.MeasurementID.ToString()));

1367 }

1368 #endregion

1369

1370 #region IDs Exists

1371 {

1372 newTable.Rows.Add(GetTableRow("Exists?", QueryObject.SessionIDExists.ToString(), QueryObject.DepartmentIDExists.ToString(),

1373 QueryObject.JobNameIDExists.ToString(), QueryObject.SkillSetIDExists.ToString(), QueryObject.MeasurementIDExists.ToString()));

1374 }

1375 #endregion

1376

1377 #region Count

1378 {

1379 newTable.Rows.Add(GetTableRow("Count?", "", "", "", QueryObject.SkillSetCount.ToString(), QueryObject.MeasurementCount.ToString()));

1380 }

1381 #endregion

1382

1383 return newTable;

1384 }

1385 private Table GetTable(KSSMCache QueryObject)

1386 {

1387 Table newTable = new Table();

1388 TableRow newRow = new TableRow();

1389

1390 //Session Department JobName SkillSet Measurement

1391 newTable.Style.Add("width", "640px");

1392 newTable.Style.Add("font-size", "10pt");

1393 newTable.Style.Add("background", "#ccffcc");

1394 newTable.Style.Add("color", "000000");

1395

1396 #region Title

1397 {

1398 newRow = GetTableRow("", "Session", "Department", "JobName", "SkillSet", "Measurement");

1399 newRow.Font.Bold = true;

1400 newTable.Rows.Add(newRow);

1401 }

1402 #endregion

1403

1404 #region IDs

1405 {

1406 newTable.Rows.Add(GetTableRow("Current Value", QueryObject.SessionID, QueryObject.DepartmentID.ToString(), QueryObject.JobNameID.ToString(),

1407 QueryObject.SkillSetID.ToString(), QueryObject.MeasurementID.ToString()));

1408 }

1409 #endregion

1410

1411 #region IDs Exists

1412 {

1413 newTable.Rows.Add(GetTableRow("Exists?", QueryObject.SessionIDExists.ToString(), QueryObject.DepartmentIDExists.ToString(),

1414 QueryObject.JobNameIDExists.ToString(), QueryObject.SkillSetIDExists.ToString(), QueryObject.MeasurementIDExists.ToString()));

1415 }

1416 #endregion

1417

1418 #region Count

1419 {

1420 newTable.Rows.Add(GetTableRow("Count?", "", "", "", QueryObject.SkillSetCount.ToString(), QueryObject.MeasurementCount.ToString()));

1421 }

1422 #endregion

1423

1424 return newTable;

1425 }

1426 private Table GetTable(KSSMCache QueryObject, int measurementid)

1427 {

1428 Table newTable = new Table();

1429 TableRow newRow = new TableRow();

1430

1431 //Session Department JobName SkillSet Measurement

1432 newTable.Style.Add("width", "640px");

1433 newTable.Style.Add("font-size", "10pt");

1434 newTable.Style.Add("background", "#ccffcc");

1435 newTable.Style.Add("color", "000000");

1436

1437 #region Title

1438 {

1439 newRow = GetTableRow("", "Session", "Department", "JobName", "SkillSet", "Measurement");

1440 newRow.Font.Bold = true;

1441 newTable.Rows.Add(newRow);

1442 }

1443 #endregion

1444

1445 #region IDs

1446 {

1447 newTable.Rows.Add(GetTableRow("Current Value", QueryObject.SessionID, QueryObject.DepartmentID.ToString(), QueryObject.JobNameID.ToString(),

1448 QueryObject.SkillSetID.ToString(), QueryObject.MeasurementID.ToString()));

1449 }

1450 #endregion

1451

1452 #region IDs Exists

1453 {

1454 newTable.Rows.Add(GetTableRow("Exists?", QueryObject.SessionIDExists.ToString(), QueryObject.DepartmentIDExists.ToString(),

1455 QueryObject.JobNameIDExists.ToString(), QueryObject.SkillSetIDExists.ToString(), QueryObject.MeasurementIDExists.ToString()));

1456 }

1457 #endregion

1458

1459 #region Count

1460 {

1461 newTable.Rows.Add(GetTableRow("Count?", "", "", "", QueryObject.SkillSetCount.ToString(), QueryObject.MeasurementCount.ToString()));

1462 }

1463 #endregion

1464

1465 return newTable;

1466 }

1467

1468 protected void btnSSMCache_Click(object sender, EventArgs e)

1469 {

1470 int DepartmentID = Convert.ToInt32(ddlDepartment.SelectedItem.Value);

1471 int JobNameID = Convert.ToInt32(ddlJobName.SelectedValue);

1472 int SkillSetID = Convert.ToInt32(ddlSkillSet.SelectedValue);

1473

1474 GSRDB1DataContext db = new GSRDB1DataContext();

1475

1476 StatusBar1.ClearControls();

1477

1478 string StringFormat0 = "SessionID DepartmentID JobNameID SkillSetID: MeasurementID: ";

1479 string StringFormat1 = " {0}, {1}, {2}, {3}, {4}";

1480 System.Text.StringBuilder SB = new System.Text.StringBuilder();

1481 SB.AppendLine(StringFormat0 + "<br/>");

1482 try

1483 {

1484 KSSMCache QR = null;

1485 foreach (ListItem x in GetblMeasurementItems())

1486 {

1487 StatusBar1.addNewLine("x.Value: " + x.Value);

1488 int MeasurementID = Convert.ToInt32(x.Value);

1489

1490 #region Setup QuerySSMReturnType

1491

1492 //GetDescriptionTextFieldValue(x.Value);

1493

1494 // QR = new QuerySSMReturnType(Session.SessionID, DepartmentID, JobNameID, SkillSetID, MeasurementID);

1495 QR = new KSSMCache();

1496 QR.SessionID = Session.SessionID;

1497 QR.DepartmentID = DepartmentID;

1498 QR.JobNameID = JobNameID;

1499 QR.SkillSetID = SkillSetID;

1500 QR.MeasurementID = MeasurementID;

1501 // QR.Description = __txtDescriptionNth.Value;

1502

1503 #endregion

1504

1505

1506 #region Stringformats

1507 string StringOutput = string.Format(

1508 StringFormat1,

1509 QR.SessionIDExists.ToString(),

1510 QR.DepartmentIDExists.ToString(),

1511 QR.JobNameIDExists.ToString(),

1512 QR.SkillSetIDExists.ToString(),

1513 QR.MeasurementIDExists.ToString());

1514

1515 string IDOuput = string.Format(

1516 StringFormat1,

1517 QR.SessionIDExists.ToString(),

1518 QR.DepartmentID.ToString(),

1519 QR.JobNameID.ToString(),

1520 QR.SkillSetID.ToString(),

1521 QR.MeasurementID.ToString());

1522 #endregion

1523

1524 if (QR.MeasurementIDExists)

1525 {

1526 SB.AppendLine("EXISTS NOT ADDED" + "<br/>");

1527 }

1528 else

1529 {

1530 bool saved = UpdateSSMCached(QR);

1531 //CreateTab(QR);

1532 SB.AppendLine("ADDED" + "<br/>");

1533 }

1534 SB.AppendLine("IDExists: " + StringOutput + "<br/>");

1535 SB.AppendLine("IDs: " + IDOuput + "<br/>");

1536 }

1537 StatusBar1.AddTableControl(GetTable(QR));

1538 StatusBar1.addNewLine(SB.ToString());

1539 JS_MaintainScrollPosition();

1540

1541 LoadTab();

1542 }

1543 catch (Exception ex)

1544 {

1545 StatusBar1.addNewLine(ex.Message + "<br />" + ex.StackTrace.ToString());

1546 JS_MaintainScrollPosition();

1547 InsertError(ex);

1548 }

1549 }

1550

1551

1552 private bool UpdateSSMCached(KSSMCache QR)

1553 {

1554 try

1555 {

1556 GSRDB1DataContext db = new GSRDB1DataContext();

1557

1558 SSM_Cache SSMCacheData = new SSM_Cache();

1559

1560 SSMCacheData.SessionID = QR.SessionID;

1561 SSMCacheData.DepartmentID = QR.DepartmentID;

1562 SSMCacheData.JobNameID = QR.JobNameID;

1563 SSMCacheData.SkillSetID = QR.SkillSetID;

1564 SSMCacheData.UserID = QR.UserID;

1565 SSMCacheData.MeasurementID = QR.MeasurementID;

1566 // SSMCacheData.Description = QR.des

1567 SSMCacheData.CreatedDate = DateTime.Now;

1568 SSMCacheData.ExpirationDate = DateTime.Now.AddDays(1);

1569 db.SSM_Caches.InsertOnSubmit(SSMCacheData);

1570 db.SubmitChanges();

1571

1572 return true;

1573 }

1574 catch (Exception ex)

1575 {

1576 InsertError(ex);

1577 return false;

1578 }

1579 }

1580

1581 protected void btnUpdate4SkillSet_Click(object sender, EventArgs e)

1582 {

1583 StatusBar1.addNewLine("btnUpdate4SkillSet_Click: TabContainer1.Controls.Count-> " + TabContainer1.Controls.Count.ToString());

1584

1585 GSRDB1DataContext gdb = new GSRDB1DataContext();

1586 HTMLUtility.PositionBuilder oHTMLUtility = new HTMLUtility.PositionBuilder(TabContainer1);

1587

1588

1589 StatusBar1.addNewLine("oHTMLUtility.GradeTextBoxes: " + oHTMLUtility.GradeTextBoxes.Count.ToString());

1590 StatusBar1.addNewLine("oHTMLUtility.CommentTextBoxes: " + oHTMLUtility.CommentTextBoxes.Count.ToString());

1591 foreach (var x in oHTMLUtility.GradeTextBoxes) { StatusBar1.addNewLine(x.GradeType.ToString() + " " + x.TextBox.Text); }

1592 foreach (var x in oHTMLUtility.CommentTextBoxes) { StatusBar1.addNewLine(x.SkillSetID.ToString() + " " + x.MeasurementID.ToString()); }

1593

1594

1595 //txtPercentage_A_17

1596 //txtPercentage_B_17

1597 // SkillSet Part1 and SkillSet Part2

1598

1599 StringUtility oSU = new StringUtility();

1600

1601

1602

1603 int DepartmentID = Convert.ToInt16(ddlDepartment.SelectedItem.Value);

1604 int JobNameID = Convert.ToInt16(ddlJobName.SelectedItem.Value);

1605 string SessionID = Session.SessionID;

1606

1607 //var query2 = from p in oHTMLUtility.GradeTextBoxes.AsQueryable()

1608 // let score = p.Grade

1609 // select new

1610 // {

1611 // score = score

1612 // };

1613

1614 KDepartment oDepartment = new KDepartment();

1615 KJobName oJobName = new KJobName();

1616

1617 IEnumerable<SSM_Cache> QueryResult;

1618

1619 if ((oHTMLUtility.GradeTextBoxes.AsQueryable().Sum(o=>o.Grade) / 2) != 100)

1620 {

1621 StatusBar1.addNewLine("not eq 100: " + oHTMLUtility.GradeTextBoxes.AsQueryable().Sum(o => o.Grade).ToString());

1622 }

1623 else

1624 {

1625 foreach (HTMLUtility.GradeTextBox GradeTextBox in oHTMLUtility.GradeTextBoxes)

1626 {

1627 QueryResult = from p in gdb.SSM_Caches

1628 where p.DepartmentID == DepartmentID &&

1629 p.SessionID == SessionID &&

1630 p.JobNameID == JobNameID &&

1631 p.SkillSetID == GradeTextBox.SkillSetID

1632 select p;

1633

1634 StatusBar1.addNewLine(SessionID.ToString() + " " + oDepartment.GetName(DepartmentID) + " " + oJobName.GetName(JobNameID));

1635 StatusBar1.addNewLine(QueryResult.Count().ToString());

1636 if (GradeTextBox.GradeType == 'A')

1637 {

1638 //StatusBar1.addNewLine("Manager: " + temp[2].ToString() + " " + textbox.Text);

1639 QueryResult.First().Manager1 = GradeTextBox.Grade;

1640 }

1641 else

1642 {

1643 // StatusBar1.addNewLine("Employee: " + temp[2].ToString() + " " + textbox.Text);

1644 QueryResult.First().Self = GradeTextBox.Grade;

1645 QueryResult.First().Peer1 = GradeTextBox.Grade;

1646 }

1647 //ListItems.Add(new ListItem(temp[2], GradeTextBox.Text));

1648 }

1649

1650 QueryResult = from p in gdb.SSM_Caches

1651 where p.DepartmentID == DepartmentID &&

1652 p.SessionID == SessionID &&

1653 p.JobNameID == JobNameID

1654 select p;

1655

1656 QueryResult.First().Description = txtDescription.Text;

1657 QueryResult.First().Qualification = txtQualification.Text;

1658

1659

1660 gdb.SubmitChanges();

1661 }

1662 }

1663

1664

1665

1666

1667

1668

1669 private void CreateTab(KSSMCache QR)

1670 {

1671 //AjaxControlToolkit.TabPanel newTab = new AjaxControlToolkit.TabPanel();

1672 //KDepartment oDepartment = new KDepartment();

1673

1674 //newTab.ID = "btn" + QR.DepartmentID.ToString() + QR.JobNameID.ToString() + QR.SkillSetID.ToString() + QR.MeasurementID.ToString();

1675 //newTab.Visible = true;

1676 //newTab.HeaderText = oDepartment.GetName(QR.DepartmentID);

1677 //newTab.Controls.Add(new LiteralControl(String.Format("<div class={0}>{1}</div>", "randomBox", "hello")));

1678 //TabContainer1.Controls.Add(newTab);

1679 //TabContainer1.ActiveTabIndex = 0;

1680 }

1681

1682 //====================================================================================

1683 #endregion

1684

1685

1686

1687 #region Process Add/Delete/Remove/Complete Process

1688 //====================================================================================

1689

1690 private void clearForm()

1691 {

1692 ddlJobName.SelectedIndex = -1;

1693 lblPositionID.Text = "";

1694 lblCreatedDate.Text = "";

1695 txtDescription.Text = "";

1696 }

1697

1698 /// <summary>

1699 /// called from ibnt_add()

1700 /// </summary>

1701 private void add()

1702 {

1703 StatusBar1.StatusContent += "add() start here <br/>";

1704 try

1705 {

1706 GSRDB1DataContext db = new GSRDB1DataContext();

1707 KPosition oPosition = new KPosition();

1708

1709 int DepartmentID = Convert.ToInt16(ddlDepartment.SelectedItem.Value);

1710 int JobNameID = Convert.ToInt16(ddlJobName.SelectedItem.Value);

1711 int SkillSetID = Convert.ToInt16(ddlSkillSet.SelectedItem.Value);

1712 int MeasurementID = Convert.ToInt16(ddlMeasurement.SelectedItem.Value);

1713

1714 StatusBar1.StatusContent += DepartmentID.ToString() + "<br/>";

1715 StatusBar1.StatusContent += JobNameID.ToString() + "<br/>";

1716 StatusBar1.StatusContent += SkillSetID.ToString() + "<br/>";

1717 StatusBar1.StatusContent += MeasurementID.ToString() + "<br/>";

1718

1719

1720 int PositionID = db.Positions.Single(o => o.DepartmentID == DepartmentID && o.JobNameID == JobNameID).ID;

1721

1722 StatusBar1.StatusContent += "PositionID.ToString(): " + PositionID.ToString() + "<br/>";

1723

1724 bool exist = oPosition.validateMeasurements(JobNameID, MeasurementID);

1725

1726 var queryDoesSkillSetMeasurementExists = from p in db.SkillSetMeasurements

1727 where p.PositionID == PositionID && p.SkillSetID == SkillSetID && p.MeasurementID == MeasurementID

1728 select p;

1729

1730 if (queryDoesSkillSetMeasurementExists.Count() == 0)

1731 {

1732 SkillSetMeasurement tSSM = new SkillSetMeasurement();

1733

1734 tSSM.PositionID = PositionID;

1735

1736 tSSM.DepartmentID = DepartmentID;

1737 tSSM.JobNameID = JobNameID;

1738

1739

1740 tSSM.SkillSetID = SkillSetID;

1741 tSSM.MeasurementID = MeasurementID;

1742

1743 db.SkillSetMeasurements.InsertOnSubmit(tSSM);

1744 db.SubmitChanges();

1745

1746 StatusBar1.StatusContent += " saved...<br/>";

1747 }

1748 else

1749 {

1750 StatusBar1.StatusContent += " not saved...<br/>";

1751 }

1752

1753 }

1754 catch (Exception ex)

1755 {

1756 InsertError(ex);

1757 }

1758 }

1759

1760 /// <summary>

1761 /// There are only 3 saving points

1762 /// 1. ADD SMM - merely adds to SMM_Cache table

1763 /// 2. "Update" updates the scores

1764 /// 3. Complete/Finish

1765 /// DATe: 01-25-2009

1766 /// </summary>

1767 private void Complete()

1768 {

1769 //1.. Create Position

1770 //2. SAVe SMM

1771 //3. SAve..

1772 // save the cheerleader?

1773 //querySSMCached

1774 bool Success = false;

1775 try

1776 {

1777 StatusBar1.addNewLine("here");

1778

1779 int DepartmentID = Convert.ToInt16(ddlDepartment.SelectedItem.Value);

1780 int JobNameID = Convert.ToInt16(ddlJobName.SelectedItem.Value);

1781 GSRDB1DataContext db = new GSRDB1DataContext();

1782

1783 var querySSMCached = from p in db.SSM_Caches

1784 where p.SessionID == Session.SessionID &&

1785 p.DepartmentID == DepartmentID &&

1786 p.JobNameID == JobNameID

1787 select p;

1788

1789 // Create Position

1790 KPosition oPosition = new KPosition();

1791 int PositionID = 0;

1792 Position tPosition;

1793

1794 if (oPosition.Exists(DepartmentID, JobNameID) == false)

1795 {

1796 tPosition = new Position();

1797 tPosition.DepartmentID = querySSMCached.First().DepartmentID;

1798 tPosition.JobNameID = querySSMCached.First().JobNameID;

1799 tPosition.Description = (querySSMCached.Where(o => o.Description != null).Count() > 0 ? querySSMCached.Where(o => o.Description != null).First().Description : "");

1800 tPosition.CreatedDate = DateTime.Now;

1801 tPosition.ModifiedDate = DateTime.Now;

1802 tPosition.Qualification = (querySSMCached.Where(o => o.Qualification != null).Count() > 0 ? querySSMCached.Where(o => o.Qualification != null).First().Qualification : "");

1803 db.Positions.InsertOnSubmit(tPosition);

1804 db.SubmitChanges();

1805 StatusBar1.addNewLine("Position created: ");

1806

1807 System.Threading.Thread.Sleep(2000);

1808

1809 var query0 = from p in db.Positions

1810 where p.DepartmentID == tPosition.DepartmentID &&

1811 p.JobNameID == tPosition.JobNameID

1812 select p;

1813

1814 var query = query0.Where(o => o.CreatedDate == tPosition.CreatedDate).Single();

1815

1816 PositionID = query.ID;

1817 }

1818 // SAVING SSM

1819

1820 StatusBar1.addNewLine("Updating SSM..... " + txtDescription.Text);

1821

1822 var querySSM = db.SkillSetMeasurements.Where(o => o.DepartmentID == DepartmentID && o.JobNameID == JobNameID);

1823

1824 foreach (var x in querySSMCached)

1825 {

1826 var queryExist = from p in querySSM

1827 where p.SkillSetID == x.SkillSetID && p.MeasurementID == x.MeasurementID

1828 select p;

1829

1830 if (queryExist.Count() == 0)

1831 {

1832 SkillSetMeasurement saveQuerySSM = new SkillSetMeasurement();

1833 saveQuerySSM.PositionID = PositionID;

1834 saveQuerySSM.DepartmentID = x.DepartmentID;

1835 saveQuerySSM.JobNameID = x.JobNameID;

1836 saveQuerySSM.SkillSetID = x.SkillSetID.Value;

1837 saveQuerySSM.MeasurementID = x.MeasurementID.Value;

1838 db.SkillSetMeasurements.InsertOnSubmit(saveQuerySSM);

1839 db.SubmitChanges();

1840 StatusBar1.addNewLine("ADDEd: " + x.DepartmentID.ToString() + " " + x.JobNameID.ToString() + " " + x.SkillSetID.ToString() + " " + x.MeasurementID.ToString());

1841 }

1842 else

1843 {

1844 StatusBar1.addNewLine("Not Added: " + x.DepartmentID.ToString() + " " + x.JobNameID.ToString() + " " + x.SkillSetID.ToString() + " " + x.MeasurementID.ToString());

1845 }

1846 }

1847

1848 KSkillSet oSkillSet = new KSkillSet();

1849

1850 //Create PositionGradingPercentage.. or PGP

1851

1852 foreach (var x in querySSMCached.Where(o => o.Manager1.Value != null && o.Self != null))

1853 {

1854 PositionGradingPercentage queryPGP = db.PositionGradingPercentages.SingleOrDefault(p => p.SkillSetID == x.SkillSetID && p.PositionID == PositionID);

1855 if (queryPGP != null)

1856 {

1857 queryPGP.PositionID = PositionID;

1858 queryPGP.Percentage = Convert.ToByte(x.Manager1.Value);

1859 queryPGP.Percentage2 = Convert.ToByte(x.Self.Value);

1860 queryPGP.SkillSetID = x.SkillSetID.Value;

1861 queryPGP.SkillSetName = oSkillSet.GetName(x.SkillSetID.Value);

1862

1863 }

1864 else

1865 {

1866 PositionGradingPercentage PGP = new PositionGradingPercentage();

1867 PGP.PositionID = PositionID;

1868 PGP.Percentage = Convert.ToByte(x.Manager1.Value);

1869 PGP.Percentage2 = Convert.ToByte(x.Self.Value);

1870 PGP.SkillSetID = x.SkillSetID.Value;

1871 PGP.SkillSetName = oSkillSet.GetName(x.SkillSetID.Value);

1872 db.PositionGradingPercentages.InsertOnSubmit(PGP);

1873 }

1874 db.SubmitChanges();

1875 }

1876 StatusBar1.addNewLine(querySSM.Count().ToString() + " --- " + querySSMCached.Count().ToString());

1877 }

1878 catch (Exception ex)

1879 {

1880 InsertError(ex);

1881 }

1882 }

1883

1884 private void DeleteCache()

1885 {

1886 try

1887 {

1888 GSRDB1DataContext db = new GSRDB1DataContext();

1889

1890 var querySSMCached = from p in db.SSM_Caches

1891 where p.SessionID == Session.SessionID &&

1892 p.DepartmentID == DepartmentID &&

1893 p.JobNameID == JobNameID

1894 select p;

1895 StatusBar1.addNewLine(querySSMCached.Count().ToString());

1896

1897 db.SSM_Caches.DeleteAllOnSubmit(querySSMCached);

1898 db.SubmitChanges();

1899 }

1900 catch (Exception ex)

1901 {

1902 InsertError(ex);

1903 }

1904 }

1905

1906 //====================================================================================

1907 #endregion Process

1908

1909

1910 #region Grid Row Command

1911 //====================================================================================

1912

1913 protected void Grid_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)

1914 {

1915 StatusBar1.addNewLine("xx");

1916

1917 GridView gridview1 = (GridView)sender;

1918

1919 StatusBar1.addNewLine(e.CommandName + " " + e.CommandArgument + " " + e.CommandSource);

1920 GSRDB1DataContext db = new GSRDB1DataContext();

1921

1922 int JobNameID = Convert.ToInt32(ddlJobName.SelectedValue);

1923 int DepartmentID = Convert.ToInt32(ddlDepartment.SelectedValue);

1924

1925 int SkillSetID = Convert.ToInt32(TabContainer1.ActiveTab.ID);

1926 int MeasurementID = Convert.ToInt16(gridview1.Rows[Convert.ToInt32(e.CommandArgument)].Cells[2].Text);

1927

1928 StatusBar1.addNewLine(DepartmentID.ToString() + " " + JobNameID.ToString() + " " + SkillSetID.ToString() + " " + MeasurementID); ;

1929

1930

1931 KSSMCache oKSSMCache = new KSSMCache();

1932

1933 var query = oKSSMCache.Delete(DepartmentID, JobNameID, SkillSetID, MeasurementID);

1934

1935 StatusBar1.addNewLine("delete: " + query.Count().ToString());

1936 string JSScript = string.Format("<script>alert('{0}');window.location.reload();</script>", query.Count().ToString());

1937

1938 ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "temp", JSScript, false);

1939

1940 //StatusBar1.StatusContent = "Grid_RowCommand: " + e.CommandName + "<br/>";

1941

1942 // If multiple ButtonField column fields are used, use the

1943 // CommandName property to determine which button was clicked.

1944 //printDebug(false,"Row Command");

1945 //if (e.CommandName == "Select")

1946 //{

1947

1948 // // updateGrids();

1949 // GridView gridview1 = (GridView)sender;

1950

1951 // // Convert the row index stored in the CommandArgument

1952 // // property to an Integer.

1953 // int index = Convert.ToInt32(e.CommandArgument);

1954

1955 // // Get the last name of the selected author from the appropriate

1956 // // cell in the GridView control.

1957 // GridViewRow selectedRow = gridview1.Rows[index];

1958 // TableCell selectedCell = selectedRow.Cells[1];

1959 // string contact = selectedCell.Text;

1960

1961

1962 // string SectionName = selectedRow.Cells[SectionColumnNumber].Text;

1963 // string DepartmentName = selectedRow.Cells[DepartmentIDColumnNumber].Text;

1964

1965 // ddlDepartmentName.SelectedValue = DepartmentName;

1966

1967 // fillddlSectionName();

1968

1969 // ddlSectionName.SelectedValue = selectedRow.Cells[SectionIDColumnNumber].Text;

1970 //}

1971

1972 //StatusBar1.StatusContent += e.CommandName + "<br/>";

1973 }

1974 //Deletes Caching

1975 protected void Grid_RowDeleting(object sender, GridViewDeleteEventArgs e)

1976 {

1977 StatusBar1.StatusContent += "Grid_RowDeleting: " + e.RowIndex.ToString() + "<br/>";

1978

1979 try

1980 {

1981 GridView gridview1 = (GridView)sender;

1982

1983 int index = e.RowIndex;

1984 GSRDB1DataContext db = new GSRDB1DataContext();

1985

1986 int JobNameID = Convert.ToInt32(ddlJobName.SelectedValue);

1987 int DepartmentID = Convert.ToInt32(ddlDepartment.SelectedValue);

1988

1989 int SkillSetID = Convert.ToInt32(TabContainer1.ActiveTab.ID);

1990

1991 StatusBar1.addNewLine(DepartmentID.ToString() + " " + JobNameID.ToString() + " " + SkillSetID.ToString());

1992

1993

1994 //int MeasurementID = Convert.ToInt16(gridview1.Rows[index].Cells[3].Text);

1995

1996 //int PositionID = new KPosition().getPositionID(DepartmentID, JobNameID);

1997

1998 //if (PositionID != -1)

1999 //{

2000 // SSM_Cache oSSM = db.SSM_Caches.Single(o=>o.SkillSetID == SkillSetID && o.MeasurementID == MeasurementID);

2001

2002 // SkillSetMeasurement oSSM = db.SkillSetMeasurements.Single(p => p.PositionID == PositionID &&

2003 // p.SkillSetID == SkillSetID &&

2004 // p.MeasurementID == MeasurementID);

2005

2006 // StatusBar1.StatusContent += "Grid_RowDeleting: " + PositionID.ToString() + " "

2007 // + SkillSetID.ToString() + " " + MeasurementID.ToString() + " " + oSSM.ID.ToString() + "<br/>";

2008

2009 // db.SkillSetMeasurements.DeleteOnSubmit(oSSM);

2010 // db.SubmitChanges();

2011

2012 // updateGrids();

2013 // loadGridValues();

2014 //}

2015

2016 }

2017 catch (Exception ex)

2018 {

2019 InsertError(ex);

2020 StatusBar1.StatusContent += ex.Message;

2021 }

2022 }

2023

2024 protected void Grid_PageIndexChanging(object sender, GridViewPageEventArgs e)

2025 {

2026

2027 }

2028

2029 //====================================================================================

2030 #endregion

2031

2032

2033

2034 #region Button Events

2035 //====================================================================================

2036

2037 // bring all new

2038 protected void btnNew_Click(object sender, EventArgs e)

2039 {

2040 ddlDepartment.Visible = true;

2041 ddlJobName.Visible = true;

2042 //ddlPosition.Visible = false;

2043 //btnCreatePosition.Visible = true;

2044

2045 }

2046

2047 protected void btnQuery_Click(object sender, EventArgs e)

2048 {

2049

2050 }

2051

2052 protected void btnOkay_Click(object sender, EventArgs e)

2053 {

2054 //AlertTable.Visible = false;

2055 //ErrorMsgTable.Visible = false;

2056 }

2057

2058 protected void btnClear_Click(object sender, EventArgs e)

2059 {

2060 clearForm();

2061 }

2062

2063 protected void btnUpdate_Click(object sender, EventArgs e)

2064 {

2065 Button CurrentButton = (Button)sender;

2066

2067 switch (CurrentButton.CommandArgument)

2068 {

2069 case "complete":

2070 Complete();

2071 DeleteCache();

2072 break;

2073 case "update":

2074 Complete();

2075 break;

2076 case "ssm":

2077 break;

2078 }

2079

2080 //updateWeights();

2081 //System.Threading.Thread.Sleep(4000);

2082 //refreshForm();

2083 }

2084 // cache = ssm_cache , data = ssm, position, ect...

2085 protected void btnDelete_Click(object sender, EventArgs e)

2086 {

2087 switch (((Button)sender).CommandArgument)

2088 {

2089 case "cache":

2090 DeleteCache();

2091 break;

2092 case "data":

2093 break;

2094

2095 }

2096

2097 //refreshForm();

2098 }

2099

2100 protected void btnExit_Click(object sender, EventArgs e)

2101 {

2102 Response.Redirect("Default.aspx");

2103 }

2104

2105 protected void btnToggleButton_Click(object sender, EventArgs e)

2106 {

2107 Button CurrentButton = (Button)sender;

2108 switch (CurrentButton.CommandArgument)

2109 {

2110 case "MeasurementBulletedList":

2111 MeasurementBulletedList.Visible = true;

2112 MeasurementCheckBoxListRow.Visible = true;

2113 MeasurementTabRow.Visible = false;

2114 DescriptionRow.Style.Add("display", "none");

2115 QualificationRow.Style.Add("display", "none");

2116 SSMCacheButtonRow.Style.Add("display", "block");

2117 break;

2118 case "MeasurementTabRow":

2119 MeasurementBulletedList.Visible = false;

2120 MeasurementCheckBoxListRow.Visible = false;

2121 MeasurementTabRow.Visible = true;

2122 DescriptionRow.Style.Add("display", "block");

2123 QualificationRow.Style.Add("display", "block");

2124 SSMCacheButtonRow.Style.Add("display", "none");

2125 break;

2126 }

2127 }

2128

2129 protected void btnTruncateSSMCache_Click(object sender, EventArgs e)

2130 {

2131 TruncateSSMCache();

2132 }

2133

2134 //====================================================================================

2135 #endregion Button Events

2136

2137

2138 private void InsertError(Exception ex)

2139 {

2140 WebErrorReport oWebErrorReport = new WebErrorReport();

2141 //oWebErrorReport.InsertError(ex, Request.Url.ToString(), Request.ServerVariables["REMOTE_ADDR"]);

2142 StatusBar1.addNewLine(ex.Message + " " + ex.StackTrace.ToString());

2143 }

2144

2145 [System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]

2146 public static string GetDynamicContent(string contextKey)

2147 {

2148 return default(string);

2149 }

2150 }

2151

2152

2153

2154

TechnoArkay

Saturday, January 31, 2009

CopySourceAsHTML Visual Studio Addins

About Me

Search This Blog

Labels

Blog Archive