public DataSet GetMonthlyLeavetransactions() { string strSql = string.Empty; strSql = "select * from tbl_ApplicationData a,tbl_Status s,tbl_LeaveType l where a.ApplicationStatusId=s.StatusId and a.LeaveTypeId=l.LeaveTypeId "; if (!string.IsNullOrEmpty(_UserName)) { strSql += " and a.UserName like '%" + _UserName + "%'"; } if (!string.IsNullOrEmpty(_StartingMonth)) { strSql += " and a.StartingDate >'" + _StartingMonth + "' "; } if (!string.IsNullOrEmpty(_EndingMonth)) { strSql += " and a.StartingDate <'" + _EndingMonth + "' "; } if (!string.IsNullOrEmpty(_StartingDate)) { strSql += " and a.StartingDate >'" + _StartingDate + "' "; } if (!string.IsNullOrEmpty(_EndingDate)) { strSql += " and a.StartingDate <'" + _EndingDate + "' "; } if (Sort_On != "") { strSql = strSql + " ORDER BY " + Sort_On; } else { strSql = strSql + " Order By a.UserName"; } DataSet dsTemp; dsTemp = SqlHelper.ExecuteDataset(ClsConnectionString.getConnectionString(), CommandType.Text, strSql); return(dsTemp); }
public void GetCountryDetails() { string strSql = string.Empty; strSql += "select c.CountryId,c.CountryName,c.CountryDescription,s.StatusName from tbl_Country c,tbl_Status s where c.StatusId=s.StatusId"; strSql += " and c.CountryId=" + _CountryId; DataSet dsTemp; dsTemp = SqlHelper.ExecuteDataset(ClsConnectionString.getConnectionString(), CommandType.Text, strSql); DataRowCollection drc = dsTemp.Tables[0].Rows; if (drc.Count > 0) { _CountryName = drc[0]["CountryName"].ToString(); _CountryDescr = drc[0]["CountryDescription"].ToString(); _StatusName = drc[0]["StatusName"].ToString(); } else { _CountryName = ""; _CountryDescr = ""; } }
public DataSet GetDept() { string strSql = string.Empty; //strSql = "select c.DeptId,c.DeptName,c.DeptDescription,s.StatusName from tbl_Dept c,tbl_Status s where c.StatusId=s.StatusId"; strSql += "select * from tbl_Dept where 1=1"; if (_DeptName != "") { strSql += " and DeptName like '%" + _DeptName + "%'"; } if (Sort_On != "") { strSql = strSql + " ORDER BY " + Sort_On; } else { strSql = strSql + " Order By DeptName"; } DataSet dsTemp; dsTemp = SqlHelper.ExecuteDataset(ClsConnectionString.getConnectionString(), CommandType.Text, strSql); return(dsTemp); }
public void GetEmployeeDetails() { ///* //string strSql = string.Empty; //strSql += "select * from tbl_ClientDetails u,tbl_ClientLoginAccount ul, tbl_Status stat where u.StatusId=stat.StatusId and ul.ClientId=u.ClientId "; //strSql += " and u.ClientId=" + _UserId; SqlParameter[] p = new SqlParameter [1]; p[0] = new SqlParameter("@UserName", SqlDbType.VarChar); p[0].Value = _UserName; DataSet dsTemp;; dsTemp = SqlHelper.ExecuteDataset(ClsConnectionString.getConnectionString(), CommandType.StoredProcedure, "spGetEmpDetails", p); DataRowCollection drc = dsTemp.Tables[0].Rows; if (drc.Count > 0) { _UserName = drc[0]["UserName"].ToString(); _EmpName = drc[0]["EmpName"].ToString(); _Designation = drc[0]["EmpDesigName"].ToString(); _ContactNo = drc[0]["ContactNo"].ToString(); _Address = drc[0]["Address"].ToString(); _EmailId = drc[0]["EmailId"].ToString(); _CityId = Convert.ToInt32(drc[0]["CityId"].ToString()); _StateId = Convert.ToInt32(drc[0]["StateId"].ToString()); _CountryId = Convert.ToInt32(drc[0]["CountryId"].ToString()); _DeptId = Convert.ToInt32(drc[0]["DeptId"].ToString()); } else { _EmpName = ""; _ContactNo = ""; _Address = ""; _EmailId = ""; } }
public DataSet GetLeaveType() { return(SqlHelper.ExecuteDataset(ClsConnectionString.getConnectionString(), CommandType.StoredProcedure, "spGetLeaveType")); }
public DataSet GetNextDayEmpList() { return(SqlHelper.ExecuteDataset(ClsConnectionString.getConnectionString(), CommandType.Text, "spGetNextDayEmpList")); }