public void JoinWithArithmeticExpressionOrderByCalulatedColumn()
{
CustomerCollection collection = new CustomerCollection();
collection.es.Connection.ConnectionString =
UnitTestBase.GetFktString(collection.es.Connection);
string orderAlias = "";
switch (collection.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.MSAccessProvider":
orderAlias = "<'TotalSales'>";
break;
default:
orderAlias = "TotalSales";
break;
}
// Notice I create a calulated columns based on the TotalSales,
// then Order by it descending
CustomerQuery cust = new CustomerQuery("c");
OrderQuery order = new OrderQuery("o");
OrderItemQuery item = new OrderItemQuery("oi");
cust.Select(cust.CustomerName,
(item.Quantity * item.UnitPrice).Sum().As("TotalSales"));
cust.InnerJoin(order).On(order.CustID == cust.CustomerID);
cust.InnerJoin(item).On(item.OrderID == order.OrderID);
cust.GroupBy(cust.CustomerName);
cust.OrderBy(orderAlias, esOrderByDirection.Descending);
Assert.IsTrue(collection.Load(cust));
Assert.AreEqual(6, collection.Count);
}
public void SingleUnion()
{
CustomerCollection coll = new CustomerCollection();
coll.es.Connection.Name = "ForeignKeyTest";
CustomerQuery cq1 = new CustomerQuery("c1");
cq1.SelectAllExcept(cq1.Notes);
cq1.Where(cq1.DateAdded.Between(Convert.ToDateTime("2005-01-01"), Convert.ToDateTime("2005-12-31")));
CustomerQuery cq2 = new CustomerQuery("c2");
cq2.SelectAllExcept(cq2.Notes);
cq2.Where(cq2.DateAdded.Between(Convert.ToDateTime("2006-01-01"), Convert.ToDateTime("2006-12-31")));
// Combine 2005 and 2006 in one result set
cq1.Union(cq2);
//string lq = cq1.Parse();
Assert.IsTrue(coll.Load(cq1));
Assert.AreEqual(49, coll.Count);
}
public CountryController(CustomerQuery customerQuery, DomainQuery domainQuery)
{
_customerQuery = customerQuery;
_domainQuery = domainQuery;
}
public SignUp()
{
InitializeComponent();
this.BackgroundImage = "background.png";
this.Title = "Sign up";
_CustomerDB = new CustomersDB();
_CustomerQuery = new CustomerQuery();
var fullname = new Entry {
Placeholder = "Full name", HorizontalOptions = LayoutOptions.FillAndExpand, PlaceholderColor = Color.Gray, BackgroundColor = Color.White, TextColor = Color.Black
};
var usname = new Entry {
Placeholder = "Username", PlaceholderColor = Color.Gray, BackgroundColor = Color.White, TextColor = Color.Black
};
var pw = new Entry {
IsPassword = true, Placeholder = "Password", PlaceholderColor = Color.Gray, BackgroundColor = Color.White, TextColor = Color.Black
};
var repw = new Entry {
IsPassword = true, Placeholder = "Re type Password", PlaceholderColor = Color.Gray, BackgroundColor = Color.White, TextColor = Color.Black
};
var add = new Entry {
Placeholder = "Enter Address", PlaceholderColor = Color.Gray, BackgroundColor = Color.White, TextColor = Color.Black
};
var image = new Image {
Source = "newlogo.png", WidthRequest = 250
};
var lo = new Label {
Text = "Signup", TextColor = Color.Maroon, FontSize = 20
};
var signup = new Button {
Text = "signup", BackgroundColor = Color.Maroon, TextColor = Color.White, HorizontalOptions = LayoutOptions.FillAndExpand
};
signup.Clicked += (object sender, EventArgs e) =>
{
try
{
if (fullname.Text == null || usname.Text == null || pw.Text == null || repw.Text == null || add.Text == null)
{
DisplayAlert("Alert", "Please Fill All the Fields", "OK");
}
else
{
if (pw.Text == repw.Text)
{
InsertData(fullname.Text.ToString(), usname.Text.ToString(), pw.Text.ToString(), add.Text.ToString());
//DisplayAlert("Alert", "Saved Succesfully.", "OK");
Navigation.PushAsync(new Login());
}
else
{
DisplayAlert("Alert", "Please check whether the password and the re typed password is correct", "OK");
}
}
}
catch (Exception ex)
{
string error = ex.ToString();
DisplayAlert("Sorry...", "Something went wrong. Try after sometime.", "OK");
// Navigation.PushAsync(new HomePage());
}
};
var btnStack = new StackLayout
{
Orientation = StackOrientation.Horizontal,
HorizontalOptions = LayoutOptions.FillAndExpand,
Children =
{
signup
}
};
Content = new StackLayout
{
Padding = 15,
BackgroundColor = Color.FromHex("#f2e6d9"),
VerticalOptions = LayoutOptions.FillAndExpand,
HorizontalOptions = LayoutOptions.FillAndExpand,
Children = { image, lo, fullname, usname, pw, repw, add, btnStack }
};
}
public CustomerController()
{
_customer = new CustomerQuery();
}
// copy constructor
public CustomerQuery(CustomerQuery customerQuery) : base(customerQuery)
{
}
public async Task <QueryResult <Customer> > GetNoInCampaignCustomersAsync(int campaignId, CustomerQuery queryObj)
{
var result = new QueryResult <Customer>();
var customers = await unitOfWork.CustomerRepository.GetCustomersAsync(queryObj);
var campaignDetail = (await unitOfWork
.CampaignDetailRepository
.GetCampaignDetailAsync(campaignId, new CampaignDetailQuery {
ApplyPagingFromClient = true
}))
.Items.Where(cd => !cd.State.Equals(CampaignStatus.Earned.ToString()));
var query = (from c in customers.Items
join cd in campaignDetail on c.Id equals cd.CustomerId into temp
from cd in temp.DefaultIfEmpty()
where cd == null
select c).AsQueryable();
result.TotalItems = query.Count();
result.Items = query.ToList();
return(result);
}
public async Task <List <Customer> > ToListAsync(CustomerQuery query)
{
return(await Repository.ToListAsync(query));
}
public int Insert(CustomerQuery entity)
{
entity.CreatedDate = DateTime.Now;
return(_customerRepo.Insert(entity));
}
public void NestedZeroToManyEntity2()
{
//The main Employee
Employee emp = new Employee();
emp.es.Connection.Name = "ForeignKeyTest";
emp.Query.Where(emp.Query.EmployeeID == 1);
// Prefetch Employee Customers by Manager
CustomerQuery cq1 = emp.Query.Prefetch <CustomerQuery>(
Employee.Prefetch_CustomerCollectionByManager);
EmployeeQuery eq1 = cq1.GetQuery <EmployeeQuery>();
cq1.Where(eq1.EmployeeID == 1);
// Prefetch Employee Customers Orders (composite FK)
OrderQuery oq1 = emp.Query.Prefetch <OrderQuery>(
Employee.Prefetch_CustomerCollectionByManager,
Customer.Prefetch_OrderCollectionByCustID);
EmployeeQuery eq2 = oq1.GetQuery <EmployeeQuery>();
oq1.Where(eq2.EmployeeID == 1);
// Prefetch Employee Customers Orders OrderItems
OrderItemQuery oiq1 = emp.Query.Prefetch <OrderItemQuery>(
Employee.Prefetch_CustomerCollectionByManager,
Customer.Prefetch_OrderCollectionByCustID,
Order.Prefetch_OrderItemCollectionByOrderID);
EmployeeQuery eq3 = oiq1.GetQuery <EmployeeQuery>();
oiq1.Where(eq3.EmployeeID == 1);
// Prefetch Employee Customers by StaffAssigned
CustomerQuery cq2 = emp.Query.Prefetch <CustomerQuery>(
Employee.Prefetch_CustomerCollectionByStaffAssigned);
EmployeeQuery eq4 = cq2.GetQuery <EmployeeQuery>();
cq2.Where(eq4.EmployeeID == 1);
emp.Query.Load();
Assert.AreEqual(1, emp.EmployeeID.Value);
Assert.AreEqual(35, emp.CustomerCollectionByManager.Count);
Assert.AreEqual(2, emp.CustomerCollectionByStaffAssigned.Count);
Assert.AreEqual(0, emp.EmployeeCollectionBySupervisor.Count, "These 2 are not Prefetched");
foreach (Customer c in emp.CustomerCollectionByManager)
{
if (c.CustomerID == "01001" && c.CustomerSub == "001")
{
Assert.AreEqual(3, c.OrderCollectionByCustID.Count);
foreach (Order o in c.OrderCollectionByCustID)
{
if (o.OrderID == 1)
{
Assert.AreEqual(3, o.OrderItemCollectionByOrderID.Count);
}
}
}
}
}
public Login()
{
InitializeComponent();
IPQuery IPBC = new IPQuery();
SQLiteConnection IPB;
IPB = DependencyService.Get <ISQLite>().GetConnection();
IPB.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
//if (backnow == bone)
//{
// this.BackgroundImage = saveback;
saveback = backnow;
if (saveback == "Style1")
{
this.BackgroundImage = "background.png";
}
else if (saveback == "Style2")
{
this.BackgroundImage = "backgroundnew.png";
}
else if (saveback == "Style3")
{
this.BackgroundImage = "backnewtwo.png";
}
//this.BackgroundImage = "background.png";
this.Title = "Login";
var username = new Entry {
Placeholder = "Username", PlaceholderColor = Color.Gray, TextColor = Color.White, BackgroundColor = Color.Black, Opacity = 0.7
};
var password = new Entry {
IsPassword = true, Placeholder = "Password", PlaceholderColor = Color.Gray, TextColor = Color.White, BackgroundColor = Color.Black, Opacity = 0.7
};
var login = new Button {
Text = "Login"
};
var lbl_signup = new Label {
Text = "Not a Member? Click the button and sign up now!", TextColor = Color.White
};
var signup = new Button {
Text = "Sign up"
};
signup.Clicked += (object sender, EventArgs e) =>
{
Navigation.PushAsync(new SignUp());
};
login.Clicked += (object sender, EventArgs e) =>
{
CustomersDB _CustomerDB = new CustomersDB();
CustomerQuery _CustomerQuery = new CustomerQuery();
CustomersDB c = _CustomerQuery.GetCustName(username.Text);
if (c != null)
{
if (password.Text == c.Password)
{
// DisplayAlert("Alert", "login succesful", "OK");
//Navigation.PushAsync(new PayNow());
Navigation.PushAsync(new IPaccessPage());
}
else
{
DisplayAlert("Alert", "login failed", "OK");
}
}
// DisplayAlert("Alert", "ID: " + c.Id + " UserName: "******" Password: "******"OK");
};
//var btnStack = new StackLayout
//{
// Orientation = StackOrientation.Horizontal,
// HorizontalOptions = LayoutOptions.FillAndExpand,
// Children = {
// login, signup
// }
//};
Content = new StackLayout
{
VerticalOptions = LayoutOptions.Center,
HorizontalOptions = LayoutOptions.Center,
Children = { username, password, login, lbl_signup, signup }
};
}
public BaseListResponse <SPGetCustomer_Result> Search([FromUri] CustomerQuery query)
{
return(categoryService.FilterCustomer(query));
}
public static IEnumerable <Customer> SelectByRegionAndCity(this IRepository <Customer> repository, string region, string city)
{
return(repository.Query(CustomerQuery.LivesIn(city, region))
.Select().AsEnumerable());
}
private IObservable <IList <Customer> > GetRecentlyUpdatedCustomers(CustomersApi customersApi, CustomerQuery query, string cursor)
{
var request = new SearchCustomersRequest(Cursor: cursor, Query: query);
return(customersApi
.SearchCustomersAsync(request)
.ToObservable()
.SelectMany(
response =>
{
if (response.Cursor == null)
{
return Observable
.Return(response.Customers);
}
else
{
return Observable
.Return(response.Customers)
.Concat(GetRecentlyUpdatedCustomers(customersApi, query, response.Cursor));
}
}));
}
// The resulting HypermediaObject when it is a Query. Requires the query object so the self link can be build including the query string.
// NavigationQuerys are additional Links like e.g. pagination "Next" or "First"
public HypermediaCustomerQueryResult(ICollection <HypermediaObjectReferenceBase> entities, int totalEnties, CustomerQuery query)
: base(query)
{
TotalEnties = totalEnties;
CurrentEntitiesCount = entities.Count;
Entities.AddRange(DefaultHypermediaRelations.EmbeddedEntities.Item, entities);
}
public LOGIN()
{
InitializeComponent();
this.BackgroundImage = "background.png";
this.Title = "Login";
var username = new Entry {
Placeholder = "Username"
};
var password = new Entry {
IsPassword = true, Placeholder = "Password"
};
var login = new Button {
Text = "Login"
};
var lbl_signup = new Label {
Text = "Not a Member? Click the button and sign up now!"
};
var signup = new Button {
Text = "Sign up"
};
signup.Clicked += (object sender, EventArgs e) =>
{
Navigation.PushAsync(new SignUp());
};
login.Clicked += (object sender, EventArgs e) =>
{
CustomersDB _CustomerDB = new CustomersDB();
CustomerQuery _CustomerQuery = new CustomerQuery();
CustomersDB c = _CustomerQuery.GetCustName(username.Text);
if (c != null)
{
if (password.Text == c.Password)
{
DisplayAlert("Alert", "login succesful", "OK");
Navigation.PushAsync(new Views.PayNow());
}
else
{
DisplayAlert("Alert", "login failed", "OK");
}
}
// DisplayAlert("Alert", "ID: " + c.Id + " UserName: "******" Password: "******"OK");
};
//var btnStack = new StackLayout
//{
// Orientation = StackOrientation.Horizontal,
// HorizontalOptions = LayoutOptions.FillAndExpand,
// Children = {
// login, signup
// }
//};
Content = new StackLayout
{
VerticalOptions = LayoutOptions.FillAndExpand,
HorizontalOptions = LayoutOptions.FillAndExpand,
Children = { username, password, login, lbl_signup, signup }
};
}
protected bool Equals(CustomerQuery other) => string.Equals(CompanyName, other.CompanyName);
public void NestedZeroToManyCollection()
{
//The main Employee query
EmployeeCollection coll = new EmployeeCollection();
coll.es.Connection.Name = "ForeignKeyTest";
coll.Query.Where(coll.Query.EmployeeID < 4);
// Prefetch Employees Customers by Manager
CustomerQuery cq1 = coll.Query.Prefetch <CustomerQuery>(
Employee.Prefetch_CustomerCollectionByManager);
EmployeeQuery eq1 = cq1.GetQuery <EmployeeQuery>();
cq1.Where(eq1.EmployeeID < 4);
// Prefetch Employees Customers Orders (composite FK)
OrderQuery oq1 = coll.Query.Prefetch <OrderQuery>(
Employee.Prefetch_CustomerCollectionByManager,
Customer.Prefetch_OrderCollectionByCustID);
EmployeeQuery eq2 = oq1.GetQuery <EmployeeQuery>();
oq1.Where(eq2.EmployeeID < 4);
// Prefetch Employees Customers Orders OrderItems
OrderItemQuery oiq1 = coll.Query.Prefetch <OrderItemQuery>(
Employee.Prefetch_CustomerCollectionByManager,
Customer.Prefetch_OrderCollectionByCustID,
Order.Prefetch_OrderItemCollectionByOrderID);
EmployeeQuery eq3 = oiq1.GetQuery <EmployeeQuery>();
oiq1.Where(eq3.EmployeeID < 4);
// Prefetch Employees Customers by StaffAssigned
CustomerQuery cq2 = coll.Query.Prefetch <CustomerQuery>(
Employee.Prefetch_CustomerCollectionByStaffAssigned);
EmployeeQuery eq4 = cq2.GetQuery <EmployeeQuery>();
cq2.Where(eq4.EmployeeID < 4);
coll.Query.Load();
foreach (Employee emp in coll)
{
switch (emp.EmployeeID.Value)
{
case 1:
Assert.AreEqual(1, emp.EmployeeID.Value);
Assert.AreEqual(35, emp.CustomerCollectionByManager.Count);
Assert.AreEqual(2, emp.CustomerCollectionByStaffAssigned.Count);
Assert.AreEqual(0, emp.EmployeeCollectionBySupervisor.Count, "These 2 are not Prefetched");
foreach (Customer c in emp.CustomerCollectionByManager)
{
if (c.CustomerID == "01001" && c.CustomerSub == "001")
{
Assert.AreEqual(3, c.OrderCollectionByCustID.Count);
foreach (Order o in c.OrderCollectionByCustID)
{
if (o.OrderID == 1)
{
Assert.AreEqual(3, o.OrderItemCollectionByOrderID.Count);
}
}
}
}
break;
case 2:
Assert.AreEqual(2, emp.EmployeeID.Value);
Assert.AreEqual(12, emp.CustomerCollectionByManager.Count);
Assert.AreEqual(5, emp.CustomerCollectionByStaffAssigned.Count);
break;
case 3:
Assert.AreEqual(3, emp.EmployeeID.Value);
Assert.AreEqual(6, emp.CustomerCollectionByManager.Count);
Assert.AreEqual(1, emp.CustomerCollectionByStaffAssigned.Count);
break;
default:
Assert.Fail("Only employees 1, 2, and 3 should be loaded.");
break;
}
}
}
public CultureController(DomainCultureQuery domainCultureQuery, CultureQuery cultureQuery, SaveCommand saveCommand, CustomerQuery customerQuery)
{
_domainCultureQuery = domainCultureQuery;
_cultureQuery = cultureQuery;
_saveCommand = saveCommand;
_customerQuery = customerQuery;
}
// GET: api/Customer
public ArrayList Get()
{
CustomerQuery cq = new CustomerQuery();
return(cq.selectAllCustomer());
}
public async Task <QueryResult <Customer> > GetCustomersAsync(CustomerQuery queryObj)
{
return(await unitOfWork.CustomerRepository.GetCustomersAsync(queryObj));
}
public DemoSchema(IServiceProvider provider) : base(provider)
{
Query = new CustomerQuery();
Mutation = new CustomerMutation();
}
public async Task <QueryResult <AgentCustomerViewModel> > GetAgentCustomersAsync(string agentId, CustomerQuery queryObj)
{
var campaigns = await unitOfWork.CampaignRepository.GetAgentValidCampaignsAsync(agentId, new CampaignQuery());
return(unitOfWork.CustomerRepository.GetAgentCustomers(campaigns, queryObj));
}
private EnterCurrentQuote GetCurrentQuote_Model(string ContractID)
{
if (string.IsNullOrEmpty(ContractID))
{
return(null);
}
else
{
int contractID = Convert.ToInt32(ContractID);
EWS.Domain.Data.DataModel.Quote quote = GetExistingQuote(contractID);
if (quote != null)
{
return(GetCurrentQuote_Model(quote));
}
else
{
EWS.Domain.Data.DataModel.Contract sourcecontract = GetContract(contractID);
if (sourcecontract == null)
{
return(null);
}
else
{
EnterCurrentQuote model = new EnterCurrentQuote();
DeviceQuery query = new Domain.Data.Queries.DeviceQuery()
{
DeviceID = sourcecontract.DeviceID
};
model.Device = _queryProcessor.Execute(query);
model.TenderNumber = sourcecontract.TenderNo;
model.VAT = sourcecontract.VAT;
model.SellingPriceExclVAT = 0;
model.SellingPriceInclVAT = 0;
List <EWS.Domain.Data.DataModel.ContractItem> contractitems = GetContractItems(contractID);
model.ContractCalculations = new List <QuoteCalculation>();
foreach (EWS.Domain.Data.DataModel.ContractItem contractitem in contractitems)
{
model.ContractCalculations.Add(new QuoteCalculation()
{
Selected = true,
BasePrice = contractitem.BasePrice,
ContractTypeID = contractitem.ContractTypeID,
ContractType = contractitem.ContractType.ContractTypeName,
ROEPortion = contractitem.ROEPortion,
ROEPortionAmount = contractitem.ROEPortionAmount,
ZARPortion = contractitem.ZARPortion,
ZARPortionAmount = contractitem.ZARPortionAmount
});
}
CustomerQuery customerquery = new CustomerQuery()
{
ID = sourcecontract.CustomerID
};
Domain.Data.DataModel.Customer customer = _queryProcessor.Execute(customerquery);
model.Customer = new Customer()
{
Id = sourcecontract.CustomerID,
CustomerName = customer.CustomerNameFriendly,
Locality = customer.CustomerLocality.CustomerLocalityName,
RegistrationNo = customer.RegistrationNo
};
model.ExchangeRate = new ExchangeRate()
{
Rate = sourcecontract.ROE,
Date = sourcecontract.ROEDate
};
return(model);
}
}
}
} //GetCurrentQuote_Model
//public ActionResult UnBind
/// <summary>
/// 会员个人信息详情页
/// <param name="id">会员微信系统编号</param>
/// </summary>
/// <returns></returns>
public ActionResult MemberDetail(long id)
{
var svc = Service;
var OSvc = ORSService;
var CSvc = CONService;
var Member = svc.SelectOrEmpty(new FanQuery()
{
IDs = new long[] { id }
}).FirstOrDefault();
MemberPersonalVM PersonalVM = new MemberPersonalVM();
#region 微信端用户基本信息
if (Member != null)
{
UserInfo UInfo = CSvc.RequeUserInfo(OwnerID, Member.Code);
//微信系统用户基本信息
PersonalVM.WeChatMember = Member;
PersonalVM.WeChatExtra = new WeChatPersonalExtra();
PersonalVM.WeChatExtra.City = UInfo.city;
PersonalVM.WeChatExtra.Province = UInfo.province;
PersonalVM.WeChatExtra.Country = UInfo.country;
PersonalVM.WeChatExtra.Gender = UInfo.sex;
PersonalVM.WeChatExtra.GenderName = ((MemberGender)UInfo.sex).GetDescription();
PersonalVM.WeChatExtra.NickName = UInfo.nickname;
PersonalVM.WeChatExtra.FollowDate = FollowTime(UInfo.subscribe_time);
}
#endregion
#region 主系统关联信息
var relatedQuery = new MemberRelatedQuery {
FanIDs = new long[] { id }
};
var relatedRecord = svc.SelectOrEmpty(relatedQuery).FirstOrDefault();
if (relatedRecord != null)
{
var webQuery = new CustomerQuery
{
IDs = new long[] { relatedRecord.CustomerID ?? -1 }
};
var webMember = OSvc.SelectOrEmpty(webQuery).FirstOrDefault();
if (webMember != null)
{
PersonalVM.WebExtra = new WebPersonalExtra();
PersonalVM.WebExtra.CustomerMobile = webMember.Mobile;
PersonalVM.WebExtra.CustomerEmail = webMember.Email;
//主系统会员等级信息
var rankQuery = new CustomerRankQuery
{
IDs = new long[] { webMember.RankID ?? -1 }
};
var rankItem = OSvc.SelectOrEmpty(rankQuery).FirstOrDefault();
if (rankItem != null)
{
PersonalVM.WebExtra.CustomerRank = rankItem.Name;
}
//主系统会员积分信息
var balanceQuery = new CustomerBalanceQuery
{
IDs = new long[] { webMember.ID ?? -1 }
};
var balanceItem = OSvc.SelectOrEmpty(balanceQuery).FirstOrDefault();
if (balanceItem != null)
{
PersonalVM.WebExtra.CustomerCredit = balanceItem.Point;
}
//主系统会员登陆名信息
var identityQuery = new CustomerIdentityQuery
{
CustomerIDs = new long[] { webMember.ID ?? -1 }
};
var identityList = OSvc.SelectOrEmpty(identityQuery);
if (identityList != null && identityList.Any())
{
PersonalVM.WebExtra.CustomerId = new List <string>();
foreach (var identityItem in identityList)
{
PersonalVM.WebExtra.CustomerId.Add(identityItem.Code);
}
}
}
return(View(PersonalVM));
}
#endregion
return(View(PersonalVM));
}
List <Customer> Handle(CustomerQuery query)
{
// CustomerQuery is a simple message type class which contains country and orderby
// just as in the original method, but now packed up in a 'message'
}
public GraphQlService(IDocumentExecuter documentExecuter, CustomerQuery customerQuery, IDependencyResolver dependencyResolver)
{
_documentExecuter = documentExecuter;
_customerQuery = customerQuery;
_dependencyResolver = dependencyResolver;
}
public Login()
{
InitializeComponent();
this.BackgroundImage = "background.png";
this.Title = "Login";
var image = new Image {
Source = "newlogo.png", WidthRequest = 250
};
var lo = new Label {
Text = "Login", TextColor = Color.Maroon, FontSize = 20
};
var username = new Entry {
Placeholder = "Username", BackgroundColor = Color.White, PlaceholderColor = Color.Gray, TextColor = Color.Black
};
var password = new Entry {
IsPassword = true, Placeholder = "Password", BackgroundColor = Color.White, PlaceholderColor = Color.Gray, TextColor = Color.Black
};
var login = new Button {
Text = "Login", BackgroundColor = Color.Maroon, TextColor = Color.White
};
var lbl_signup = new Label {
Text = "Not a Member? Click the button and sign up now!", TextColor = Color.Black, FontSize = 10
};
var signup = new Button {
Text = "Sign up", BackgroundColor = Color.Maroon, TextColor = Color.White
};
signup.Clicked += (object sender, EventArgs e) =>
{
Navigation.PushAsync(new SignUp());
};
login.Clicked += (object sender, EventArgs e) =>
{
CustomersDB _CustomerDB = new CustomersDB();
CustomerQuery _CustomerQuery = new CustomerQuery();
CustomersDB c = _CustomerQuery.GetCustName(username.Text);
if (c != null)
{
if (password.Text == c.Password)
{
// DisplayAlert("Alert", "Login succesful!", "OK");
Navigation.PushAsync(new Views.PayNow());
}
else
{
DisplayAlert("Alert", "Login failed", "OK");
}
}
else
{
DisplayAlert("Alert", "Login failed", "OK");
}
// DisplayAlert("Alert", "ID: " + c.Id + " UserName: "******" Password: "******"OK");
};
Content = new StackLayout
{
VerticalOptions = LayoutOptions.FillAndExpand,
Padding = 15,
HorizontalOptions = LayoutOptions.FillAndExpand,
BackgroundColor = Color.FromHex("#f2e6d9"),
Children = { image, lo, username, password, login, lbl_signup, signup }
};
}
public SignUp()
{
InitializeComponent();
this.BackgroundImage = "background.png";
this.Title = "Sign up";
_CustomerDB = new CustomersDB();
_CustomerQuery = new CustomerQuery();
var fullname = new Entry {
Placeholder = "full name", HorizontalOptions = LayoutOptions.FillAndExpand
};
var usname = new Entry {
Placeholder = "Username"
};
var pw = new Entry {
IsPassword = true, Placeholder = "Password"
};
var repw = new Entry {
IsPassword = true, Placeholder = "Re type Password"
};
var add = new Entry {
Placeholder = "Enter Address"
};
var signup = new Button {
Text = "signup", HorizontalOptions = LayoutOptions.FillAndExpand
};
signup.Clicked += (object sender, EventArgs e) =>
{
try
{
if (fullname.Text == null || usname.Text == null || pw.Text == null || repw.Text == null || add.Text == null)
{
DisplayAlert("Alert", "Please Fill All the Fields", "OK");
}
else
{
if (pw.Text == repw.Text)
{
InsertData(fullname.Text.ToString(), usname.Text.ToString(), pw.Text.ToString(), add.Text.ToString());
DisplayAlert("Alert", "Saved Succesfully.", "OK");
Navigation.PushAsync(new LOGIN());
}
else
{
DisplayAlert("Alert", "Please check whether the password and the re typed password is correct", "OK");
}
}
}
catch (Exception ex)
{
string error = ex.ToString();
DisplayAlert("Sorry...", "Something went wrong. Try after sometime.", "OK");
// Navigation.PushAsync(new HomePage());
}
};
var btnStack = new StackLayout
{
Orientation = StackOrientation.Horizontal,
HorizontalOptions = LayoutOptions.FillAndExpand,
Children =
{
signup
}
};
Content = new StackLayout
{
VerticalOptions = LayoutOptions.FillAndExpand,
HorizontalOptions = LayoutOptions.FillAndExpand,
Children = { fullname, usname, pw, repw, add, btnStack }
};
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
Customer mock = CreateMockInstance(tm);
bool result = DataRepository.CustomerProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
CustomerQuery query = new CustomerQuery();
query.AppendEquals(CustomerColumn.Id, mock.Id.ToString());
if (mock.Type != null)
{
query.AppendEquals(CustomerColumn.Type, mock.Type.ToString());
}
if (mock.Fullname != null)
{
query.AppendEquals(CustomerColumn.Fullname, mock.Fullname.ToString());
}
if (mock.Address != null)
{
query.AppendEquals(CustomerColumn.Address, mock.Address.ToString());
}
if (mock.Phone != null)
{
query.AppendEquals(CustomerColumn.Phone, mock.Phone.ToString());
}
if (mock.Fax != null)
{
query.AppendEquals(CustomerColumn.Fax, mock.Fax.ToString());
}
if (mock.PersonId != null)
{
query.AppendEquals(CustomerColumn.PersonId, mock.PersonId.ToString());
}
if (mock.PlaceIssue != null)
{
query.AppendEquals(CustomerColumn.PlaceIssue, mock.PlaceIssue.ToString());
}
if (mock.Email != null)
{
query.AppendEquals(CustomerColumn.Email, mock.Email.ToString());
}
if (mock.DueDate != null)
{
query.AppendEquals(CustomerColumn.DueDate, mock.DueDate.ToString());
}
if (mock.Bankname != null)
{
query.AppendEquals(CustomerColumn.Bankname, mock.Bankname.ToString());
}
if (mock.BankBr != null)
{
query.AppendEquals(CustomerColumn.BankBr, mock.BankBr.ToString());
}
if (mock.Accnum != null)
{
query.AppendEquals(CustomerColumn.Accnum, mock.Accnum.ToString());
}
if (mock.Vatnum != null)
{
query.AppendEquals(CustomerColumn.Vatnum, mock.Vatnum.ToString());
}
if (mock.Contactps != null)
{
query.AppendEquals(CustomerColumn.Contactps, mock.Contactps.ToString());
}
if (mock.Remark != null)
{
query.AppendEquals(CustomerColumn.Remark, mock.Remark.ToString());
}
if (mock.OpenDate != null)
{
query.AppendEquals(CustomerColumn.OpenDate, mock.OpenDate.ToString());
}
query.AppendEquals(CustomerColumn.Status, mock.Status.ToString());
TList <Customer> results = DataRepository.CustomerProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
