public Boolean ApproveCheck(leaveauthority lv, double totaldays)
{
Boolean status = false;
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "select a.MaxSanctionLimit from LeaveSanctionLimit a,EmployeeDesignation b where b.EmployeeID='" + Login.empLoggedIn + "' " +
"and a.Designation = b.Designation and a.LeaveID = '" + lv.leaveid + "'";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
if (reader.GetInt32(0) >= totaldays)
{
status = true;
}
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean CancelCancelRequest(leaveauthority lv)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update LeaveRequest set Remarks='" + lv.remarks + "', " +
"LeaveRequestStatus=11 " +
"where UserID in (select userid from ViewUserEmployeeList where EmployeeID = '" + lv.EmployeeID + "') and RowID='" + lv.rowid + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("approve", "LeaveRequest", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean RejectLeave(leaveauthority lv)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update LeaveRequest set " +
"Remarks='" + lv.remarks + "'" +
", LeaveRequestStatus=99 " +
", ApproveTime=GetDate() " +
" where RowID='" + lv.rowid + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "LeaveRequest", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean ApproveLeaveRequestModified(leaveauthority lv)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update LeaveRequest set Remarks='" + lv.remarks + "', SanctionedToDate='" + lv.sanctionedTo + "', " +
"documentstatus=99,LeaveRequestStatus=9 ,ApproveUser='******', " +
"ApproveTime=GetDate() where RowID='" + lv.rowid + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("approve", "LeaveRequest", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean ApproveLeaveRequestCOmpoff(leaveauthority lv, int tp)
{
Boolean status = true;
string utString = "";
string updateSQL = "";
try
{
updateSQL = "update LeaveRequest set Remarks='" + lv.remarks + "', " +
" SanctionedFromDate = '" + lv.sanctionedFrom.ToString("yyyy-MM-dd") + "', SanctionedToDate ='" + lv.sanctionedTo.ToString("yyyy-MM-dd") + "'," +
"ForwardUser='******',ForwarderList='" + lv.ForwarderList + "', documentstatus=99, ApproveUser='******', ApproveTime=GetDate() " +
"where RowID='" + lv.rowid + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("approve", "LeaveRequest", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = "update LeaveEarning set Status=2 where RowID in" +
" (select top " + tp + " rowid from LeaveEarning where " +
" EmployeeID='" + lv.EmployeeID + "' and LeaveID='CO' and Status=1)";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "LeaveEarning", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean forwardleave(leaveauthority lv)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update LeaveRequest set DocumentStatus += 1 , forwardUser='******'" +
", Remarks='" + lv.remarks + "'" +
", ForwarderList='" + lv.ForwarderList + "'" +
" where RowID='" + lv.rowid + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("forward", "LeaveRequest", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public List <leaveauthority> getLeaveRemain(string empid, string leaveid)
{
leaveauthority lvapp;
List <leaveauthority> LVlist = new List <leaveauthority>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "select DATEDIFF(DAY,a.SanctionedFromDate ,a.SanctionedToDate ) as totaldays from LeaveRequest a, " +
"(select b.UserID from ViewUserEmployeeList b where b.EmployeeID = '" + empid + "') c " +
" where a.UserID = c.UserID and a.LeaveID = '" + leaveid + "' and a.Status = 1 and a.DocumentStatus = 99 and a.LeaveRequestStatus in (1,11,10,9,7) and year(a.SanctionedFromDate)=year(GetDate()) ";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lvapp = new leaveauthority();
lvapp.leavepending = reader.IsDBNull(0)? 0 : reader.GetInt32(0);
LVlist.Add(lvapp);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(LVlist);
}
public List <leaveauthority> getLeaveLimit(string empid)
{
leaveauthority lvapp;
List <leaveauthority> LVlist = new List <leaveauthority>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "select a.LeaveCount,a.LeaveID from LeaveOB a where EmployeeID='" + empid + "'and a.year=year(GetDate())";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lvapp = new leaveauthority();
lvapp.maxdays = reader.GetInt32(0);
lvapp.leaveid = reader.GetString(1);
LVlist.Add(lvapp);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(LVlist);
}
public List <leaveauthority> getFilteredLeaveApproval(string userList, int opt)
{
leaveauthority lvpr;
List <leaveauthority> LeaveApr = new List <leaveauthority>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query1 = "select b.EmployeeID,b.Name,c.Description, a.FromDate,a.ToDate,a.DocumentStatus," +
"a.Status,a.LeaveRequestStatus,a.Remarks,a.ForwardUser,a.ForwarderList,a.ApproveUser,a.CreateTime,c.LeaveID,a.RowID,a.SanctionedFromDate,a.SanctionedToDate" +
" from LeaveRequest a, Employee b,LeaveType c, ERPUser d" +
" where b.EmployeeID = d.EmployeeID and a.LeaveID = c.LeaveID and a.UserID = d.UserID and a.Status = 1 and a.DocumentStatus between 2 and 99" +
" and a.LeaveRequestStatus in (1,2,4,5) ";
string query3 = "select b.EmployeeID,b.Name,c.Description, a.FromDate,a.ToDate,a.DocumentStatus, " +
"a.Status,a.LeaveRequestStatus,a.Remarks,a.ForwardUser,a.ForwarderList,a.ApproveUser,a.CreateTime,c.LeaveID,a.RowID,a.SanctionedFromDate,a.SanctionedToDate " +
" from LeaveRequest a, Employee b,LeaveType c, ERPUser d where b.EmployeeID = d.EmployeeID " +
" and a.LeaveID = c.LeaveID and a.UserID = d.UserID and a.Status <> 2 and " +
" a.LeaveRequestStatus not in (4,8)";
string query = "";
switch (opt)
{
case 1:
query = query1;
break;
case 3:
query = query3;
break;
default:
query = "";
break;
}
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lvpr = new leaveauthority();
lvpr.EmployeeID = reader.GetString(0);
lvpr.EmployeeName = reader.GetString(1);
lvpr.Leavetype = reader.GetString(2);
lvpr.fromdate = reader.GetDateTime(3);
lvpr.todate = reader.GetDateTime(4);
lvpr.documentStatus = reader.GetInt32(5);
lvpr.status = reader.GetInt32(6);
lvpr.leavestatus = reader.GetInt32(7);
lvpr.remarks = reader.GetString(8);
lvpr.ForwardUser = reader.IsDBNull(9) ? "" : reader.GetString(9);
lvpr.ForwarderList = reader.IsDBNull(10) ? "" : reader.GetString(10);
lvpr.ApproveUser = reader.IsDBNull(11)?"": reader.GetString(11);
lvpr.CreateTime = reader.GetDateTime(12);
lvpr.leaveid = reader.GetString(13);
lvpr.rowid = reader.GetInt32(14);
lvpr.sanctionedFrom = reader.IsDBNull(15)?DateTime.Now: reader.GetDateTime(15);
lvpr.sanctionedTo = reader.IsDBNull(16) ? DateTime.Now : reader.GetDateTime(16);
LeaveApr.Add(lvpr);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(LeaveApr);
}