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