public Hashtable getHomeInformation()
{
//order in the list should be
//
List <string> lsthomeinfo = new List <string>();
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] { };
dsResultSet = DB_UTILITY.RunSP("USP_FETCH_HOMEMASTERDATA", arrParameter);
if (ValidateResultSet(dsResultSet))
{
htHomeData = new Hashtable();
htHomeData.Add("CATEGORY", OBJECT_UTILITY.GetConvertCollection <Category>(dsResultSet.Tables[0]));
htHomeData.Add("INSTITUTE", OBJECT_UTILITY.GetConvertCollection <Institute>(dsResultSet.Tables[1]));
htHomeData.Add("HOSTEL", OBJECT_UTILITY.GetConvertCollection <Hostel>((dsResultSet.Tables[2])));
}
}
catch (Exception ex)
{
throw ex;
}
return(htHomeData);
}
public List <string> autoGetUserMailID(string strPreKey)
{
List <string> lstMailID = new List <string>();
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] {
DB_UTILITY.CreateParameter("@iOfficialMailID", DbType.String, ParameterDirection.Input, strPreKey)
};
_dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_auto_fetchUserData", arrParameter);
if (ValidateResultSet(_dsResultSet))
{
lstUser = OBJECT_UTILITY.GetConvertCollection <User>(_dsResultSet.Tables[0]);
lstMailID = lstUser.Select(m => m.OfficialMailID).ToList <string>();
}
}
catch (Exception ex)
{
throw ex;
}
return(lstMailID);
}
/// <summary>
/// Description:To get the active user list from database
/// Name:Bhargav krishna
/// </summary>
public List <Users> GetUsers()
{
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] { };
dsResultSet = DB_UTILITY.RunSP("USP_FETCH_USERSLIST", arrParameter);
if (ValidateResultSet(dsResultSet))
{
listuser = OBJECT_UTILITY.GetConvertCollection <Users>(dsResultSet.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return(listuser);
}
public List <Category> getCategoryList(ref int Total)
{
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] { };
dsResultSet = DB_UTILITY.RunSP("USP_FETCHTBL_CATEGORY", arrParameter);
if (ValidateResultSet(dsResultSet))
{
Total = Convert.ToInt32(dsResultSet.Tables[0].Rows[0][0]);
lstCategory = OBJECT_UTILITY.GetConvertCollection <Category>(dsResultSet.Tables[1]);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstCategory);
}
//getting notification data
public List <Notification> getNotificationData(int iUserCode)
{
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] {
DB_UTILITY.CreateParameter("@iUserCode", DbType.Int16, ParameterDirection.Input, iUserCode)
};
_dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_fetchNotifications", arrParameter);
if (ValidateResultSet(_dsResultSet))
{
lstNotification = OBJECT_UTILITY.GetConvertCollection <Notification>(_dsResultSet.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstNotification);
}
/// <summary>
/// Task Details
/// Name:Ravi Venkatesh Maddela
/// Date:22-06-2017
/// </summary>
/// <param name="objTasks"></param>
/// <returns></returns>
public Task GetTaskDetails(Task objTasks)
{
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[]{
DB_UTILITY.CreateParameter("@iTaskId", DbType.Int16, ParameterDirection.Input, objTasks.TaskId )
};
_dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_fetchTaskDetails", arrParameter);
if (ValidateResultSet(_dsResultSet))
{
_beRequirement = OBJECT_UTILITY.GetConvert<Task>(_dsResultSet.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return _beRequirement;
}
/// <summary>
/// Description :Verify User Login
/// Name:Sruthi A
/// </summary>
public Users VerifyUserLogin(string UserMailID, string Password)
{
_users = new Users();
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] {
DB_UTILITY.CreateParameter("@iMailId", DbType.String, ParameterDirection.Input, UserMailID),
DB_UTILITY.CreateParameter("@iPassword", DbType.String, ParameterDirection.Input, Password)
};
dtuser = DB_UTILITY.RunSP("USP_FETCH_USERSLOGIN", arrParameter);
if (ValidateResultSet(dtuser))
{
_users = OBJECT_UTILITY.GetConvert <Users>(dtuser.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return(_users);
}
public List <Location> getLocations()
{
//order in the list should be
//
List <string> lstlocationinfo = new List <string>();
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] { };
dsResultSet = DB_UTILITY.RunSP("USP_FETCH_LOCATION", arrParameter);
if (ValidateResultSet(dsResultSet))
{
lstLocations = OBJECT_UTILITY.GetConvertCollection <Location>(dsResultSet.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstLocations);
}
public List <Hostel> getHostels()
{
//order in the list should be
//
List <string> lstHostelinfo = new List <string>();
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] { };
dsResultSet = DB_UTILITY.RunSP("USP_FETCH_AGENCY", arrParameter);
if (ValidateResultSet(dsResultSet))
{
lstHostel = OBJECT_UTILITY.GetConvertCollection <Hostel>(dsResultSet.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstHostel);
}
/// <summary>
/// Employee DSR Report
/// Name:Ramu Nimmala
/// Date:30-09-2017
/// </summary>
/// <param name="objRequirement"></param>
/// <returns></returns>
public List <DSR> GetDSR(string strDate)
{
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] {
DB_UTILITY.CreateParameter("@iDate", DbType.String, ParameterDirection.Input, strDate)
};
_dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_fetchDSR", arrParameter);
if (ValidateResultSet(_dsResultSet))
{
lstDSR = new List <DSR>();
lstDSR = OBJECT_UTILITY.GetConvertCollection <DSR>(_dsResultSet.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstDSR);
}
/// <summary>
/// Requirements
/// Name:hanumantharao muppalla
/// Date:24-11-2017
/// </summary>
/// <param name="objTasks"></param>
/// <returns></returns>
public List<Task> GetTaskID(string strTaskID)
{
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[]{
DB_UTILITY.CreateParameter("@iTaskId", DbType.String, ParameterDirection.Input, strTaskID )
};
_dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_auto_fetchTaskDetails", arrParameter);
if (ValidateResultSet(_dsResultSet))
{
ltask = new List<Task>();
ltask = OBJECT_UTILITY.GetConvertCollection<Task>(_dsResultSet.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return ltask;
}
/// <summary>
/// Requirements
/// Name:Sudha Rani Lingutla
/// Date:13-06-2017
/// </summary>
/// <param name="objTasks"></param>
/// <returns></returns>
public List<Task> GetTasks(Task objTasks)
{
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[]{
DB_UTILITY.CreateParameter("@iUserCode", DbType.Int16, ParameterDirection.Input, objTasks.CreatedByCode )
};
_dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_fetchTasks", arrParameter);
if (ValidateResultSet(_dsResultSet))
{
ltask = new List<Task>();
ltask = OBJECT_UTILITY.GetConvertCollection<Task>(_dsResultSet.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return ltask;
}
/// <summary>
/// Check User Login
/// Name:Ravi Venkatesh Maddela
/// Date:10-06-2017
/// </summary>
/// <param name="objUser"></param>
/// <returns></returns>
public User CheckUserLogin(User objUser)
{
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[] {
DB_UTILITY.CreateParameter("@iUMID", DbType.String, ParameterDirection.Input, objUser.LoginId),
DB_UTILITY.CreateParameter("@iPassword", DbType.String, ParameterDirection.Input, objUser.Password),
};
_dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_fetchLoginUser", arrParameter);
if (ValidateResultSet(_dsResultSet))
{
beMember = OBJECT_UTILITY.GetConvert <User>(_dsResultSet.Tables[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return(beMember);
}
/// <summary>
/// Requirements
/// Name:Ravi Venkatesh Maddela
/// Date:15-07-2017
/// </summary>
/// <param name="objTasks"></param>
/// <returns></returns>
public List<string> auto_fetchTaskDetails(Task objTasks)
{
List<string> lstId = new List<string>();
try
{
IDbDataParameter[] arrParameter = new IDbDataParameter[]{
DB_UTILITY.CreateParameter("@iTaskID", DbType.Int32, ParameterDirection.Input, objTasks.TaskId )
};
_dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_auto_fetchTaskDetails", arrParameter);
if (ValidateResultSet(_dsResultSet))
{
ltask = new List<Task>();
ltask = OBJECT_UTILITY.GetConvertCollection<Task>(_dsResultSet.Tables[0]);
lstId = ltask.Select(s => Convert.ToString(s.TaskId)).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return lstId;
}
