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));
}
