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 bool ResetPassword(User objUser) { bool blResult = false; try { IDbDataParameter[] arrParameter = new IDbDataParameter[] { DB_UTILITY.CreateParameter("@iUserMailID", DbType.String, ParameterDirection.Input, objUser.OfficialMailID), DB_UTILITY.CreateParameter("@iNewPassword", DbType.String, ParameterDirection.Input, objUser.Password), }; _dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_updateResetPassword", arrParameter); if (ValidateResultSet(_dsResultSet)) { if (Convert.ToInt16(_dsResultSet.Tables[0].Rows[0]["RESULT"]) == 1) { blResult = true; } } } catch (Exception ex) { throw ex; } return(blResult); }
public List <string> getAdminDashboardInformation() { //order in the list should be //USER AUTHENTICATION, USER QUERY, PARTNER QUERY, L1 COURSE, L2 COURSE COUNT, SUPPLIER COUNT, AGENCY COUNT List <string> lstDashbaordinfo = new List <string>(); try { IDbDataParameter[] arrParameter = new IDbDataParameter[] { }; dsResultSet = DB_UTILITY.RunSP("USP_FETCH_ADMINDASHBOARD", arrParameter); if (ValidateResultSet(dsResultSet)) { foreach (DataTable dtTable in dsResultSet.Tables) { lstDashbaordinfo.Add(dtTable.Rows[0][0].ToString()); } } } catch (Exception ex) { throw ex; } return(lstDashbaordinfo); }
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> /// New DSR Submission /// </summary> /// <param name="objRequirement"></param> /// <returns></returns> public bool insertDSR(Task objRequirement) { bool blResult = false; try { IDbDataParameter[] arrParameter = new IDbDataParameter[] { DB_UTILITY.CreateParameter("@ixml", DbType.Xml, ParameterDirection.Input, objRequirement.strXMLData), DB_UTILITY.CreateParameter("@iUserCode", DbType.Int32, ParameterDirection.Input, objRequirement.CreatedByCode) }; _dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_insertDSR", arrParameter); if (ValidateResultSet(_dsResultSet)) { if (Convert.ToInt32(_dsResultSet.Tables[0].Rows[0]["RESULT"]) == 1) { blResult = true; } } } catch (Exception ex) { throw ex; } return(blResult); }
public bool CreateCategory(Category category) { bool result = false; try { IDbDataParameter[] arrParameter = new IDbDataParameter[] { DB_UTILITY.CreateParameter("@iTitle", DbType.String, ParameterDirection.Input, category.Title), DB_UTILITY.CreateParameter("@iDescription", DbType.String, ParameterDirection.Input, category.Details), DB_UTILITY.CreateParameter("@iBannerImage", DbType.String, ParameterDirection.Input, category.HomeImage == null ? "" : category.HomeImage), DB_UTILITY.CreateParameter("@iBannerImageAccess", DbType.String, ParameterDirection.Input, category.HomeImageAccess), DB_UTILITY.CreateParameter("@iHomePageAccess", DbType.String, ParameterDirection.Input, category.HomePageAccess), DB_UTILITY.CreateParameter("@iStatus", DbType.String, ParameterDirection.Input, "1") }; dsResultSet = DB_UTILITY.RunSP("USP_INSERTTBL_CATEGORY", arrParameter); if (ValidateResultSet(dsResultSet)) { result = Convert.ToBoolean(dsResultSet.Tables[0].Rows[0][0]); } } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// New Requirement /// Name:Ravi Venkatesh Maddela /// Date:12-06-2017 /// </summary> /// <param name="objRequirement"></param> /// <returns></returns> public bool NewTasks(Task objRequirement) { bool blResult = false; try { IDbDataParameter[] arrParameter = new IDbDataParameter[]{ DB_UTILITY.CreateParameter("@iUserCode", DbType.Int16, ParameterDirection.Input, objRequirement.CreatedByCode ), DB_UTILITY.CreateParameter("@iTitle", DbType.String, ParameterDirection.Input, objRequirement.Title), DB_UTILITY.CreateParameter("@iDescription", DbType.String, ParameterDirection.Input, objRequirement.Description), DB_UTILITY.CreateParameter("@iType", DbType.Int16, ParameterDirection.Input, objRequirement.Type), DB_UTILITY.CreateParameter("@iNoOfEfforts", DbType.Int16, ParameterDirection.Input, objRequirement.EstimatedEfforts), DB_UTILITY.CreateParameter("@iProjectName",DbType.String,ParameterDirection.Input,objRequirement.ProjectName), DB_UTILITY.CreateParameter("@iSmokeTestStatus",DbType.Int16,ParameterDirection.Input,objRequirement.SmokeTestStatus) }; _dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_insertRequirement", arrParameter); if (ValidateResultSet(_dsResultSet)) { if(Convert.ToInt32(_dsResultSet.Tables[0].Rows[0]["RESULT"]) == 1) { blResult = true; } } } catch (Exception ex) { throw ex; } return blResult; }
/// <summary> /// Mapping user to task /// </summary> /// <param name="strUserCode"></param> /// <param name="strTaskID"></param> /// <param name="iNoOfEfforts"></param> public bool MapTaskToUser(string strUserOfficialMail, int strTaskID, int iNoOfEfforts) { bool blResult = false; try { IDbDataParameter[] arrParameter = new IDbDataParameter[]{ DB_UTILITY.CreateParameter("@iUserOfficialMailID", DbType.String, ParameterDirection.Input, strUserOfficialMail ), DB_UTILITY.CreateParameter("@iTaskID", DbType.Int32, ParameterDirection.Input, strTaskID ), DB_UTILITY.CreateParameter("@iEstimatedEfforts", DbType.Int32, ParameterDirection.Input, iNoOfEfforts ) }; _dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_insertMapUserWithTask", arrParameter); if (ValidateResultSet(_dsResultSet)) { if (Convert.ToInt32(_dsResultSet.Tables[0].Rows[0]["RESULT"]) == 1) { blResult = true; } } } catch (Exception ex) { throw ex; } return blResult; }
public string updateNotificationData(int iUserCode) { try { IDbDataParameter[] arrParameter = new IDbDataParameter[] { DB_UTILITY.CreateParameter("@ic_NotificationSNo", DbType.Int32, ParameterDirection.Input, iUserCode) }; _dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_updateNotifications", arrParameter); } catch (Exception ex) { throw ex; } return("successs"); }
/// <summary> /// New DSR Submission /// </summary> /// <param name="objRequirement"></param> /// <returns></returns> public void insertDSR(string strName, string strEMail, string strContactNo, string strMessage) { try { IDbDataParameter[] arrParameter = new IDbDataParameter[] { DB_UTILITY.CreateParameter("@iName", DbType.String, ParameterDirection.Input, strName), DB_UTILITY.CreateParameter("@iContactNo", DbType.String, ParameterDirection.Input, strContactNo), DB_UTILITY.CreateParameter("@iMailId", DbType.String, ParameterDirection.Input, strEMail), DB_UTILITY.CreateParameter("@iMessage", DbType.String, ParameterDirection.Input, strMessage) }; _dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_insertDotnetDrive", arrParameter); } catch (Exception ex) { throw ex; } }
/// <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); }
/// <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; }
//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> /// 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 bool CreateHostel(Hostel Hostel) { bool result = false; try { IDbDataParameter[] arrParameter = new IDbDataParameter[] { DB_UTILITY.CreateParameter("@iTitle", DbType.String, ParameterDirection.Input, Hostel.Title), DB_UTILITY.CreateParameter("@iDescription", DbType.String, ParameterDirection.Input, Hostel.Detials), DB_UTILITY.CreateParameter("@iCategory", DbType.String, ParameterDirection.Input, Hostel.Category), DB_UTILITY.CreateParameter("@iBannerImage", DbType.String, ParameterDirection.Input, Hostel.BannerImage == null ? "" : Hostel.BannerImage), DB_UTILITY.CreateParameter("@iBannerImageAccess", DbType.String, ParameterDirection.Input, Hostel.BannerImageAccess), DB_UTILITY.CreateParameter("@iSliderAccess", DbType.String, ParameterDirection.Input, Hostel.SliderAccess), DB_UTILITY.CreateParameter("@iStateCode", DbType.String, ParameterDirection.Input, Hostel.StateCode), DB_UTILITY.CreateParameter("@iCityCode", DbType.String, ParameterDirection.Input, Hostel.CityCode), DB_UTILITY.CreateParameter("@iAreaCode", DbType.String, ParameterDirection.Input, Hostel.AreaCode), DB_UTILITY.CreateParameter("@iContactNo", DbType.String, ParameterDirection.Input, Hostel.ContactNumber), DB_UTILITY.CreateParameter("@iMailID", DbType.String, ParameterDirection.Input, Hostel.MailID), DB_UTILITY.CreateParameter("@iAddress", DbType.String, ParameterDirection.Input, Hostel.Address), DB_UTILITY.CreateParameter("@iLandmark", DbType.String, ParameterDirection.Input, Hostel.Landmark), DB_UTILITY.CreateParameter("@iShare", DbType.String, ParameterDirection.Input, Hostel.Share), DB_UTILITY.CreateParameter("@iBudget", DbType.String, ParameterDirection.Input, Hostel.Budget), DB_UTILITY.CreateParameter("@iAmenities", DbType.String, ParameterDirection.Input, Hostel.Amenities), DB_UTILITY.CreateParameter("@iGoogleLocation", DbType.String, ParameterDirection.Input, Hostel.GoogleLocation), DB_UTILITY.CreateParameter("@iHomePageAccess", DbType.String, ParameterDirection.Input, Hostel.HomePageAccess), DB_UTILITY.CreateParameter("@iStatus", DbType.String, ParameterDirection.Input, "1") }; dsResultSet = DB_UTILITY.RunSP("USP_INSERTTBL_AGENCY", arrParameter); if (ValidateResultSet(dsResultSet)) { result = Convert.ToBoolean(dsResultSet.Tables[0].Rows[0][0]); } } catch (Exception ex) { throw ex; } return(result); }
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); }
public bool CreateInstitute(Institute Institute) { bool result = false; try { IDbDataParameter[] arrParameter = new IDbDataParameter[] { DB_UTILITY.CreateParameter("@iTitle", DbType.String, ParameterDirection.Input, Institute.Title), DB_UTILITY.CreateParameter("@iDescription", DbType.String, ParameterDirection.Input, Institute.Details), DB_UTILITY.CreateParameter("@iBannerImage", DbType.String, ParameterDirection.Input, Institute.BannerImage == null ? "" : Institute.BannerImage), DB_UTILITY.CreateParameter("@iBannerImageAccess", DbType.String, ParameterDirection.Input, Institute.BannerImageAccess), DB_UTILITY.CreateParameter("@iSliderAccess", DbType.String, ParameterDirection.Input, Institute.SliderAccess), DB_UTILITY.CreateParameter("@iStateCode", DbType.String, ParameterDirection.Input, Institute.StateCode), DB_UTILITY.CreateParameter("@iCityCode", DbType.String, ParameterDirection.Input, Institute.CityCode), DB_UTILITY.CreateParameter("@iAreaCode", DbType.String, ParameterDirection.Input, Institute.AreaCode), DB_UTILITY.CreateParameter("@iContactNo", DbType.String, ParameterDirection.Input, Institute.ContactNo), DB_UTILITY.CreateParameter("@iMailID", DbType.String, ParameterDirection.Input, Institute.MailID), DB_UTILITY.CreateParameter("@iAddress", DbType.String, ParameterDirection.Input, Institute.Address), DB_UTILITY.CreateParameter("@iLandmark", DbType.String, ParameterDirection.Input, Institute.Landmark), DB_UTILITY.CreateParameter("@iGoogleLocation", DbType.String, ParameterDirection.Input, Institute.GoogleLocation), DB_UTILITY.CreateParameter("@iHomePageAccess", DbType.String, ParameterDirection.Input, Institute.HomePageAccess), DB_UTILITY.CreateParameter("@iStatus", DbType.String, ParameterDirection.Input, "1") }; dsResultSet = DB_UTILITY.RunSP("USP_INSERTTBL_SUPPLIER", arrParameter); if (ValidateResultSet(dsResultSet)) { result = Convert.ToBoolean(dsResultSet.Tables[0].Rows[0][0]); } } catch (Exception ex) { throw ex; } return(result); }
//inserting new notification public bool InsertNotification(Notification objUser) { bool blResult; try { IDbDataParameter[] arrParameter = new IDbDataParameter[] { DB_UTILITY.CreateParameter("@iPostedby", DbType.Int32, ParameterDirection.Input, objUser.PostedBy), DB_UTILITY.CreateParameter("@iTitle", DbType.String, ParameterDirection.Input, objUser.Title), DB_UTILITY.CreateParameter("@iDescription", DbType.String, ParameterDirection.Input, objUser.Description), DB_UTILITY.CreateParameter("@iType", DbType.Int32, ParameterDirection.Input, objUser.Type), DB_UTILITY.CreateParameter("@icontroltype", DbType.Int32, ParameterDirection.Input, objUser.Control), }; _dsResultSet = CommonUtility.DB_UTILITY.RunSP("usp_insertNotifications", arrParameter); blResult = true; } catch (Exception ex) { throw ex; } return(blResult); }
/// <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; }