public static int updatealerts()
{
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
int r = bus.fetchalerts();
return(r);
}
public static int updatealerts2()
{
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
int r2 = bus.fetchalerts_cancel();
return(r2);
}
public static int updatealerts1(int userid)
{
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.userid = userid;
int r1 = bus.fetchalerts_user();
return(r1);
}
public static int checkusername(string uname)
{
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.user_name = uname;
int ru = bus.checkusername();
return(ru);
}
public static int checkemail(string email)
{
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.email = email;
int re = bus.checkemail();
return(re);
}
public static int checkusername_edit(string uname, int editid)
{
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.id = editid;
bus.user_name = uname;
int ru = bus.checkusername_edit();
return(ru);
}
public static int email_edit_check(string email, int editid)
{
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.id = editid;
bus.email = email;
int re = bus.checkemail_edit();
return(re);
}
public static int in_out_others(int userid, int typ, int per, string ds)
{
bus_eleave_ugc1 bus2 = new bus_eleave_ugc1();
bus2.userid = userid;
bus2.ltype = typ;
bus2.rdays = getc(per, ds);
int res1 = bus2.check_in_out();
return(res1);
}
public static List <Event> disdates()
{
List <Event> dates = new List <Event>();
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
DataTable dt = bus.fetchdisdates();
for (int i = 0; i < dt.Rows.Count; i++)
{
Event _holiday = new Event();
_holiday.EventDate = dt.Rows[i]["dates"].ToString();
dates.Add(_holiday);
}
return(dates);
}
public static List <Desi> filldesi(int dep)
{
List <Desi> des = new List <Desi>();
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.id = dep;
DataTable dt = bus.fetchdesignation();
for (int i = 0; i < dt.Rows.Count; i++)
{
Desi _Desi = new Desi();
_Desi.dsg_id = int.Parse(dt.Rows[i]["dsg_id"].ToString());
_Desi.designation = dt.Rows[i]["designation"].ToString();
des.Add(_Desi);
}
return(des);
}
public static List <grade> fillgrade(int grade)
{
List <grade> grd = new List <grade>();
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.id = grade;
DataTable dt = bus.fetchgrade();
for (int i = 0; i < dt.Rows.Count; i++)
{
grade _grade = new grade();
_grade.grade_id = int.Parse(dt.Rows[i]["grade_id"].ToString());
_grade.grade_desc = dt.Rows[i]["grade_desc"].ToString();
_grade.category = dt.Rows[i]["category"].ToString();
grd.Add(_grade);
}
return(grd);
}
public static List <Event> GetEvents_calendar(int rid)
{
List <Event> events = new List <Event>();
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.id = rid;
DataTable dt = bus.fetch_holidays();
for (int i = 0; i < dt.Rows.Count; i++)
{
Event _Event = new Event();
_Event.EventID = int.Parse(dt.Rows[i]["event_id"].ToString());
_Event.EventName = dt.Rows[i]["event_name"].ToString();
_Event.EventDate = dt.Rows[i]["event_date"].ToString();
_Event.color = dt.Rows[i]["event_color"].ToString();
events.Add(_Event);
}
return(events);
}
public static List <Leaves> fetchleave(int userid)
{
List <Leaves> leaves = new List <Leaves>();
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.userid = userid;
DataTable dt = bus.fetch_leaves();
for (int i = 0; i < dt.Rows.Count; i++)
{
Leaves _Leaves = new Leaves();
_Leaves.LeaveType = dt.Rows[i]["ltype"].ToString();
_Leaves.LeaveCount = float.Parse(dt.Rows[i]["num"].ToString());
_Leaves.LeavePerc = float.Parse(dt.Rows[i]["perc"].ToString());
_Leaves.LeaveTot = float.Parse(dt.Rows[i]["tot"].ToString());
leaves.Add(_Leaves);
}
return(leaves);
}
public static List <leaveall> highcharts()
{
List <leaveall> ls = new List <leaveall>();
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
DataTable dt = bus.fill_leaves_all_highcharts();
for (int i = 0; i < dt.Rows.Count; i++)
{
leaveall _ls = new leaveall();
_ls.Name = dt.Rows[i]["name"].ToString();
_ls.aleave = float.Parse(dt.Rows[i]["aleave"].ToString());
_ls.sleave = float.Parse(dt.Rows[i]["sleave"].ToString());
_ls.mleave = float.Parse(dt.Rows[i]["mleave"].ToString());
_ls.m2leave = float.Parse(dt.Rows[i]["m2leave"].ToString());
_ls.pleave = float.Parse(dt.Rows[i]["pleave"].ToString());
_ls.hleave = float.Parse(dt.Rows[i]["hleave"].ToString());
ls.Add(_ls);
}
return(ls);
}
public static DataTable fetchdatesmaternity(int userid)
{
bus_eleave_ugc1 bus = new bus_eleave_ugc1();
bus.userid = userid;
DataTable dt = bus.fetch_holidaysma();
DataTable dtma = new DataTable();
dtma.Columns.Add("dates1");
for (int i = 0; i < dt.Rows.Count; i++)
{
string[] split = dt.Rows[i]["dates"].ToString().Split(',');
for (int j = 0; j < split.Length; j++)
{
DataRow dr = dtma.NewRow();
dr["dates1"] = split[j];
dtma.Rows.Add(dr);
}
}
return(dtma);
}
public static int in_out_maternity(int userid, int typ, int per, string sd, string ed, int region)
{
double ct1 = 0.0;
bus_eleave_ugc1 bus1 = new bus_eleave_ugc1();
if (region == 1)
{
List <DateTime> holday = new List <DateTime>();
DataTable dtio = fetchdatesmaternity(userid);
for (int i = 0; i < dtio.Rows.Count; i++)
{
holday.Add(DateTime.Parse(dtio.Rows[i]["dates1"].ToString()));
}
DateTime sd1 = DateTime.Parse(sd);
DateTime ed1 = DateTime.Parse(ed);
while (sd1 <= ed1)
{
if (holday.Contains(sd1))
{
sd1 = sd1.AddDays(1);
}
else
{
// get the count
ct1 = ct1 + 1;
sd1 = sd1.AddDays(1);
}
}
}
else if (region == 2)
{
List <DateTime> holday = new List <DateTime>();
DataTable dtio = fetchdatesmaternity_cochin(userid);
for (int i = 0; i < dtio.Rows.Count; i++)
{
holday.Add(DateTime.Parse(dtio.Rows[i]["dates1"].ToString()));
}
DateTime sd1 = DateTime.Parse(sd);
DateTime ed1 = DateTime.Parse(ed);
while (sd1 <= ed1)
{
if (holday.Contains(sd1))
{
sd1 = sd1.AddDays(1);
}
else
{
// get the count
ct1 = ct1 + 1;
sd1 = sd1.AddDays(1);
}
}
}
bus1.userid = userid;
bus1.ltype = typ;
if (per == 1)
{
bus1.rdays = ct1;
}
else
{
bus1.rdays = ct1 / 2;
}
int res = bus1.check_in_out();
return(res);
}
public static double in_out_maternity_days(int userid, int typ, int per, string sd, string ed, int region)
{
double ct1 = 0.0, req = 0.0;
if (region == 1) // Malaysia
{
bus_eleave_ugc1 bus1 = new bus_eleave_ugc1();
List <DateTime> holday = new List <DateTime>();
DataTable dtio = fetchdatesmaternity(userid);
for (int i = 0; i < dtio.Rows.Count; i++)
{
holday.Add(DateTime.Parse(dtio.Rows[i]["dates1"].ToString()));
}
DateTime sd1 = DateTime.Parse(sd);
DateTime ed1 = DateTime.Parse(ed);
while (sd1 <= ed1)
{
if (holday.Contains(sd1))
{
sd1 = sd1.AddDays(1);
}
else
{
// get the count
ct1 = ct1 + 1;
sd1 = sd1.AddDays(1);
}
}
}
else if (region == 2) //Cochin
{
bus_eleave_ugc1 bus1 = new bus_eleave_ugc1();
List <DateTime> holday = new List <DateTime>();
DataTable dtio = fetchdatesmaternity_cochin(userid);
for (int i = 0; i < dtio.Rows.Count; i++)
{
holday.Add(DateTime.Parse(dtio.Rows[i]["dates1"].ToString()));
}
DateTime sd1 = DateTime.Parse(sd);
DateTime ed1 = DateTime.Parse(ed);
while (sd1 <= ed1)
{
if (holday.Contains(sd1))
{
sd1 = sd1.AddDays(1);
}
else
{
// get the count
ct1 = ct1 + 1;
sd1 = sd1.AddDays(1);
}
}
}
else
{
}
req = ct1;
return(req);
}
