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("TimeCardLocationMapID"); if (c.Checked) { ETimeCardLocationMap obj = new ETimeCardLocationMap(); obj.TimeCardLocationMapID = Int32.Parse(h.Value); list.Add(obj); } } foreach (ETimeCardLocationMap obj in list) { if (ETimeCardLocationMap.db.select(dbConn, obj)) { //WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, obj); //WebUtils.EndFunction(dbConn); } } view = loadData(info, db, Repeater); }
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e) { HROne.Common.WebUtility.WebControlsLocalization(Session, e.Item.Controls); e.Item.FindControl("DeleteItem").Visible = IsAllowEdit; if (e.Item.ItemIndex == Repeater.EditItemIndex) { ebinding = new Binding(dbConn, db); ebinding.add((HtmlInputHidden)e.Item.FindControl("TimeCardLocationMapID")); ebinding.add((TextBox)e.Item.FindControl("TimeCardLocationMapOriginalCode")); ebinding.add((TextBox)e.Item.FindControl("TimeCardLocationMapNewCode")); ebinding.init(Request, Session); ETimeCardLocationMap obj = new ETimeCardLocationMap(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); Hashtable values = new Hashtable(); db.populate(obj, values); ebinding.toControl(values); } else { e.Item.FindControl("Edit").Visible = IsAllowEdit; HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("TimeCardLocationMapID"); h.Value = ((DataRowView)e.Item.DataItem)["TimeCardLocationMapID"].ToString(); } }
protected void Repeater_ItemCommand(object source, DataListCommandEventArgs e) { Button b = (Button)e.CommandSource; if (b.ID.Equals("Edit")) { Repeater.EditItemIndex = e.Item.ItemIndex; view = loadData(info, db, Repeater); WebUtils.SetEnabledControlSection(AddPanel, false); } else if (b.ID.Equals("Cancel")) { Repeater.EditItemIndex = -1; view = loadData(info, db, Repeater); WebUtils.SetEnabledControlSection(AddPanel, true); } else if (b.ID.Equals("Save")) { ebinding = new Binding(dbConn, db); ebinding.add((HtmlInputHidden)e.Item.FindControl("TimeCardLocationMapID")); ebinding.add((TextBox)e.Item.FindControl("TimeCardLocationMapOriginalCode")); ebinding.add((TextBox)e.Item.FindControl("TimeCardLocationMapNewCode")); ebinding.init(Request, Session); ETimeCardLocationMap obj = new ETimeCardLocationMap(); 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 (!AppUtils.checkDuplicate(dbConn, db, obj, errors, "TimeCardLocationMapOriginalCode")) { return; } //WebUtils.StartFunction(Session, FUNCTION_CODE); db.update(dbConn, obj); //WebUtils.EndFunction(dbConn); Repeater.EditItemIndex = -1; view = loadData(info, db, Repeater); WebUtils.SetEnabledControlSection(AddPanel, true); } }
protected void Add_Click(object sender, EventArgs e) { Repeater.EditItemIndex = -1; ETimeCardLocationMap c = new ETimeCardLocationMap(); Hashtable values = new Hashtable(); binding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); if (!AppUtils.checkDuplicate(dbConn, db, c, errors, "TimeCardLocationMapOriginalCode")) { return; } //WebUtils.StartFunction(Session, FUNCTION_CODE); db.insert(dbConn, c); //WebUtils.EndFunction(dbConn); TimeCardLocationMapOriginalCode.Text = string.Empty; TimeCardLocationMapNewCode.Text = string.Empty; view = loadData(info, db, Repeater); }
public override DataTable UploadToTempDatabase(string Filename, int UserID, string ZipPassword) { ClearTempTable(); DataTable rawDataTable; if (Filename.EndsWith(".xls")) { rawDataTable = HROne.Import.ExcelImport.parse(Filename, ZipPassword).Tables[0]; // Force override setting for excel format DateSeparator = "-"; TimeSeparator = ":"; DateSequence = "YMD"; TimeSequence = "Hms"; YearFormat = "YYYY"; } else { System.IO.FileStream reader = System.IO.File.OpenRead(Filename); rawDataTable = CSVReader.parse(reader, UploadFileHasHeader, ColumnDelimiter, "\""); reader.Close(); } if (rawDataTable != null) { foreach (DataRow row in rawDataTable.Rows) { EUploadTimeCardRecord uploadTimeCardRecord = new EUploadTimeCardRecord(); EUploadTimeCardRecord uploadTimeCardRecord2 = null; if (rawDataTable.Columns.Contains("SourceString")) { uploadTimeCardRecord.TimeCardRecordOriginalData = row["SourceString"].ToString(); } else { foreach (object value in row.ItemArray) { string stringValue = string.Empty; if (value != null) { stringValue = value.ToString(); } if (string.IsNullOrEmpty(uploadTimeCardRecord.TimeCardRecordOriginalData)) { uploadTimeCardRecord.TimeCardRecordOriginalData = stringValue; } else { uploadTimeCardRecord.TimeCardRecordOriginalData += "," + stringValue; } } } if (rawDataTable.Columns.Count >= TimeCardNumColumnIndex) { uploadTimeCardRecord.TimeCardRecordCardNo = row[TimeCardNumColumnIndex - 1].ToString().Trim(); } else { errors.addError("Time Card column not found", null); } if (rawDataTable.Columns.Count >= DateColumnIndex && rawDataTable.Columns.Count >= TimeColumnIndex) { try { uploadTimeCardRecord.TimeCardRecordDateTime = getDateTime(row, DateColumnIndex, TimeColumnIndex); } catch (Exception) { // add empty datetime to skip import uploadTimeCardRecord.TimeCardRecordDateTime = new DateTime(); //errors.addError(ex.Message, null); } } else { errors.addError("Date/Time column not found", null); } if (DateColumnIndex2 > 0 && TimeColumnIndex2 > 0) { if (rawDataTable.Columns.Count >= DateColumnIndex2 && rawDataTable.Columns.Count >= TimeColumnIndex2) { uploadTimeCardRecord2 = new EUploadTimeCardRecord(); try { uploadTimeCardRecord2.TimeCardRecordDateTime = getDateTime(row, DateColumnIndex2, TimeColumnIndex2); } catch (Exception) { // add empty datetime to skip import uploadTimeCardRecord2.TimeCardRecordDateTime = new DateTime(); //errors.addError(ex.Message, null); } } else { errors.addError("2nd Date/Time column not found", null); } } if (rawDataTable.Columns.Count >= LocationColumnIndex) { uploadTimeCardRecord.TimeCardRecordLocation = ETimeCardLocationMap.ConvertToNewLocationCode(dbConn, row[LocationColumnIndex - 1].ToString()); } else { errors.addError("Location column not found", null); } uploadTimeCardRecord.TimeCardRecordInOutIndex = ETimeCardRecord.TimeCardRecordInOutIndexEnum.Unspecify; //unspecify uploadTimeCardRecord.EmpID = Import.Parse.GetEmpIDFromCardNo(uploadTimeCardRecord.TimeCardRecordCardNo); if (errors.List.Count > 0) { throw new HRImportException(errors.Message()); } if (uploadTimeCardRecord.TimeCardRecordOriginalData.Length <= 450) { // Compare previous import record only when length <=450 DBFilter timeCardRecordFilter = new DBFilter(); timeCardRecordFilter.add(new Match("TimeCardRecordOriginalData", uploadTimeCardRecord.TimeCardRecordOriginalData)); ArrayList list = ETimeCardRecord.db.select(dbConn, timeCardRecordFilter); if (list.Count > 0) { uploadTimeCardRecord.TimeCardRecordID = ((ETimeCardRecord)list[0]).TimeCardRecordID; uploadTimeCardRecord.ImportActionStatus = ImportDBObject.ImportActionEnum.UPDATE; } else { uploadTimeCardRecord.ImportActionStatus = ImportDBObject.ImportActionEnum.INSERT; } } else { // Up to 450 character is stored for original data uploadTimeCardRecord.TimeCardRecordOriginalData = uploadTimeCardRecord.TimeCardRecordOriginalData.Substring(0, 450); uploadTimeCardRecord.ImportActionStatus = ImportDBObject.ImportActionEnum.INSERT; } uploadTimeCardRecord.SessionID = m_SessionID; uploadTimeCardRecord.TransactionDate = AppUtils.ServerDateTime(); if (!uploadTimeCardRecord.TimeCardRecordDateTime.Ticks.Equals(0)) { EUploadTimeCardRecord.db.insert(dbConn, uploadTimeCardRecord); } if (uploadTimeCardRecord2 != null) { uploadTimeCardRecord2.EmpID = uploadTimeCardRecord.EmpID; uploadTimeCardRecord2.TimeCardRecordCardNo = uploadTimeCardRecord.TimeCardRecordCardNo; uploadTimeCardRecord2.TimeCardRecordInOutIndex = uploadTimeCardRecord.TimeCardRecordInOutIndex; uploadTimeCardRecord2.TimeCardRecordLocation = uploadTimeCardRecord.TimeCardRecordLocation; uploadTimeCardRecord2.TimeCardRecordOriginalData = uploadTimeCardRecord.TimeCardRecordOriginalData + ":idx2"; uploadTimeCardRecord2.SessionID = uploadTimeCardRecord.SessionID; uploadTimeCardRecord2.TransactionDate = uploadTimeCardRecord.TransactionDate; if (uploadTimeCardRecord2.TimeCardRecordOriginalData.Length <= 450) { // Compare previous import record only when length <=450 DBFilter timeCardRecordFilter = new DBFilter(); timeCardRecordFilter.add(new Match("TimeCardRecordOriginalData", uploadTimeCardRecord2.TimeCardRecordOriginalData)); ArrayList list = ETimeCardRecord.db.select(dbConn, timeCardRecordFilter); if (list.Count > 0) { uploadTimeCardRecord2.TimeCardRecordID = ((ETimeCardRecord)list[0]).TimeCardRecordID; uploadTimeCardRecord2.ImportActionStatus = ImportDBObject.ImportActionEnum.UPDATE; } else { uploadTimeCardRecord2.ImportActionStatus = ImportDBObject.ImportActionEnum.INSERT; } } else { // Up to 450 character is stored for original data uploadTimeCardRecord2.TimeCardRecordOriginalData = uploadTimeCardRecord.TimeCardRecordOriginalData.Substring(0, 450); uploadTimeCardRecord2.ImportActionStatus = ImportDBObject.ImportActionEnum.INSERT; } if (!uploadTimeCardRecord2.TimeCardRecordDateTime.Ticks.Equals(0)) { EUploadTimeCardRecord.db.insert(dbConn, uploadTimeCardRecord2); } } } } return(GetImportDataFromTempDatabase(null)); }