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());
}
