public ucTimeslip()
{
InitializeComponent();
TSdt = tsData.TimeSlip;
SRPClientDt = tsData.SRPClient;
}
internal appDB.SRPClientDataTable SetSRPClientHours(appDB.SRPClientDataTable dt)
{
fixingHours = true;
foreach (appDB.SRPClientRow dr in dt)
{
dr.Minutes = dr.Minutes / 60;
dr.AcceptChanges();
}
fixingHours = false;
return(dt);
}
public appDB.SRPClientDataTable LoadSRPClientBySRPID(int srpId)
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
this.sqlSelect.CommandText = "[SRPClientBySRPID]";
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SRPID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters["@SRPID"].Value = srpId;
appDB.SRPClientDataTable dt = new appDB.SRPClientDataTable();
Fill(dt);
return(dt);
}
public appDB.SRPClientDataTable LoadSRPClientByOfficerId(int SRPID, int officerId, DateTime startDate, DateTime endDate)
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
this.sqlSelect.CommandText = "[SRPCLientByOfficerID]";
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SRPID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OfficerId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@startdate", System.Data.SqlDbType.SmallDateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@enddate", System.Data.SqlDbType.SmallDateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters["@SRPID"].Value = SRPID;
this.sqlSelect.Parameters["@OfficerId"].Value = officerId;
this.sqlSelect.Parameters["@startdate"].Value = startDate;
this.sqlSelect.Parameters["@enddate"].Value = endDate;
appDB.SRPClientDataTable dt = new appDB.SRPClientDataTable();
Fill(dt);
return(dt);
}
/// <summary>
/// SRP Client for closed period
/// </summary>
/// <param name="SRPId"></param>
private void LoadSrpClient(int SRPId) // closed period
{
appDB.SRPClientDataTable SrpClient2Merge = new appDB.SRPClientDataTable();
SrpClient2Merge = (appDB.SRPClientDataTable)FM.GetActivityTime().LoadSRPClientBySRPID(CurrentRowSRP().SRPID);
SRPClientDt.Merge(SrpClient2Merge);
}
/// <summary>
/// SRP Client for open period
/// </summary>
/// <param name="officerId"></param>
/// <param name="SRPId"></param>
/// <param name="srpStart"></param>
/// <param name="srpEnd"></param>
private void LoadSrpClient(int officerId, int SRPId, DateTime srpStart, DateTime srpEnd) //open period
{
appDB.SRPClientDataTable SrpClient2Merge = new appDB.SRPClientDataTable();
SrpClient2Merge = (appDB.SRPClientDataTable)FM.GetActivityTime().LoadSRPClientByOfficerId(SRPId, officerId, srpStart, srpEnd);
SRPClientDt.Merge(SrpClient2Merge);
}
