public static string UpdateTrashCan(string lastUserName, string newUserName, string lastName, string password, string longitude, string latitude, string currentTrash, string wishTrash) { var lastTrashCanValues = AdminDAL.TrashCansList().FirstOrDefault(val => val.UserName == lastUserName); TrashCan tc = new TrashCan { UserName = newUserName, LastName = lastName, Password = password != "" ? GenerateSHA512String(password) : lastTrashCanValues.Password, Longitude = longitude, Latitude = latitude, CurrentTrash = currentTrash, WishTrash = wishTrash }; return(new JavaScriptSerializer().Serialize(AdminDAL.UpdateTrashCan(lastUserName, tc))); }
public GetIncidentDataResponse GetIncidentData(GetIncidentData objGetIncidentDataRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetIncidentDataResponse ret = new GetIncidentDataResponse(); List <UserIncident> lst = objAdminDAL.GetIncidentData(objGetIncidentDataRequest); ret.Incident = lst; return(ret); } catch (Exception ex) { throw ex; } }
public int createAccount(Person person, Credentials credentials, Account account) { AdminDAL dal = new AdminDAL(); int accountNo = ATMDAL.getLastNumber("account.csv") + 1; int personID = ATMDAL.getLastNumber("users.csv") + 1; person.id = personID; credentials.ID = personID; person.accountNo = accountNo; account.ID = person.accountNo; credentials.Password = Authentication.encryption(credentials.Password); dal.savePerson(person); dal.saveCredentials(credentials); dal.saveAccount(account); return(accountNo); }
public GetLocationDataResponse GetLocationData(GetLocationData objGetLocationDataRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetLocationDataResponse ret = new GetLocationDataResponse(); List <LocationData> lst = objAdminDAL.GetLocationData(objGetLocationDataRequest); ret.Location = lst; return(ret); } catch (Exception ex) { throw ex; } }
public GetPenaltyClauseResponse GetPenaltyClausetData(GetPenaltyClauseData objGetPenaltyClauseDataRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetPenaltyClauseResponse ret = new GetPenaltyClauseResponse(); List <PenaltyClause> lst = objAdminDAL.GetPenaltyClauseData(objGetPenaltyClauseDataRequest); ret.Penalty = lst; return(ret); } catch (Exception ex) { throw ex; } }
public GetUserDataResponse GetUserStaffInfo1(GetUserData objGetUserInfoDataRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetUserDataResponse ret = new GetUserDataResponse(); List <User_Info> lst = objAdminDAL.GetUserStaffInfo1(objGetUserInfoDataRequest); ret.Staff_ID = lst; return(ret); } catch (Exception ex) { throw ex; } }
public GetAlertDataResponse GetAlertData(GetAlertData objGetAlertDataRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetAlertDataResponse ret = new GetAlertDataResponse(); List <AlertHandlingUser> lst = objAdminDAL.GetAlertData(objGetAlertDataRequest); ret.Alert_ID = lst; return(ret); } catch (Exception ex) { throw ex; } }
public GetClientVisitResponse GetClientVisitData(GetClientVisitMinutesData objGetClientVisitMinutesDataRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetClientVisitResponse ret = new GetClientVisitResponse(); List <ClientVisitMinutes> lst = objAdminDAL.GetClientVisitMinutesData(objGetClientVisitMinutesDataRequest); ret.Visit = lst; return(ret); } catch (Exception ex) { throw ex; } }
public GetInventoryResponce GetInventoryData(GetInventoryData objGetItemDataRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetInventoryResponce ret = new GetInventoryResponce(); List <AddNewInventory> lst = objAdminDAL.GetIenvenData(objGetItemDataRequest); ret.Itemid = lst; return(ret); } catch (Exception ex) { throw ex; } }
public GetTrainingResponse GetTrainingData(GetTrainingData objGetTrainingRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetTrainingResponse ret = new GetTrainingResponse(); List <AddTraining> lst = objAdminDAL.GetTrainingData(objGetTrainingRequest); ret.Trainingid = lst; return(ret); } catch (Exception ex) { throw ex; } }
public ActionResult MyInfo() { if (verifyAdmin() == false) { TempData["WarningMessage"] = "Don't go to places you are not allowed."; return(RedirectToAction("LogOut", "Home")); } AdminDAL admDAL = new AdminDAL(); var tempID = Session["AdminLoggedIn"].ToString(); List <Admin> admins = (from x in admDAL.Admins where x.userName.Equals(tempID) select x).ToList <Admin>(); VMAdmin myAdmins = new VMAdmin(); myAdmins.Admins = admins; //ViewBag.TempDoc = doc; return(View(myAdmins)); }
public static bool AdminLogInBL(Admin admin) { bool adminLoggedIn = false; try { AdminDAL adminDAL = new AdminDAL(); adminLoggedIn = adminDAL.AdminLogInDAL(admin); } catch (Exception ex) { throw new PecuniaException(ex.Message); } return(adminLoggedIn); }
protected void imdAdd_Click(object sender, EventArgs e) { SpaMaster MyMasterPage = (SpaMaster)Page.Master; DataTable dtViewItems = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "96"); if (dtViewItems.Rows.Count > 0) { ModalPopupAdd.Show(); } else { MyMasterPage.ShowErrorMessage("You Do not Have Permission..!"); } }
public GetContractorDataResponse GetStaffData1(GetContractorData objGetContractorDataRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetContractorDataResponse ret = new GetContractorDataResponse(); List <Contractor> lst = objAdminDAL.GetStaffData1(objGetContractorDataRequest); ret.Contractor = lst; return(ret); } catch (Exception ex) { throw ex; } }
public static List <CouponInfo> GetAllCoupon() { List <CouponInfo> couponList = new List <CouponInfo>(); List <CouponItems> couponItemList = new List <CouponItems>(); using (SqlDataReader reader = AdminDAL.GetCoupon(0)) { while (reader.Read()) { CouponItems item = new CouponItems(); item.CouponId = Convert.ToInt32(reader["CouponId"]); item.SkuId = Convert.ToInt32(reader["SkuId"]); item.RelatedSkuId = Convert.ToInt32(reader["RelatedSkuId"]); item.DiscountAmount = Convert.ToDecimal(reader["DiscountAmount"]); item.DiscountType = (CouponTypeEnum)Convert.ToInt32(reader["DiscountType"]); couponItemList.Add(item); } reader.NextResult(); while (reader.Read()) { CouponInfo itemInfo = new CouponInfo(); itemInfo.CouponId = Convert.ToInt32(reader["CouponId"]); itemInfo.Title = reader["Title"].ToString(); itemInfo.Discount = Convert.ToDecimal(reader["Discount"]); itemInfo.Active = Convert.ToBoolean(reader["active"]); itemInfo.DiscountType = (CouponTypeEnum)Convert.ToInt32(reader["DiscountType"]); itemInfo.TotalAmount = Convert.ToDecimal(reader["TotalAmount"]); if (Convert.ToInt32(reader["DiscountType"]) == (int)CouponTypeEnum.ItemType) { itemInfo.ItemsDiscount = couponItemList.FindAll(x => x.CouponId == Convert.ToInt32(reader["CouponId"])); } if (reader["includeShipping"] != DBNull.Value) { itemInfo.IncludeShipping = Convert.ToBoolean(reader["includeShipping"]); } else { itemInfo.IncludeShipping = true; } couponList.Add(itemInfo); } } return(couponList); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { //services.AddMvc(); string ConnStr = Configuration.GetSection("ConnStr").Value; AdminDAL admin = new AdminDAL(ConnStr); services.AddSingleton <AdminDAL>(admin); BlogDAL blog = new BlogDAL(ConnStr); services.AddSingleton <BlogDAL>(blog); CategoryDAL category = new CategoryDAL(ConnStr); services.AddSingleton <CategoryDAL>(category); services.AddMvc().SetCompatibilityVersion(Microsoft.AspNetCore.Mvc.CompatibilityVersion.Version_2_2); services.AddSession(); services.AddDistributedMemoryCache(); }
public static string InsertAdmin(string id, string name, string lastName, string password) { var existingAdmin = AdminDAL.AdminsList().FirstOrDefault(val => val.ID == id); if (existingAdmin == null) { Admin admin = new Admin { ID = id, Name = name, LastName = lastName, Password = GenerateSHA512String(password) }; return(new JavaScriptSerializer().Serialize(AdminDAL.InsertAdmin(admin))); } return("0"); }
public void DeleteSubcategory_deletes_subcategory() { var und1 = new Undercategory { Id = 22, Instruks_Veiledning = new Instruks_Veiledning { Id = 15, Inskruks_beskrivelse = "Text original 3" } }; var und2 = new Undercategory { Id = 33, Instruks_Veiledning = new Instruks_Veiledning { Id = 16, Inskruks_beskrivelse = "Text original 5" } }; var underCategories = new List <Undercategory> { und1, und2 }.AsQueryable(); var catMock = new Mock <DbSet <Undercategory> >(); catMock.As <IQueryable <Undercategory> >().Setup(m => m.Provider).Returns(underCategories.Provider); catMock.As <IQueryable <Undercategory> >().Setup(m => m.Expression).Returns(underCategories.Expression); catMock.As <IQueryable <Undercategory> >().Setup(m => m.ElementType).Returns(underCategories.ElementType); catMock.As <IQueryable <Undercategory> >().Setup(m => m.GetEnumerator()).Returns(() => underCategories.GetEnumerator()); var instruksMock = new Mock <DbSet <Instruks_Veiledning> >(); var dbMock = new Mock <SvarbotDbSys>(); dbMock.Setup(x => x.Undercategory).Returns(catMock.Object); dbMock.Setup(x => x.Instruks_Veiledning).Returns(instruksMock.Object); var dalObject = new AdminDAL(dbMock.Object); dalObject.DeleteSubcategory(22); catMock.Verify(x => x.Remove(It.Is <Undercategory>(u => u.Id == 22)), Times.Once); instruksMock.Verify(x => x.Remove(It.Is <Instruks_Veiledning>(i => i.Id == 15)), Times.Once); }
public void GetAllUsernamesCasesList_gets_users_and_their_case_count() { var forms = new List <Form> { new Form { Id = 1, Navn = "testuser1" }, new Form { Id = 2, Navn = "testuser2" }, new Form { Id = 3, Navn = "testuser1" } }.AsQueryable(); var formsMock = new Mock <DbSet <Form> >(); SetupMockLinq(forms, formsMock); var accounts = new List <Accounts> { new Accounts { navn = "testuser1" }, new Accounts { navn = "testuser2" }, new Accounts { navn = "testuser3" } }.AsQueryable(); var accountsMock = new Mock <DbSet <Accounts> >(); SetupMockLinq(accounts, accountsMock); var dbMock = new Mock <SvarbotDbSys>(); dbMock.Setup(x => x.Form).Returns(formsMock.Object); dbMock.Setup(x => x.Accounts).Returns(accountsMock.Object); var dalObject = new AdminDAL(dbMock.Object); var result = dalObject.GetAllUsernamesCasesList(); Assert.AreEqual(2, result.Count); Assert.AreEqual(2, result.Single(x => x.UserName == "testuser1").CaseCount); Assert.AreEqual(1, result.Single(x => x.UserName == "testuser2").CaseCount); }
protected void imgUpdate_Click(object sender, EventArgs e) { try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; DataTable dtViewInventory = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "63"); if (dtViewInventory.Rows.Count > 0) { if (ViewState["Item_Id"] != null) { PopulatePageCntrls(ViewState["Item_Id"].ToString()); ModalPopupUpdate.Show(); } //int flag = 0; //foreach (GridDataItem row in RadGridCatalog.MasterTableView.Items) //{ // CheckBox chk1 = (CheckBox)row.FindControl("CheckBox1"); // int index = row.ItemIndex; // if (chk1.Checked == true) // { // flag = 1; // break; // } //} //if (flag == 1) //{ // PopulatePageCntrls(ViewState["Item_Id"].ToString()); // ModalPopupUpdate.Show(); //} //else { // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Please select item in the check box.');", true); //} } else { MyMasterPage.ShowErrorMessage("You Do Not Have Permission..!"); } } catch (Exception ex) { } }
/// <summary> /// 添加管理员 /// </summary> /// <param name="model"></param> /// <returns></returns> public static UserResult Add(AdminModel model) { UserResult result = new UserResult(); // 检查输入是否合法 if (!CheckName(model.Name)) { result.HasError = true; result.ErrorMessage = "用户名格式错误。"; result.Message = "name"; return(result); } if (AdminDAL.CheckEqualName(model.Name)) { result.HasError = true; result.ErrorMessage = "用户名重复"; result.Message = "name"; return(result); } if (!CheckPassword(model.Pass)) { result.HasError = true; result.ErrorMessage = "密码格式错误。"; result.Message = "password"; return(result); } //调用加密密码 model.Pass = Encrypt(model.Pass); // 调用数据层保存 int res = AdminDAL.Add(model); if (res > 0) { result.HasError = false; return(result); } else { result.HasError = true; result.ErrorMessage = "添加失败!"; return(result); } }
private void DeleteSOP(string argSOPId) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { if (!string.IsNullOrEmpty(argSOPId)) { AdminBLL ws = new AdminBLL(); AdminDAL w = new AdminDAL(); SqlConnection conn = new SqlConnection(); conn = w.getconnection(); DeleteSOPRequest _req = new DeleteSOPRequest(); _req.SOP_ID = argSOPId.ToString(); string id = argSOPId.ToString(); string query = "select top 1 ImagePathName from SOP_Master name where SOP_ID='" + id + "'"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader rd = cmd.ExecuteReader(); string s = string.Empty; while (rd.Read()) { s = rd.GetValue(0).ToString(); } FileInfo TheFile = new FileInfo(MapPath("../FileUpload/") + "\\" + s); if (TheFile.Exists) { File.Delete(MapPath("../FileUpload/") + "\\" + s); } ws.DeleteSOP(_req); // HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "DELETE"); // Server.Transfer("AlertUpdateComplete.aspx"); BindGridWithFilter(); } } catch (Exception ex) { logger.Info(ex.Message); } }
public void GetCategoriesWithCases_get_categories_joined_with_cases() { var categories = new List <Categories> { new Categories { Id = 222, Category_name = "cat1" }, new Categories { Id = 333, Category_name = "cat2" }, new Categories { Id = 444, Category_name = "cat3" } }.AsQueryable(); var catMock = new Mock <DbSet <Categories> >(); SetupMockLinq(categories, catMock); var forms = new List <Form> { new Form { Id = 1, CategoryId = 333 }, new Form { Id = 2, CategoryId = 444 }, new Form { Id = 3, CategoryId = 333 } }.AsQueryable(); var formsMock = new Mock <DbSet <Form> >(); SetupMockLinq(forms, formsMock); var dbMock = new Mock <SvarbotDbSys>(); dbMock.Setup(x => x.Categories).Returns(catMock.Object); dbMock.Setup(x => x.Form).Returns(formsMock.Object); var dalObject = new AdminDAL(dbMock.Object); var result = dalObject.GetCategoriesWithCases(); Assert.AreEqual(2, result.Count); Assert.AreEqual(2, result.Single(x => x.CategoryId == 333).CasesPerCategory); Assert.AreEqual(1, result.Single(x => x.CategoryId == 444).CasesPerCategory); }
// GET: Admin/Edit/5 public ActionResult Edit(long id) { Admin adm = new Admin(); AdminModel model = new AdminModel(); AdminDAL admDAL = new AdminDAL(); adm = admDAL.ShowCustomerByAccNo(id, adm); TempData["id"] = id; model.Account_No = adm.Account_No; model.Account_Name = adm.Account_Name; model.Mobile_No = adm.Mobile_No; model.Email = adm.Email; model.Address = adm.Address; model.Bank_Branch = adm.Bank_Branch; model.IFSC = adm.IFSC; return(View(model)); }
public static EmailSetting GetEmail(int emailId) { EmailSetting emailTemplate = new EmailSetting(); using (SqlDataReader reader = AdminDAL.GetAllEmailList(emailId)) { while (reader.Read()) { emailTemplate.EmailId = Convert.ToInt32(reader["EmailId"].ToString()); emailTemplate.Title = reader["Title"].ToString(); emailTemplate.Subject = reader["Subject"].ToString(); emailTemplate.Body = reader["Body"].ToString(); emailTemplate.FromAddress = reader["FromAddress"].ToString(); emailTemplate.ToAddress = reader["ToAddress"].ToString(); } } return(emailTemplate); }
protected void ImgDelete_Click(object sender, EventArgs e) { SpaMaster MyMasterPage = (SpaMaster)Page.Master; DataTable dtViewSOP = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "105"); if (dtViewSOP.Rows.Count > 0) { if (ViewState["SOP_ID"] != null) { this.ModalPopupDelete.Show(); } } else { MyMasterPage.ShowErrorMessage("You Do Not Have Permission..!"); } }
public async Task <ActionResult> RoleEdit(int id) { if (id > 0) { var role = await AdminDAL.GetRoleById(id); // Get role info if (role == null) { return(HttpNotFound()); } RoleViewModel roleModel = new RoleViewModel { Id = role.Id, Name = role.Name, Description = role.Description }; return(View(roleModel)); } return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); }
/// <summary> /// 根据条件查询账号 /// </summary> /// <returns></returns> public static List <AdminVM> SearchAdmin(string account, string name, string phone, string email, DateTime beginTime, DateTime endTime, int pageIndex, int pageSize, out int totalCount) { var expression = PredicateBuilder.True <Admin>(); expression = expression.And(m => m.IsDeleted == false); if (!string.IsNullOrEmpty(account)) { expression = expression.And(m => m.Account.Contains(account)); } if (!string.IsNullOrEmpty(name)) { expression = expression.And(m => m.Name.Contains(name)); } if (!string.IsNullOrEmpty(phone)) { expression = expression.And(m => m.Phone.Contains(phone)); } if (!string.IsNullOrEmpty(email)) { expression = expression.And(m => m.Email.Contains(email)); } if (!beginTime.Equals(DateTime.MinValue)) { expression = expression.And(m => m.CreatedTime >= beginTime); } if (!endTime.Equals(DateTime.MinValue)) { endTime = endTime.AddDays(1); expression = expression.And(m => m.CreatedTime <= endTime); } List <Admin> adminsList = AdminDAL.SearchByConditions(expression, pageIndex, pageSize, out totalCount); if (adminsList != null && adminsList.Count > 0) { List <AdminVM> adminVMList = new List <AdminVM>(); foreach (var item in adminsList) { AdminVM adminVM = TransferToAdminVM(item); adminVMList.Add(adminVM); } return(adminVMList); } return(null); }
public static List <FulfillmentHouseProviderSetting> GetAllProvidersFromDB(bool activeList) { List <FulfillmentHouseProviderSetting> providerList = new List <FulfillmentHouseProviderSetting>(); using (SqlDataReader reader = AdminDAL.GetAllFulfillmentHouseProviders(activeList)) { while (reader.Read()) { FulfillmentHouseProviderSetting item = new FulfillmentHouseProviderSetting(); item.ProviderID = (int)reader["ProviderId"]; item.Title = reader["ProviderName"].ToString(); item.ProviderXML = reader["ProviderXml"].ToString(); item.Active = Convert.ToBoolean(reader["Active"]); item.IsDefault = Convert.ToBoolean(reader["IsDefault"]); providerList.Add(item); } } return(providerList); }
/// <summary> /// Seriliaze the object to XML for Database Commitement /// </summary> /// <param name="States"></param> public static void SaveStates(List <StateProvince> States) { XElement rootNode = new XElement("root"); foreach (StateProvince itm in States) { XElement xElem = new XElement("item", new XAttribute("Id", itm.StateProvinceId.ToString()), new XAttribute("Name", itm.Name), new XAttribute("Code", itm.Abbreviation), new XAttribute("CountryId", itm.CountryId), new XAttribute("OrderNo", itm.DisplayOrder), new XAttribute("Visible", (itm.Visible) ? 1:0) ); rootNode.Add(xElem); } AdminDAL.SaveStates(rootNode.ToString()); }