public List <OfficialShift> Get(string mahrozet)
{
string [] arr = mahrozet.Split('|');
int Unitid = Convert.ToInt32(arr[2]);
OfficialShift OS = new OfficialShift();
return(OS.GetEmptyOfficial(Unitid, arr[0], arr[1]));
}
public void PutCheckHours([FromBody] OfficialShift o, string idbefore)
{
o.PutMish(idbefore);
}
// PUT api/<controller>/5
public void Put([FromBody] OfficialShift OS)
{
OS.UpdateOfficialShift();
}
public bool Post([FromBody] OfficialShift o)
{
return(o.CheckLongBreak());
}
// POST api/<controller>
public void Post([FromBody] List <OfficialShift> OffShiftArr)
{
OfficialShift OS = new OfficialShift();
OS.InsertOffShift(OffShiftArr);
}
public List <OfficialShift> GeAllunits(int unit, string id)
{
OfficialShift OS = new OfficialShift();
return(OS.getShiftFromAllOrgan(unit, id));
}
public List <OfficialShift> GetWorkSchdual(int unit)
{
OfficialShift OS = new OfficialShift();
return(OS.GetWorkSchdual(unit));
}
public List <OfficialShift> Get(DateTime start, DateTime end, int unit)
{
OfficialShift OS = new OfficialShift();
return(OS.GetallShifts(start, end, unit));
}
public List <OfficialShift> Get(int Unitid)
{
OfficialShift OS = new OfficialShift();
return(OS.GetOS(Unitid));
}
public User GuideInfo(string Userid, bool preprdness)
{
User Os = new User();
double extra = 0;
double normal = 0;
SqlConnection con = null;
List <Constraint> ConstList = getConstraintM();
float RegularShift = ConstList[6].ConstraintValue;
float SpeNightShift = ConstList[7].ConstraintValue;
try
{
string sMonth = DateTime.Now.ToString("MM");
string year = DateTime.Today.Year.ToString();
con = connect("DBConnectionString");
String selectSTR = "select * from OfficialShift_2020 where UserId = " + Userid + " and ShiftDate > '" + year + "-" + sMonth + "-" + "01'";
SqlCommand cmd = new SqlCommand(selectSTR, con);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
OfficialShift OffiS = new OfficialShift();
OffiS.Shifttype = (string)dr["ShiftType"];
TimeSpan myTimeSpan = ((dr).GetTimeSpan(dr.GetOrdinal("StartShift")));
OffiS.Startshifthour = new DateTime(myTimeSpan.Ticks);
myTimeSpan = ((dr).GetTimeSpan(dr.GetOrdinal("EndShift")));
OffiS.Endshifthour = new DateTime(myTimeSpan.Ticks);
TimeSpan interval = OffiS.Endshifthour - OffiS.Startshifthour;
double x = interval.TotalHours;
if (preprdness == true && OffiS.Shifttype == "לילה")
{
double x1 = 0.0;
if (x < 0)
{
x1 = x + 24.0;
}
else if (x > 0)
{
x1 = x;
}
if (x1 > SpeNightShift)
{
normal += SpeNightShift;
extra += x1 - SpeNightShift;
}
else
{
normal += x1;
extra += 0.0;
}
}
else
{
if (x > RegularShift)
{
normal += RegularShift;
extra += x - RegularShift;
}
else
{
normal += x;
extra += 0.0;
}
}
Os.MonthlyHours = normal;
Os.MonthlyExtraHours = extra;
}
return(Os);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
