public int DTR_ForceUpdate(DTRForceUpdateModel log)
{
try
{
using (var con = GetDbConnection())
{
var retValue = con.ExecuteScalar <int>("dbo.Usp_DTR_ForceUpdate",
new
{
@iIntLogId = log.LogId,
@iIntEmployeeId = log.EmployeeId,
@iDtCurrentDate = log.CurrentDate,
@iTmTimeIn_AM = log.TimeIn_AM == TimeSpan.Zero ? null : log.TimeIn_AM,
@iTmTimeOut_AM = log.TimeOut_AM == TimeSpan.Zero ? null : log.TimeOut_AM,
@iTmTimeIn_PM = log.TimeIn_PM == TimeSpan.Zero ? null : log.TimeIn_PM,
@iTmTimeOut_PM = log.TimeOut_PM == TimeSpan.Zero ? null : log.TimeOut_PM,
@iTmTimeIn_Evening = log.TimeIn_Evening == TimeSpan.Zero ? null : log.TimeIn_Evening,
@iTmTimeOut_Evening = log.TimeOut_Evening == TimeSpan.Zero ? null : log.TimeOut_Evening,
}, commandType: CommandType.StoredProcedure);
return(retValue);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void bttnSave_Click(object sender, EventArgs e)
{
if (!chkTimeInAM.Checked && dtTimeInAM.Text.Trim() == "12:00 AM")
{
MessageBox.Show("Invalid AM Time-in data. Pleae cheeck.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dtTimeInAM.Focus();
return;
}
else if (!chkTimeOutAM.Checked && dtTimeOutAM.Text.Trim() == "12:00 AM")
{
MessageBox.Show("Invalid AM Time-out data. Pleae cheeck.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dtTimeOutAM.Focus();
return;
}
else if (!chkTimeInPM.Checked && dtTimeInPM.Text.Trim() == "12:00 AM")
{
MessageBox.Show("Invalid PM Time-in data. Pleae cheeck.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dtTimeInPM.Focus();
return;
}
else if (!chkTimeOutPM.Checked && dtTimeOutPM.Text.Trim() == "12:00 AM")
{
MessageBox.Show("Invalid PM Time-out data. Pleae cheeck.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dtTimeOutPM.Focus();
return;
}
else if (!chkTimeInEvening.Checked && dtTimeInEvening.Text.Trim() == "12:00 AM")
{
MessageBox.Show("Invalid Evening Time-in data. Pleae cheeck.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dtTimeInEvening.Focus();
return;
}
else if (!chkTimeOutEvening.Checked && dtTimeOutEvening.Text.Trim() == "12:00 AM")
{
MessageBox.Show("Invalid Evening Time-out data. Pleae cheeck.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dtTimeOutEvening.Focus();
return;
}
//else if (!chkTimeInAM.Checked && !chkTimeOutAM.Checked && !chkTimeInPM.Checked && !chkTimeOutPM.Checked && !chkTimeInEvening.Checked && !chkTimeOutEvening.Checked)
//{
// MessageBox.Show("Invalid Time-in/Time-out data. Pleae cheeck.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
else
{
var log = new DTRForceUpdateModel
{
LogId = logId,
EmployeeId = employeeId,
CurrentDate = currDate,
TimeIn_AM = chkTimeInAM.Checked ? TimeSpan.Zero : dtTimeInAM.Value.TimeOfDay,
TimeOut_AM = chkTimeOutAM.Checked ? TimeSpan.Zero : dtTimeOutAM.Value.TimeOfDay,
TimeIn_PM = chkTimeInPM.Checked ? TimeSpan.Zero : dtTimeInPM.Value.TimeOfDay,
TimeOut_PM = chkTimeOutPM.Checked ? TimeSpan.Zero : dtTimeOutPM.Value.TimeOfDay,
TimeIn_Evening = chkTimeInEvening.Checked ? TimeSpan.Zero : dtTimeInEvening.Value.TimeOfDay,
TimeOut_Evening = chkTimeOutEvening.Checked ? TimeSpan.Zero : dtTimeOutEvening.Value.TimeOfDay,
UserId = GlobalSession.UserId
};
int result = dtr.DTR_ForceUpdate(log);
switch (result)
{
case 1:
case 2:
ShowMessage.ShowMessageBox(2);
break;
case -1:
ShowMessage.CustomErrorMessage("Semester has not been set-up.");
break;
case -2:
ShowMessage.CustomErrorMessage("No morning shift for this employee.");
break;
case -3:
ShowMessage.CustomErrorMessage("No afternoon shift for this employee.");
break;
case -4:
ShowMessage.CustomErrorMessage("No evening shift for this employee.");
break;
case 0:
ShowMessage.CustomErrorMessage("Something went wrong.");
break;
}
this.Close();
}
}
public int DTR_ForceUpdate(DTRForceUpdateModel log)
{
return(_repo.DTR_ForceUpdate(log));
}
