protected void Delete_Click(object sender, EventArgs e) { ArrayList list = new ArrayList(); foreach (DataListItem item in Repeater.Items) { CheckBox c = (CheckBox)item.FindControl("DeleteItem"); HtmlInputHidden h = (HtmlInputHidden)item.FindControl("EmpWorkingSummaryID"); if (c.Checked) { EEmpWorkingSummary obj = new EEmpWorkingSummary(); obj.EmpWorkingSummaryID = Int32.Parse(h.Value); list.Add(obj); } } WebUtils.StartFunction(Session, FUNCTION_CODE, CurID); foreach (EEmpWorkingSummary obj in list) { if (db.select(dbConn, obj)) { db.delete(dbConn, obj); } } WebUtils.EndFunction(dbConn); loadData(info, db, Repeater); }
public override void ImportToDatabase() { DataTable dataTable = GetImportDataFromTempDatabase(null); if (dataTable.Rows.Count > 0) { foreach (DataRow row in dataTable.Rows) { EUploadEmpWorkingSummary obj = new EUploadEmpWorkingSummary(); tempDB.toObject(row, obj); EEmpWorkingSummary empWorkingSummary; DBFilter dbFilter = new DBFilter(); dbFilter.add(new Match("EmpID", obj.EmpID)); dbFilter.add(new Match("EmpWorkingSummaryAsOfDate", obj.EmpWorkingSummaryAsOfDate)); ArrayList empWorkingSummaryList = EEmpWorkingSummary.db.select(dbConn, dbFilter); if (empWorkingSummaryList.Count > 0) { empWorkingSummary = (EEmpWorkingSummary)empWorkingSummaryList[0]; } else { empWorkingSummary = new EEmpWorkingSummary(); } empWorkingSummary.EmpID = obj.EmpID; empWorkingSummary.EmpWorkingSummaryAsOfDate = obj.EmpWorkingSummaryAsOfDate; empWorkingSummary.EmpWorkingSummaryRestDayEntitled = obj.EmpWorkingSummaryRestDayEntitled; empWorkingSummary.EmpWorkingSummaryRestDayTaken = obj.EmpWorkingSummaryRestDayTaken; empWorkingSummary.EmpWorkingSummaryTotalWorkingDays = obj.EmpWorkingSummaryTotalWorkingDays; empWorkingSummary.EmpWorkingSummaryTotalWorkingHours = obj.EmpWorkingSummaryTotalWorkingHours; empWorkingSummary.EmpWorkingSummaryTotalLunchTimeHours = obj.EmpWorkingSummaryTotalLunchTimeHours; if (empWorkingSummary.EmpWorkingSummaryID > 0) { EEmpWorkingSummary.db.update(dbConn, empWorkingSummary); } else { EEmpWorkingSummary.db.insert(dbConn, empWorkingSummary); } tempDB.delete(dbConn, obj); } } }
protected void Add_Click(object sender, EventArgs e) { Repeater.EditItemIndex = -1; EEmpWorkingSummary c = new EEmpWorkingSummary(); Hashtable values = new Hashtable(); newBinding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); if (!errors.isEmpty()) { return; } WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID); db.insert(dbConn, c); WebUtils.EndFunction(dbConn); EmpWorkingSummaryAsOfDate.Value = string.Empty; EmpWorkingSummaryRestDayEntitled.Text = string.Empty; EmpWorkingSummaryRestDayTaken.Text = string.Empty; EmpWorkingSummaryTotalWorkingDays.Text = string.Empty; EmpWorkingSummaryTotalWorkingHours.Text = string.Empty; EmpWorkingSummaryTotalLunchTimeHours.Text = string.Empty; loadData(info, db, Repeater); }
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e) { Binding ebinding; EEmpWorkingSummary obj = new EEmpWorkingSummary(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); if (e.Item.ItemIndex == Repeater.EditItemIndex) { ebinding = new Binding(dbConn, db); ebinding.add(new TextBoxBinder(db, ((WebDatePicker)e.Item.FindControl("EmpWorkingSummaryAsOfDate")).TextBox, "EmpWorkingSummaryAsOfDate")); ebinding.add((HtmlInputHidden)e.Item.FindControl("EmpWorkingSummaryID")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryRestDayEntitled")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryRestDayTaken")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryTotalWorkingDays")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryTotalWorkingHours")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryTotalLunchTimeHours")); ebinding.init(Request, Session); Hashtable values = new Hashtable(); db.populate(obj, values); ebinding.toControl(values); } else { ((Button)e.Item.FindControl("Edit")).Visible = IsAllowEdit; ((CheckBox)e.Item.FindControl("DeleteItem")).Visible = IsAllowEdit; HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("EmpWorkingSummaryID"); h.Value = ((DataRowView)e.Item.DataItem)["EmpWorkingSummaryID"].ToString(); } HROne.Common.WebUtility.WebControlsLocalization(this, e.Item.Controls); }
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e) { EEmpWorkingSummary obj = new EEmpWorkingSummary(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); if (e.Item.ItemIndex == Repeater.EditItemIndex) { //ebinding = new Binding(dbConn, db); //ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryAsOfDate")); //ebinding.add((TextBox)e.Item.FindControl("CNDAmount")); //ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryRestDayEntitled")); //DBFilter filter = new DBFilter(); //filter.add(new Match("EmpID", obj.EmpID)); //ebinding.add(new DropDownVLBinder(db, (DropDownList)e.Item.FindControl("EmpAccID"), EEmpBankAccount.VLBankAccount, filter)); //ebinding.init(Request, Session); //Hashtable values = new Hashtable(); //db.populate(obj, values); //ebinding.toControl(values); } else { //((Button)e.Item.FindControl("Edit")).Visible = IsAllowEdit; //if (obj.PayRecID != null) //{ // ((Button)e.Item.FindControl("Edit")).Visible = false; // ((CheckBox)e.Item.FindControl("DeleteItem")).Visible = false; //} //HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("UploadWorkingEmpSummaryID"); //h.Value = ((DataRowView)e.Item.DataItem)["UploadWorkingEmpSummaryID"].ToString(); } }
protected void Repeater_ItemCommand(object source, DataListCommandEventArgs e) { Button b = (Button)e.CommandSource; if (b.ID.Equals("Edit")) { Repeater.EditItemIndex = e.Item.ItemIndex; //WorkingSummaryAddPanel.Visible = false; loadData(info, db, Repeater); WebUtils.SetEnabledControlSection(WorkingSummaryAddPanel, false); } else if (b.ID.Equals("Cancel")) { Repeater.EditItemIndex = -1; //WorkingSummaryAddPanel.Visible = IsAllowEdit; loadData(info, db, Repeater); WebUtils.SetEnabledControlSection(WorkingSummaryAddPanel, true); } else if (b.ID.Equals("Save")) { Binding ebinding; ebinding = new Binding(dbConn, db); ebinding.add(EmpID); ebinding.add(new TextBoxBinder(db, ((WebDatePicker)e.Item.FindControl("EmpWorkingSummaryAsOfDate")).TextBox, "EmpWorkingSummaryAsOfDate")); ebinding.add((HtmlInputHidden)e.Item.FindControl("EmpWorkingSummaryID")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryRestDayEntitled")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryRestDayTaken")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryTotalWorkingDays")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryTotalWorkingHours")); ebinding.add((TextBox)e.Item.FindControl("EmpWorkingSummaryTotalLunchTimeHours")); ebinding.init(Request, Session); EEmpWorkingSummary obj = new EEmpWorkingSummary(); Hashtable values = new Hashtable(); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); ebinding.toValues(values); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, obj); if (!errors.isEmpty()) { return; } WebUtils.StartFunction(Session, FUNCTION_CODE, obj.EmpID); db.update(dbConn, obj); WebUtils.EndFunction(dbConn); Repeater.EditItemIndex = -1; //WorkingSummaryAddPanel.Visible = IsAllowEdit; loadData(info, db, Repeater); WebUtils.SetEnabledControlSection(WorkingSummaryAddPanel, true); } }