public Form2(Form PUNCHOUT)
{
punchOut = PUNCHOUT;
InitializeComponent();
}
public JsonResult GetAttendanceHistory(string fromDate, string DateTo, string leaveType)
{
Dictionary <string, dynamic> dictionary = new Dictionary <string, dynamic>();
//string fromdate = "";
//string Tdate = "";
//DateTime fromDate1 = DateTime.Parse(fromDate);
//DateTime todate1 = DateTime.Parse(todate);
var userInfo = (User)Session["UserName"];
if (fromDate == "" || DateTo == "")
{
dictionary.Add("@fromDate", fromDate);
dictionary.Add("@todate", DateTo);
dictionary.Add("@empNo", userInfo.EmpCode);
dictionary.Add("@FSts", leaveType);
}
else
{
var dd = fromDate.Split('-');
var newDateFrom = dd[2] + "-" + dd[1] + "-" + dd[0];
var dd1 = DateTo.Split('-');
var newDateTo = dd1[2] + "-" + dd1[1] + "-" + dd1[0];
dictionary.Add("@fromDate", newDateFrom);
dictionary.Add("@todate", newDateTo);
dictionary.Add("@empNo", userInfo.EmpCode);
dictionary.Add("@FSts", leaveType);
}
ArrayList arr = new ArrayList();
var LeaveAvailHistory = Models.DAL.storedProc2(HRStoredProcedureName.GetAttendanceHistory, dictionary, DBName.HR);
//PunchDate,ShiftIn,ShiftOut,ShiftLate,FPunchIn,FPunchOut,FSts
foreach (DataRow item in LeaveAvailHistory.Rows)
{
var PunchDate = Convert.ToDateTime(item["PunchDate"]).ToString("dd-MM-yyy");
var ShiftIn = Convert.ToDateTime(item["ShiftIn"]).ToString("hh:mm:ss");
var ShiftOut = Convert.ToDateTime(item["ShiftOut"]).ToString("hh:mm:ss");
var ShiftLate = Convert.ToDateTime(item["ShiftLate"]).ToString("hh:mm:ss");
var FPunchIn = item["FPunchIn"].ToString() == "" ? "" : Convert.ToDateTime(item["FPunchIn"]).ToString("hh:mm:ss");
var FPunchOut = item["FPunchOut"].ToString() == "" ? "" : Convert.ToDateTime(item["FPunchOut"]).ToString("hh:mm:ss");
TimeSpan PunchOut;
TimeSpan ShiftO;
TimeSpan additionTime;
TimeSpan latetime;
TimeSpan PunchIn;
TimeSpan ShiftL;
TimeSpan.TryParse("00:00:00", out additionTime);
TimeSpan.TryParse("00:00:00", out latetime);
var ShiftName = item["ShiftName"].ToString();
string atime = string.Empty;
string ltime = string.Empty;
if (FPunchIn != "")
{
TimeSpan.TryParse(FPunchIn, out PunchIn);
TimeSpan.TryParse(ShiftLate, out ShiftL);
if (PunchIn > ShiftL)
{
latetime = PunchIn.Subtract(ShiftL); // (-00:30:00)
var s = latetime.Seconds.ToString().Length == 1 ? "0" + latetime.Seconds.ToString() : latetime.Seconds.ToString();
var m = latetime.Minutes.ToString().Length == 1 ? "0" + latetime.Minutes.ToString() : latetime.Minutes.ToString();
var h = latetime.Hours.ToString().Length == 1 ? "0" + latetime.Hours.ToString() : latetime.Hours.ToString();
ltime = h + ":" + m + ":" + s;
}
}
if (FPunchOut != "")
{
TimeSpan.TryParse(FPunchOut, out PunchOut);
TimeSpan.TryParse(ShiftOut, out ShiftO);
if (PunchOut > ShiftO)
{
additionTime = PunchOut.Subtract(ShiftO); // (-00:30:00)
var s = additionTime.Seconds.ToString().Length == 1 ? "0" + additionTime.Seconds.ToString() : additionTime.Seconds.ToString();
var m = additionTime.Minutes.ToString().Length == 1 ? "0" + additionTime.Minutes.ToString() : additionTime.Minutes.ToString();
var h = additionTime.Hours.ToString().Length == 1 ? "0" + additionTime.Hours.ToString() : additionTime.Hours.ToString();
atime = h + ":" + m + ":" + s;
}
}
var FSts = item["FSts"].ToString();
var obj = new
{
PunchDate = PunchDate,
ShiftName = ShiftName,
ShiftIn = ShiftIn,
ShiftOut = ShiftOut,
FPunchIn = FPunchIn,
FPunchOut = FPunchOut,
ShiftLate = ltime,
additionTime = atime,
FSts = FSts
};
arr.Add(obj);
}
// var results = JsonConvert.SerializeObject(LeaveAvailHistory);
return(new JsonResult {
Data = arr
});
}
