public void GetData()
{
GenericRepository<t_loan_lead> loan = new GenericRepository<t_loan_lead>(new sherlockEntities());
loan.GetAll();
GenericRepository<t_life_lead> life = new GenericRepository<t_life_lead>(new sherlockEntities());
life.GetAll();
GenericRepository<t_asu_lead> asu = new GenericRepository<t_asu_lead>(new sherlockEntities());
asu.GetAll();
GenericRepository<t_debt_lead> debt = new GenericRepository<t_debt_lead>(new sherlockEntities());
debt.GetAll();
GenericRepository<t_equityrelease_lead> equityrelease = new GenericRepository<t_equityrelease_lead>(new sherlockEntities());
equityrelease.GetAll();
GenericRepository<t_logbookloan_lead> logbookloan = new GenericRepository<t_logbookloan_lead>(new sherlockEntities());
logbookloan.GetAll();
GenericRepository<t_mortgage_lead> mortgage = new GenericRepository<t_mortgage_lead>(new sherlockEntities());
mortgage.GetAll();
GenericRepository<t_pmi_lead> pmi = new GenericRepository<t_pmi_lead>(new sherlockEntities());
pmi.GetAll();
GenericRepository<t_ppi_lead> ppi = new GenericRepository<t_ppi_lead>(new sherlockEntities());
ppi.GetAll();
GenericRepository<t_sme_mi_lead> sme_mi = new GenericRepository<t_sme_mi_lead>(new sherlockEntities());
sme_mi.GetAll();
GenericRepository<t_solar_lead> solar = new GenericRepository<t_solar_lead>(new sherlockEntities());
solar.GetAll();
}
public Form1()
{
InitializeComponent();
_repository = new GenericRepository<Word>();
_words = _repository.GetAll().ToList();
this.LoadGrid();
}
private DbLookup()
{
IRepository repository = new GenericRepository(new SmartGatewayEntities());
IEnumerable<GatewayConfig> gcList = repository.GetAll<GatewayConfig>().OrderBy(gc=>gc.Id);
List<string> names = new List<string>();
foreach (GatewayConfig c in gcList)
{
names.Add(c.Id);
}
Channels = new SelectList(names);
}
public ActionResult Index()
{
var books = db.GetAll(y => y.Category).ToList();
return(View(books));
}
public IQueryable <QuotationServiceType> GetAllQuotationServices()
{
return(_genericRepository.GetAll());
}
public IEnumerable <CityMaster> GetAllCities()
{
IEnumerable <CityMaster> Allcities = cityMasterRepository.GetAll().ToList();
return(Allcities);
}
public async Task <List <Project> > GetAllProjects()
{
List <Project> projects = await GenericRepository.GetAll();
return(projects);
}
public ActionResult Index()
{
var listProduct = _product.GetAll().AsQueryable().Include(x => x.Categorie);
return(View(listProduct));
}
private static void ExportGirlsFromMSSqlToMySql(GenericRepository<Girl> sqlGirlsRepo, GenericRepository<Girl> mySqlGirlsRepo)
{
var girlsFromMSsql = sqlGirlsRepo.GetAll().ToList();
foreach (var girlFromMSsql in girlsFromMSsql.ToList())
{
var girl = new Girl()
{
FirstName = girlFromMSsql.FirstName,
LastName = girlFromMSsql.LastName,
Age = girlFromMSsql.Age,
BreastSizeId = girlFromMSsql.BreastSizeId,
HairColorId = girlFromMSsql.HairColorId,
CityId = girlFromMSsql.CityId,
PricePerHour = girlFromMSsql.PricePerHour,
Features = girlFromMSsql.Features,
CountyId = girlFromMSsql.CountyId,
// City = girlFromMSsql.City,
// Country = girlFromMSsql.Country
};
mySqlGirlsRepo.Add(girl);
mySqlGirlsRepo.SaveChanges();
}
}
private static void ExportCitiesFromMSSqlToMySQL(GenericRepository<City> sqlCitiesRepo, GenericRepository<City> mySqlCitiesRepo)
{
var mysqlCountries = new GenericRepository<Country>(new GirlAgencyMySql.Data.MySql());
var citiesFromMSsql = sqlCitiesRepo.GetAll().ToList();
foreach (var cityFromMSsql in citiesFromMSsql.ToList())
{
var city = new City()
{
Name = cityFromMSsql.Name,
CountryId = mysqlCountries.
GetAll()
.FirstOrDefault(n => n.CountryId == cityFromMSsql.CountryId).CountryId
};
mySqlCitiesRepo.Add(city);
mySqlCitiesRepo.SaveChanges();
}
}
// GET: Sport
public ActionResult Index()
{
var result = macthRepo.GetAll().Where(m => m.Bets.Count != 0 && m.StartDate >= DateTime.Now && m.StartDate <= DateTime.Now.AddDays(1));
return(View(result));
}
public IEnumerable <Provider> GetAllProviders()
{
return(_providerRepository.GetAll());
}
public async Task <IActionResult> GetAll()
{
return(Ok(await _repository.GetAll()));
}
public List <Sale> GetSales()
{
return(repo.GetAll().Include(s => s.cart).Include(s => s.payment).ToList());
}
List <Ilce> IlceGetir(int id)
{
var cariIlce1 = new GenericRepository <Ilce>(new OtoContext());
return(cariIlce1.GetAll().Where(i => i.Ilid == id).ToList());
}
public ActionResult Create()
{
ViewBag.CategoryId = new SelectList(_category.GetAll(), "Id", "Name");
ViewBag.TypeAttribute = _typeAttribute.GetAll().AsQueryable().Include(x => x.Attributes).AsEnumerable();
return(View());
}
public IEnumerable <Country> GetAllCountrys()
{
IEnumerable <Country> Countrys = countryRepository.GetAll().ToList();
return(Countrys);
}
public void GetAll_Must_Return_All()
{
//
// Arrange
//
var models = Enumerable.Range(1, 10).Select(x =>
{
var mockModel = new Mock<IModel>();
mockModel.Setup(y => y.Id).Returns(x);
return mockModel.Object;
}).AsQueryable();
var mockDbSet = new Mock<DbSet<IModel>>();
mockDbSet.As<IQueryable<IModel>>().Setup(m => m.Provider).Returns(models.Provider);
mockDbSet.As<IQueryable<IModel>>().Setup(m => m.Expression).Returns(models.Expression);
mockDbSet.As<IQueryable<IModel>>().Setup(m => m.ElementType).Returns(models.ElementType);
mockDbSet.As<IQueryable<IModel>>().Setup(m => m.GetEnumerator()).Returns(models.GetEnumerator());
var mockContext = new Mock<EFDbContext>();
mockContext.Setup(x => x.Set<IModel>()).Returns(mockDbSet.Object);
var repository = new GenericRepository<IModel>(mockContext.Object);
//
// Act
//
var results = repository.GetAll();
//
// Assert
//
Assert.IsNotNull(results);
Assert.IsNotNull(results.First());
Assert.AreEqual(10, results.Count());
Assert.AreEqual(1, results.First().Id);
}
public IEnumerable <RoleViewModel> GetAll()
{
return(RoleRepo.GetAll().ToList().Select(i => i.toViewModel()));
}
private static void ExportCustomerFromMSSqlToMySQL()
{
var mssqlClients = new GenericRepository<Customer>(new GirlsAgencyContext());
var girlsMySql = new GenericRepository<Girl>(new GirlAgencyMySql.Data.MySql());
var mysqlClients = new GenericRepository<Customer>(new GirlAgencyMySql.Data.MySql());
foreach (var mssqlCustomer in mssqlClients.GetAll().ToList())
{
var customer = new Customer()
{
CityId = mssqlCustomer.CityId,
CountryId = mssqlCustomer.CountryId,
FirstName = mssqlCustomer.FirstName,
LastName = mssqlCustomer.LastName,
Girls = GetGirls(mssqlCustomer, girlsMySql)
};
mysqlClients.Add(customer);
}
mysqlClients.SaveChanges();
}
public IEnumerable <UserMaster> GetAllUsers()
{
IEnumerable <UserMaster> users = userMasterRepository.GetAll().ToList();
return(users);
}
private static ICollection<Girl> GetGirls(Customer mssqlCustomer, GenericRepository<Girl> girlsMySql)
{
var girls = new List<Girl>();
foreach (var girl in mssqlCustomer.Girls)
{
var girlInDb = girlsMySql
.GetAll()
.Where(n => n.FirstName == girl.FirstName && n.LastName == girl.LastName)
.FirstOrDefault();
girls.Add(girlInDb);
}
return girls;
}
public IEnumerable <Setting> GetAllSettings()
{
IEnumerable <Setting> Settings = SettingRepository.GetAll().ToList();
return(Settings);
}
public async Task <List <Project> > GetProjectsByUserIdAsync(string userId)
{
List <Project> projects = await GenericRepository.GetAll(p => p.UsersInProject.Any(u => u.Id.Equals(userId)));
return(projects);
}
public List <TestTable> testDB()
{
return(_testTables.GetAll().ToList());
}
public IEnumerable <Godown> GetAllGodowns()
{
IEnumerable <Godown> Godowns = godownRepository.GetAll().ToList();
return(Godowns);
}
public ActionResult Index()
{
var business = _business.GetAll();
return(View(business));
}
public void WriteDataToDataBaseFromFile(string fileName)
{
lock (_lockObject)
{
_managerRepo = new GenericRepository <Manager>(new AppDbContext(_nameOrConnectionString));
}
var fileNameWithoutExtension = Path.GetFileNameWithoutExtension(fileName);
if (fileNameWithoutExtension == null)
{
return;
}
var splittedFileName = fileNameWithoutExtension.Split('_');
var managerName = splittedFileName[0];
var managerDate = splittedFileName[1];
var purchaseDto = new PurchaseDto()
{
ManagerName = managerName,
Date = DateTime.ParseExact(managerDate, "ddMMyyyy", System.Globalization.CultureInfo.InvariantCulture),
};
using (var reader = new StreamReader(fileName))
{
string line;
while ((line = reader.ReadLine()) != null)
{
var lineContent = line.Split(',');
purchaseDto.ClientName = lineContent[0].Trim();
purchaseDto.ProductName = lineContent[1].Trim();
purchaseDto.Price = decimal.Parse(lineContent[2].Trim());
Mapper.Initialize(cfg =>
{
cfg.CreateMap <PurchaseDto, Product>()
.ForMember(x => x.Name, opt => opt.MapFrom(src => src.ProductName))
.ForMember(x => x.Date, opt => opt.MapFrom(src => src.Date))
.ForMember(x => x.Client, opt => opt.MapFrom(src => src.ClientName))
.ForMember(x => x.Price, opt => opt.MapFrom(src => src.Price));
cfg.CreateMap <PurchaseDto, Manager>()
.ForMember(x => x.LastName, opt => opt.MapFrom(src => src.ManagerName));
});
var product = Mapper.Map <PurchaseDto, Product>(purchaseDto);
lock (_lockObject)
{
var manager = _managerRepo.GetAll().FirstOrDefault(x => x.LastName == purchaseDto.ManagerName);
if (manager == null)
{
manager = Mapper.Map <PurchaseDto, Manager>(purchaseDto);
manager.Products.Add(product);
_managerRepo.Create(manager);
}
else
{
manager.Products.Add(product);
_managerRepo.Update(manager);
}
_managerRepo.Save();
}
}
}
}
public IEnumerable <ResturantImageViewModel> GetAll()
{
return(ResturantImageRepo.GetAll().ToList().Select(i => i.toViewModel()));
}
public IEnumerable <AdminViewModel> GetAll()
{
return(AdminRepo.GetAll().ToList().Select(i => i.toViewModel()));
}
public IEnumerable <UserViewModel> GetAll()
{
return(UserRepo.GetAll().ToList().Select(i => i.toViewModel()));
}
public IEnumerable <SizeViewModel> GetAll()
{
return(SizeRepo.GetAll().ToList().Select(i => i.ToViewModel()));
}
public ActionResult ObterListaGenerica()
{
var lista = genericRepository.GetAll();
return(View("Index", lista));
}
public IEnumerable <BenificiaryMaster> GetAllBenificiaries()
{
IEnumerable <BenificiaryMaster> benificiaries = benificiaryMasterRepository.GetAll().ToList();
return(benificiaries);
}
private void Dispatch(Packages package)
{
if (Order.StatusCode.Value.Equals((int)OrderStatusCode.InProcess) && Order.PaymentStatus.Equals((int)OrderPaymentStatus.Charged))
{
ThreadTask threadTask = new ThreadTask(string.Format("訂單下載 - 自動提交訂單【{0}】至待出貨區", Order.OrderID), Session);
MyHelp.Log("Orders", Order.OrderID, string.Format("訂單下載 - 自動提交訂單【{0}】至待出貨區", Order.OrderID), Session);
package.ProcessStatus = (int)EnumData.ProcessStatus.鎖定中;
Packages.Update(package, package.ID);
lock (Factory)
{
threadTask.AddWork(Factory.StartNew(Session =>
{
threadTask.Start();
string message = "";
using (QDLogisticsEntities db = new QDLogisticsEntities())
{
IRepository <Packages> Packages = new GenericRepository <Packages>(db);
IRepository <PickProduct> PickProduct = new GenericRepository <PickProduct>(db);
Packages packageData = Packages.Get(package.ID);
try
{
HttpSessionStateBase session = (HttpSessionStateBase)Session;
SC_WebService SCWS = new SC_WebService("*****@*****.**", "timfromweypro");
if (!SCWS.Is_login)
{
throw new Exception("SC is not login");
}
OrderStateInfo order = SCWS.Get_OrderStatus(packageData.OrderID.Value);
if ((int)order.PaymentStatus == package.Orders.PaymentStatus)
{
ShipProcess shipProcess = new ShipProcess(SCWS);
MyHelp.Log("Orders", packageData.OrderID, "提交至待出貨區", session);
/***** 上傳Item出貨倉 *****/
var SC_order = SCWS.Get_OrderData(packageData.OrderID.Value).Order;
var SC_items = SC_order.Items.Where(i => i.PackageID.Equals(packageData.ID)).ToArray();
foreach (var item in SC_items)
{
if (!db.Skus.AsNoTracking().Any(s => s.Sku.Equals(item.ProductID)))
{
throw new Exception(string.Format("系統尚未有品號 {0} 資料!", item.ProductID));
}
item.ShipFromWareHouseID = packageData.Items.First(i => i.IsEnable == true && i.ID == item.ID).ShipFromWarehouseID.Value;
SCWS.Update_OrderItem(SC_items.First(i => i.ID.Equals(item.ID)));
}
MyHelp.Log("Orders", packageData.OrderID, "更新訂單包裹的出貨倉", session);
/***** 更新客戶地址 *****/
var address = SC_order.ShippingAddress;
DataProcess.SetAddressData(packageData.Orders.Addresses, address, SC_order.BillingAddress);
/***** 檢查運送國家 *****/
if (!string.IsNullOrEmpty(packageData.Method.CountryData))
{
var countryData = JsonConvert.DeserializeObject <Dictionary <string, bool> >(packageData.Method.CountryData);
if (!countryData.ContainsKey(packageData.Orders.Addresses.CountryCode.ToUpper()))
{
throw new Exception(string.Format("訂單【{0}】國家名稱不合，請重新確認", packageData.OrderID));
}
if (!countryData[packageData.Orders.Addresses.CountryCode.ToUpper()])
{
throw new Exception(string.Format("訂單【{0}】不可寄送至國家{1}", packageData.OrderID, packageData.Orders.Addresses.CountryName));
}
}
shipProcess.Init(packageData);
var result = shipProcess.Dispatch();
if (result.Status)
{
MyHelp.Log("Orders", packageData.OrderID, "訂單提交完成", session);
if (packageData.Items.First(i => i.IsEnable.Value).ShipWarehouses.Name.Equals("TWN"))
{
int[] itemIDs = packageData.Items.Where(i => i.IsEnable.Value).Select(i => i.ID).ToArray();
List <PickProduct> pickList = PickProduct.GetAll(true).Where(p => itemIDs.Contains(p.ItemID.Value)).ToList();
foreach (Items item in packageData.Items.Where(i => i.IsEnable == true))
{
PickProduct pick = pickList.FirstOrDefault(pk => pk.ItemID == item.ID);
if (pick != null)
{
pick.IsEnable = true;
pick.IsPicked = false;
pick.IsMail = false;
pick.QtyPicked = 0;
DataProcess.setPickProductData(pick, item);
PickProduct.Update(pick, pick.ID);
}
else
{
pick = new PickProduct()
{
IsEnable = true
};
DataProcess.setPickProductData(pick, item);
PickProduct.Create(pick);
}
}
PickProduct.SaveChanges();
}
packageData.ProcessStatus = (int)EnumData.ProcessStatus.待出貨;
}
else
{
message = result.Message;
packageData.ProcessStatus = (int)EnumData.ProcessStatus.訂單管理;
}
}
else
{
message = "Payment status is different";
packageData.Orders.StatusCode = (int)OrderStatusCode.OnHold;
packageData.ProcessStatus = (int)EnumData.ProcessStatus.訂單管理;
}
Packages.Update(packageData, packageData.ID);
Packages.SaveChanges();
}
catch (Exception e)
{
message = e.InnerException != null && !string.IsNullOrEmpty(e.InnerException.Message) ? e.InnerException.Message : e.Message;
packageData.ProcessStatus = (int)EnumData.ProcessStatus.訂單管理;
if (!string.IsNullOrEmpty(package.WinitNo))
{
Winit_API winit = new Winit_API();
winit.CancelOutboundOrder(package.WinitNo);
package.WinitNo = null;
}
Packages.Update(packageData, packageData.ID);
Packages.SaveChanges();
}
}
return(message);
}, Session));
}
}
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (filterContext == null)
{
throw new ArgumentNullException("filterContext");
}
string path = filterContext.HttpContext.Request.Path.ToLower();
if (path == "/" || path == "/Login/Index".ToLower() || path == "/Login/Login".ToLower()
|| path == "/Login/GetValidateCode".ToLower())
{
return; //忽略权限判定
}
if (!CheckLogin(filterContext))
{
string rawUrl = filterContext.HttpContext.Request.RawUrl;
string allUrl = filterContext.HttpContext.Request.Url.ToString();
int index = allUrl.IndexOf(rawUrl);
string url = allUrl.Substring(0, index);
if (filterContext.HttpContext.Request.IsAjaxRequest())
{
filterContext.HttpContext.Response.StatusCode = 499; //尽量不要与现有的Http状态码冲突
}
filterContext.Result = new ContentResult
{
Content =
"<script language =\"javascript\" type =\"text/javascript\" >alert(\"登录超时!\");window.top.location.href = \"" +
url + "/Login/Index\";</script>"
};
}
else
{
string roleCode = filterContext.HttpContext.Session["UiRoles"].ToString();
if (_list.Count == 0)
{
Guid id = Guid.Parse(roleCode);
using (IRoleManager iRoleManager = new RoleManager())
{
Role role = iRoleManager.GetById(id);
if (role != null)
{
using (
IGenericRepository<ResourceRole> iResourceRoleRepository =
new GenericRepository<ResourceRole>())
{
IList<ResourceRole> reRl = iResourceRoleRepository.SearchFor(p => p.RlID.Equals(id));
IGenericRepository<Resource> resRepository = new GenericRepository<Resource>();
IList<Resource> relist = resRepository.GetAll();
foreach (var resourceRole in reRl)
{
Resource res = relist.First(p => p.ResourceID.Equals(resourceRole.ReID));
if (res.ReType.Equals("1") && res.State.Equals("0")&&res.URL!=null)
{
_list.Add(res.URL);
}
}
}
}
else
{
string rawUrl = filterContext.HttpContext.Request.RawUrl;
string allUrl = filterContext.HttpContext.Request.Url.ToString();
int index = allUrl.IndexOf(rawUrl);
string url = allUrl.Substring(0, index);
filterContext.Result = new ContentResult
{
Content =
"<script language =\"javascript\" type =\"text/javascript\" >alert(\"无权访问此页!\");window.top.location.href = \"" +
url + "/Login/Index\";</script>"
};
}
}
}
//if (_list.Where(p => p.ToLower().Equals(path)).Count() == 0)
//{
// string rawUrl = filterContext.HttpContext.Request.RawUrl;
// string allUrl = filterContext.HttpContext.Request.Url.ToString();
// int index = allUrl.IndexOf(rawUrl);
// string url = allUrl.Substring(0, index);
// filterContext.Result = new ContentResult
// {
// Content =
// "<script language =\"javascript\" type =\"text/javascript\" >alert(\"无权访问此页!\");window.top.location.href = \"" +
// url + "/Login/Index\";</script>"
// };
//}
}
}
public IEnumerable <HotelPackageViewModel> GetAll()
{
return(HotelPackageRepo.GetAll().ToList().Select(i => i.toViewModel()));
}
private static void ExportCountriesFromMSSqlToMySql(GenericRepository<Country> sqlCountriesRepo, GenericRepository<Country> mySqlCountriesRepo)
{
var countriesFromMSsql = sqlCountriesRepo.GetAll().ToList();
foreach (var countryFromMSsql in countriesFromMSsql.ToList())
{
var country = new Country()
{
Name = countryFromMSsql.Name
};
mySqlCountriesRepo.Add(country);
mySqlCountriesRepo.SaveChanges();
}
}
public IQueryable <Branch> GetAllBranchs()
{
return(_genericRepository.GetAll());
}
private static void ExportGirlsFromMSSqlToMySql()
{
var mssqlFeatures = new GenericRepository<Feature>(new GirlsAgencyContext());
var mysllFeatures = new GenericRepository<Feature>(new GirlAgencyMySql.Data.MySql());
foreach (var mssqlFeature in mssqlFeatures.GetAll().ToList())
{
var feature = new Feature()
{
Name = mssqlFeature.Name
};
mysllFeatures.Add(feature);
}
mysllFeatures.SaveChanges();
}
public IHttpActionResult GetPermissions()
{
GenericRepository<MenuAccess> menuAccessRepository = new GenericRepository<MenuAccess>(new MyRoomDbContext());
return Ok( menuAccessRepository.GetAll());
}
private static void ExportOrdersFromMSSqlToMySql(GenericRepository<Order> sqlOrdersRepo, GenericRepository<Order> mysSqlOrdersRepo)
{
var girlsMysql = new GenericRepository<Girl>(new GirlAgencyMySql.Data.MySql());
var customersMysq = new GenericRepository<Customer>(new GirlAgencyMySql.Data.MySql());
foreach (var orderFromSql in sqlOrdersRepo.GetAll().ToList())
{
//Console.WriteLine(orderFromSql.);
var order = new Order()
{
GirlId =
girlsMysql
.GetAll()
.FirstOrDefault(g => g.FirstName == orderFromSql.Girl.FirstName && g.LastName == orderFromSql.Girl.LastName).Id,
CustomerId =
customersMysq
.GetAll()
.FirstOrDefault(c => c.FirstName == orderFromSql.Customer.FirstName &&
c.LastName == orderFromSql.Customer.LastName).Id,
Duration = orderFromSql.Duration,
Date = orderFromSql.Date
};
mysSqlOrdersRepo.Add(order);
}
mysSqlOrdersRepo.SaveChanges();
}
public IEnumerable <MuseumViewModel> GetAll()
{
return(MuseumRepo.GetAll().ToList().Select(i => i.toViewModel()));
}
private static void printJSON(string p)
{
var repo = new GenericRepository<Girl>
(new GirlsAgencyContext());
switch (p)
{
// TODO finish this
case "Girls":
JavaScriptSerializer jss = new JavaScriptSerializer();
var entities = repo.GetAll().Select(g => new
{
FirstName = g.FirstName,
LastName = g.LastName,
BreastSize = ((BreastSizeEnum)g.BreastSizeId).ToString(),
City = g.City.Name,
Country = g.Country.Name,
HairColor = ((HairColorEnum)g.HairColorId).ToString(),
Customers = g.Customers.Select(c => c.FirstName + " " + c.LastName)
});
Console.WriteLine(jss.Serialize(entities));
break;
}
}
public void TestMethod()
{
var conn = new NHibernateConnection();
var categories = new GenericRepository<Categories>(conn);
List<Categories> list = categories.GetAll().ToList();
int count = list.Count;
//Test t = new Test
//{
// LastName = "LastName",
// Name = "Name"
//};
//GenericRepository<Test> tRepo = new GenericRepository<Test>();
//tRepo.Save(t);
}
