public List <PriorityDTO> GetPriority() { List <PriorityDTO> item = new List <PriorityDTO>(); try { DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetPriority"); if (dtUser != null && dtUser.Rows.Count > 0) { int i = 0; foreach (DataRow row in dtUser.Rows) { // if (dtUser != null && dtUser.Rows.Count > 0) // { PriorityDTO list = new PriorityDTO(); list.CreatedDate = Convert.ToDateTime(dtUser.Rows[0]["CreatedDate"].ToString()); list.Creator = dtUser.Rows[0]["Creator"].ToString(); list.Description = dtUser.Rows[0]["Description"].ToString(); list.Level = dtUser.Rows[0]["Level"].ToString(); list.ModifiedDate = Convert.ToDateTime(dtUser.Rows[0]["ModifiedDate"].ToString()); list.Name = dtUser.Rows[0]["Name"].ToString(); list.NumberOfHoursDeadline = Convert.ToDecimal(dtUser.Rows[0]["NumberOfHoursDeadline"].ToString()); list.PriorityID = Convert.ToInt32(dtUser.Rows[0]["PriorityID"].ToString()); item.Add(list); } } } catch (Exception ex) { } return(item); }
public JobSiteDTO GetSitesBySiteID(int siteID) { JobSiteDTO item = new JobSiteDTO(); try { SqlParameter param = new SqlParameter("SiteID", siteID); DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetSiteBySiteID", new SqlParameter[] { param }); if (dtUser != null && dtUser.Rows.Count > 0) { item.Address = dtUser.Rows[0]["Address"].ToString(); // item.Coaxial = dtUser.Rows[0]["Coaxial"].ToString(); // item.CreationDate = dtUser.Rows[0]["CreationDate"].ToString(); item.Customer = dtUser.Rows[0]["Customer"].ToString(); // item.DeviceRegistration = dtUser.Rows[0]["DeviceRegistration"].ToString(); // item.Dispensers = dtUser.Rows[0]["Dispensers"].ToString(); // item.FacilityName = dtUser.Rows[0]["FacilityName"].ToString(); // item.MarketingManager = dtUser.Rows[0]["MarketingManager"].ToString(); // item.MeterCount = dtUser.Rows[0]["MeterCount"].ToString(); // item.ModifiedDate = dtUser.Rows[0]["ModifiedDate"].ToString(); item.PhoneNumber = dtUser.Rows[0]["PhoneNumber"].ToString(); // item.PicturesFiles = dtUser.Rows[0]["Pictures/Files"].ToString(); // item.RSM = dtUser.Rows[0]["RSM"].ToString(); // item.SiteEmail = dtUser.Rows[0]["SiteEmail"].ToString(); // item.StateID = dtUser.Rows[0]["StateID"].ToString(); item.Tanks = dtUser.Rows[0]["Tanks"].ToString(); item.UniqueID = dtUser.Rows[0]["UniqueID"].ToString(); item.WeightsAndMeasuresCertificateNumber = dtUser.Rows[0]["WeightsAndMeasuresCertificateNumber"].ToString(); item.WMCertificateImage = dtUser.Rows[0]["WMCertificateImage"].ToString(); } } catch (Exception ex) { } return(item); }
public List <DepartmentDTO> GetDepartments() { List <DepartmentDTO> list = new List <DepartmentDTO>(); try { DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetDepartments"); if (dtUser != null && dtUser.Rows.Count > 0) { int i = 0; foreach (DataRow row in dtUser.Rows) { // if (dtUser != null && dtUser.Rows.Count > 0) // { DepartmentDTO item = new DepartmentDTO(); item.DepartmentID = Convert.ToInt32(dtUser.Rows[i]["DepartmentID"].ToString()); item.Company = dtUser.Rows[i]["Company"].ToString(); item.Manager = dtUser.Rows[i]["Manager"].ToString(); item.Rate1 = dtUser.Rows[i]["Rate1"].ToString(); item.DefaultRate = dtUser.Rows[i]["DefaultRate"].ToString(); item.Name = dtUser.Rows[i]["Name"].ToString(); item.CreationDate = Convert.ToDateTime(dtUser.Rows[i]["CreationDate"].ToString()); item.ModifiedDate = Convert.ToDateTime(dtUser.Rows[i]["ModifiedDate"].ToString()); item.Creator = dtUser.Rows[i]["Creator"].ToString(); item.UniqueID = dtUser.Rows[i]["UniqueID"].ToString(); list.Add(item); i++; } } } catch (Exception ex) { } return(list); }
public ResponseDTO UserLogin(string email, string password) { ResponseDTO response = new ResponseDTO(); try { if ((!string.IsNullOrEmpty(email)) && (!string.IsNullOrEmpty(password))) { SqlParameter paramEmail = new SqlParameter("email", email); SqlParameter paramPassword = new SqlParameter("Password", password); DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetUserByLogin", new SqlParameter[] { paramEmail, paramPassword }); BusinessDTO.User userData = new BusinessDTO.User(); if (dtUser != null && dtUser.Rows.Count > 0) { response.LoginResult = LoginResultType.Success; response.IsSuccess = true; response.Message = "login success"; } else { response.LoginResult = LoginResultType.InvalidLogin; response.Message = "fail"; } } } catch (Exception ex) { response.LoginResult = LoginResultType.InvalidLogin; response.ResponseData = null; response.Message = ex.Message; } return(response); }
public bool GetUserByEmail(string email) { ResponseDTO response = new ResponseDTO(); try { if ((!string.IsNullOrEmpty(email))) { SqlParameter paramEmail = new SqlParameter("email", email); DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetUserByEmail", new SqlParameter[] { paramEmail }); if (dtUser != null && dtUser.Rows.Count > 0) { response.IsSuccess = true; response.Message = "Email exist."; } else { response.IsSuccess = false; response.Message = "Email not exist."; } } } catch (Exception ex) { response.IsSuccess = false; response.Message = "Email not exist."; } return(response.IsSuccess); }
public List <RoleDTO> GetRole() { List <RoleDTO> list = new List <RoleDTO>(); try { DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetRole"); if (dtUser != null && dtUser.Rows.Count > 0) { int i = 0; foreach (DataRow row in dtUser.Rows) { // if (dtUser != null && dtUser.Rows.Count > 0) // { RoleDTO role = new RoleDTO(); role.RoleId = Convert.ToInt32(dtUser.Rows[i]["RoleId"].ToString()); role.RoleName = dtUser.Rows[i]["RoleName"].ToString(); role.IsActive = Convert.ToBoolean(dtUser.Rows[i]["IsActive"].ToString()); // } list.Add(role); i++; } } } catch (Exception ex) { } return(list); }
public List <JobSiteDTO> GetSites() { List <JobSiteDTO> list = new List <JobSiteDTO>(); try { DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetSite"); if (dtUser != null && dtUser.Rows.Count > 0) { int i = 0; foreach (DataRow row in dtUser.Rows) { // if (dtUser != null && dtUser.Rows.Count > 0) // { JobSiteDTO item = new JobSiteDTO(); item.Address = dtUser.Rows[i]["Address"].ToString(); // item.Coaxial = dtUser.Rows[i]["Coaxial"].ToString(); // item.CreationDate = dtUser.Rows[i]["CreationDate"].ToString(); item.Customer = dtUser.Rows[i]["Customer"].ToString(); // item.DeviceRegistration = dtUser.Rows[i]["DeviceRegistration"].ToString(); // item.Dispensers = dtUser.Rows[i]["Dispensers"].ToString(); // item.FacilityName = dtUser.Rows[i]["FacilityName"].ToString(); // item.MarketingManager = dtUser.Rows[i]["MarketingManager"].ToString(); // item.MeterCount = dtUser.Rows[i]["MeterCount"].ToString(); // item.ModifiedDate = dtUser.Rows[i]["ModifiedDate"].ToString(); item.PhoneNumber = dtUser.Rows[i]["PhoneNumber"].ToString(); // item.PicturesFiles = dtUser.Rows[i]["Pictures/Files"].ToString(); // item.RSM = dtUser.Rows[i]["RSM"].ToString(); // item.SiteEmail = dtUser.Rows[i]["SiteEmail"].ToString(); // item.StateID = dtUser.Rows[i]["StateID"].ToString(); item.Tanks = dtUser.Rows[i]["Tanks"].ToString(); item.UniqueID = dtUser.Rows[i]["UniqueID"].ToString(); item.WeightsAndMeasuresCertificateNumber = dtUser.Rows[i]["WeightsAndMeasuresCertificateNumber"].ToString(); item.WMCertificateImage = dtUser.Rows[i]["WMCertificateImage"].ToString(); list.Add(item); } } } catch (Exception ex) { } return(list); }
public PasscodeDTO GetPasscode() { PasscodeDTO list = new PasscodeDTO(); try { DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetPassCode"); if (dtUser != null && dtUser.Rows.Count > 0) { list.PasscodeID = Convert.ToInt32(dtUser.Rows[0]["PasscodeID"].ToString()); list.PassCode = dtUser.Rows[0]["PassCode"].ToString(); list.RecipientEmail = dtUser.Rows[0]["RecipientEmail"].ToString(); list.SenderID = dtUser.Rows[0]["SenderID"].ToString(); list.IsSignedUp = Convert.ToBoolean(dtUser.Rows[0]["IsSignedUp"].ToString()); } } catch (Exception ex) { } return(list); }
public ResponseDTO ForgotPassword(string email) { ResponseDTO response = new ResponseDTO(); try { if ((!string.IsNullOrEmpty(email))) { SqlParameter paramEmail = new SqlParameter("email", email); // SqlParameter paramPassword = new SqlParameter("Password", password); DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetUserByEmail", new SqlParameter[] { paramEmail }); BusinessDTO.User userData = new BusinessDTO.User(); if (dtUser != null && dtUser.Rows.Count > 0) { MailMessage PwReminderEmail = new MailMessage { // email from address From = new MailAddress(ConfigurationManager.AppSettings["SupportEmail"]) }; // email to address PwReminderEmail.To.Add(email); // email subject PwReminderEmail.Subject = "FuelDashp password"; // email body //PwReminderEmail.Body = emailSettings.Body; string body = "<p>You were trying to retrive your password from FuelDash app. <br/><br/>Your password is " + dtUser.Rows[0]["Password"].ToString() + " </p>"; PwReminderEmail.Body = body; PwReminderEmail.IsBodyHtml = true; SmtpClient smtpClient = new SmtpClient(ConfigurationManager.AppSettings["SMTPServer"], Convert.ToInt32(ConfigurationManager.AppSettings["SMTPPort"])); if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["MailPassword"])) { smtpClient.EnableSsl = true; smtpClient.Credentials = new NetworkCredential(ConfigurationManager.AppSettings["SupportEmail"], ConfigurationManager.AppSettings["MailPassword"]); } try { smtpClient.Send(PwReminderEmail); } catch (Exception exception) { response.Message = exception.Message; } response.IsSuccess = (String.IsNullOrEmpty(response.Message)) ? true : false; response.Message = (String.IsNullOrEmpty(response.Message)) ? "We have sent your password on your registered email." : ""; } else { response.LoginResult = LoginResultType.EmailNotFound; response.Message = "Could not find an account with this email address."; } } } catch (Exception ex) { response.LoginResult = LoginResultType.InvalidLogin; response.ResponseData = null; response.Message = ex.Message; } return(response); }