private void sprPay_ButtonClicked(object eventSender, Stubs._FarPoint.Win.Spread.EditorNotifyEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
//int ButtonDown = 0;
//Display and Fill lstLog with SignOff log entries
//For Selected Date
DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand();
string ListStr = "";
ViewModel.sprPay.Row = Row + 10;
ViewModel.sprPay.Col = Col + 1;
int SignOff1 = Convert.ToInt32(Conversion.Val(ViewModel.sprPay.Text));
ViewModel.sprPay.Row = Row + 11;
int SignOff2 = Convert.ToInt32(Conversion.Val(ViewModel.sprPay.Text));
ViewModel.sprPay.Row = Row + 12;
int SignOff3 = Convert.ToInt32(Conversion.Val(ViewModel.sprPay.Text));
oCmd.Connection = modGlobal.oConn;
oCmd.CommandType = CommandType.Text;
oCmd.CommandText = "sp_GetSignLog " + SignOff1.ToString() + "," + SignOff2.ToString() + "," + SignOff3.ToString();
ADORecordSetHelper oRec = ADORecordSetHelper.Open(oCmd, "");
ViewModel.lstLog.Items.Clear();
while (!oRec.EOF)
{
ListStr = Convert.ToDateTime(oRec["activity_date"]).ToString("M/d/yyyy HH:mm");
if (Convert.ToString(oRec["battalion_code"]).Trim() == "1")
{
ListStr = ListStr + " Batt 1 - ";
}
else if (Convert.ToString(oRec["battalion_code"]).Trim() == "2")
{
ListStr = ListStr + " Batt 2 - ";
}
else
{
ListStr = ListStr + " Batt 3 - ";
}
if (Convert.ToDouble(oRec["log_description_code"]) == 1)
{
ListStr = ListStr + " LOCKED ";
}
else
{
ListStr = ListStr + " UNLOCKED ";
}
ListStr = ListStr + modGlobal.Clean(oRec["name_last"]).Trim();
ViewModel.lstLog.AddItem(ListStr);
oRec.MoveNext();
}
;
}
private void sprReport_ButtonClicked(object eventSender, Stubs._FarPoint.Win.Spread.EditorNotifyEventArgs eventArgs)
{
int Col = eventArgs.Column;
int Row = eventArgs.Row;
int ButtonDown = 0;
PTSProject.clsScheduler cSched = Container.Resolve <clsScheduler>();
//string sEmpID = "";
//string sDate = "";
//do not continue if in the middle of filling the grid
if (ViewModel.FillingTheGrid)
{
return;
}
//if col = 1 wasn't clicked... no use continuing
if (Col != 1)
{
return;
}
ViewModel.CurrRow = Row;
ViewModel.sprReport.Row = ViewModel.CurrRow;
ViewModel.sprReport.Col = 6;
cSched.WatchDutyAssignEmpID = modGlobal.Clean(ViewModel.sprReport.Text);
cSched.WatchDutyAssignDutyDate = DateTime.Parse(ViewModel.dtReportDate.Text).ToString("MM/dd/yyyy");
cSched.WatchDutyAssignedBy = modGlobal.Shared.gUser;
cSched.WatchDutyAssignedDate = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
if (ButtonDown != 0)
{ //Checkbox = True
ViewModel.sprReport.Col = 7;
if (modGlobal.Clean(ViewModel.sprReport.Text) == "")
{
//Need to Add PersonnelWatchDutyAssignment Record for Employee/Date
if (cSched.AddWatchDutyAssignmentRecord())
{
ViewModel.UpdateJustHappened = true;
ViewModel.sprReport.Col = 7;
ViewModel.sprReport.Row = ViewModel.CurrRow;
ViewModel.sprReport.Text = cSched.WatchDutyAssignDutyID.ToString();
}
else
{
ViewManager.ShowMessage("Oooops! Something went wrong... record not inserted.", "Add New Record", UpgradeHelpers.Helpers.BoxButtons.OK);
return;
}
}
}
else
{
//Checkbox = False
if (ViewModel.UpdateJustHappened)
{
ViewModel.UpdateJustHappened = false;
return;
}
else
{
//delete the PersonnelWatchDutyAssignment by RecordID
ViewModel.sprReport.Col = 7;
cSched.WatchDutyAssignDutyID = Convert.ToInt32(Double.Parse(ViewModel.sprReport.Text));
if (Convert.ToInt32(Double.Parse(ViewModel.sprReport.Text)) != 0)
{
if (cSched.DeleteWatchDutyAssignmentRecord() != 0)
{
ViewModel.UpdateJustHappened = true;
FillGrid();
}
}
}
}
ViewModel.UpdateJustHappened = false;
}
