protected void Child_Update(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"UPDATE itemuomconversion SET
item = @item,
quantity = @quantity,
uom = @uom
WHERE itemuomconversion = @id";
cmd.Parameters.AddWithValue("@item", parentId.Value);
cmd.Parameters.AddWithValue("@quantity", Quantity);
cmd.Parameters.AddWithValue("@uom", Uom);
cmd.Parameters.AddWithValue("@id", this.Id);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
protected void Child_Update(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"UPDATE BillItemPorterage SET
quantity = @quantity,
remarks = @remarks,
rate = @rate
WHERE BillItemPorterage = @id";
cmd.Parameters.AddWithValue("@quantity", Quantity);
cmd.Parameters.AddWithValue("@remarks", Remarks);
cmd.Parameters.AddWithValue("@rate", Rate);
cmd.Parameters.AddWithValue("@id", this.Id);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
public static void Get(SingleCriteria <int> tableid, EventHandler <DataPortalResult <TableCounterInfo> > completed)
{
DataPortal <TableCounterInfo> dp = new DataPortal <TableCounterInfo>();
dp.FetchCompleted += completed;
dp.BeginFetch(tableid);
}
public void Delete(SingleCriteria<Order, int> criteria)
{
if (criteria.Value == 202)
throw new ServerOnlyException("This Exception is only available on the Server side");
else
throw new MyNonSerializableException("This exception is not serializable");
}
protected void DataPortal_Create(SingleCriteria <Customer, int> criteria)
{
LoadProperty(IdProperty, criteria.Value);
LoadProperty(NameProperty, "New Customer for Id: " + criteria.Value.ToString());
LoadProperty(DateCreatedProperty, new SmartDate(DateTime.Today));
LoadProperty(ContactsProperty, CustomerContactList.GetCustomerContactList(0));
}
private void DataPortal_Fetch(SingleCriteria <SortingTaskProgress, string> criteria)
{
using (BypassPropertyChecks)
{
using (var cn = new MySqlConnection(AppUtil._LocalConnectionString))
{
cn.Open();
using (var cm = cn.CreateCommand())
{
cm.CommandText =
"SELECT * FROM T_SORTING_Line_TASK WHERE id = @id";
cm.Parameters.AddWithValue("@id", criteria.Value);
using (var dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
LoadProperty(STATUSProperty, dr.GetInt32("STATUS"));
LoadProperty(PLCAddressProperty, dr.GetInt32("plcaddress"));
LoadProperty(SORTINGTIMEProperty, dr.GetDateTime("SORTINGTIME"));
LoadProperty(FINISHTIMEProperty, dr.GetDateTime("FINISHTIME"));
LoadProperty(IdProperty, dr.GetString("Id"));
}
}
}
}
}
protected void DataPortal_Fetch(SingleCriteria <Customer, int> criteria)
{
LoadProperty(IdProperty, criteria.Value);
LoadProperty(NameProperty, "Customer Name for Id: " + criteria.Value.ToString());
LoadProperty(DateCreatedProperty, new SmartDate(new DateTime(2000 + criteria.Value, 1, 1)));
LoadProperty(ContactsProperty, CustomerContactList.GetCustomerContactList(criteria.Value));
}
private void DataPortal_Fetch(SingleCriteria <RootList, int> criteria)
{
for (int i = 0; i < criteria.Value; i++)
{
this.Add(DataPortal.FetchChild <Child>(i));
}
}
protected void Child_Update(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"UPDATE BillItemMooring SET
cargo = @cargo,
quantity = @quantity,
uom = @uom,
rate = @rate,
istaxable = @istaxable
WHERE BillItemMooring = @id";
cmd.Parameters.AddWithValue("@cargo", Cargo.Id);
cmd.Parameters.AddWithValue("@quantity", Quantity);
cmd.Parameters.AddWithValue("@uom", Uom);
cmd.Parameters.AddWithValue("@rate", Rate);
cmd.Parameters.AddWithValue("@istaxable", IsTaxable);
cmd.Parameters.AddWithValue("@id", this.Id);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
public InvLib.CustomerDetail Fetch(SingleCriteria<InvLib.CustomerDetail, int> criteria)
{
var item = new InvLib.CustomerDetail();
var p = (from r in MockDb.CustomerData
where r.Id == criteria.Value
join l in MockDb.LocationData on r.LocationId equals l.Id
select new { Id = r.Id, Name = r.Name, Lat = l.Lat, Long = l.Long }).Single();
LoadProperty(item, InvLib.CustomerDetail.IdProperty, p.Id);
LoadProperty(item, InvLib.CustomerDetail.NameProperty, p.Name);
LoadProperty(item, InvLib.CustomerDetail.LocationProperty, p.Lat + "/" + p.Long);
var orders = from o in MockDb.OrderData
where o.CustomerId == p.Id
select o;
SetIsReadOnly(item.Orders, false);
foreach (var order in orders)
{
var pli = new InvLib.CustomerOrderInfo();
LoadProperty(pli, InvLib.CustomerOrderInfo.IdProperty, order.Id);
LoadProperty(pli, InvLib.CustomerOrderInfo.OrderDateProperty, order.OrderDate);
var amt = (from li in MockDb.OrderLineItemData
where li.OrderId == order.Id
select li.Price * li.Quantity).Sum();
LoadProperty(pli, InvLib.CustomerOrderInfo.AmountProperty, amt);
item.Orders.Add(pli);
}
SetIsReadOnly(item.Orders, true);
return item;
}
private void DataPortal_Fetch(SingleCriteria <int> id)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"select bi.billingitem,
br.billitemrate,
ip.itemprice as itemrate,
case when ip.classification = 0 then 'Arrastre'
when ip.classification = 1 then 'Stevedoring'
when ip.classification = 2 then 'Roll-on/Roll-off' end as chargetype,
uom.name as unitname,
br.computation1,
ip.quantity as computation2,
ip.unitprice as computation3
from billingitem bi
inner join billitemrate br on br.billingitem = bi.billingitem
left join itemprice ip on ip.itemprice = br.itemrate
left join uom on uom.uom = ip.uom
left join itemuomconversion on itemuomconversion.item = bi.item
and itemuomconversion.uom = bi.preferreduom
where bi.billingitem = @id";
cmd.Parameters.AddWithValue("@id", id.Value);
using (var dr = new SafeDataReader(cmd.ExecuteReader()))
{
while (dr.Read())
{
this.Add(BillRate.Get(dr));
}
}
}
}
}
public void DataPortal_Delete(
SingleCriteria <MockEditableRoot, Guid> criteria,
LocalProxy <MockEditableRoot> .CompletedHandler handler)
{
LoadProperty <string>(DataPortalMethodProperty, "delete");
handler(this, null);
}
protected void Child_Update(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"UPDATE itemprice
SET item = @item
,classification = @classification
,uom = @uom
,unitprice = @unitprice
,remarks = @remarks
,quantity = @constantvalue
WHERE itemprice = @id";
cmd.Parameters.AddWithValue("@item", parentId.Value);
cmd.Parameters.AddWithValue("@classification", ChargeType);
cmd.Parameters.AddWithValue("@uom", ItemUnit);
cmd.Parameters.AddWithValue("@unitprice", Rate);
cmd.Parameters.AddWithValue("@remarks", Remarks);
cmd.Parameters.AddWithValue("@constantvalue", ConstantValue);
cmd.Parameters.AddWithValue("@id", this.Id);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
static void Main(string[] args)
{
List <Person> persons = new List <Person>();
persons.Add(new Person("Bob", "Male", "Single"));
persons.Add(new Person("Bobbie", "Female", "Single"));
persons.Add(new Person("Jim", "Male", "Married"));
persons.Add(new Person("Jenny", "Female", "Single"));
persons.Add(new Person("Chris", "Male", "Single"));
persons.Add(new Person("Heather", "Female", "Married"));
persons.Add(new Person("Kim", "Female", "Single"));
ICriteria male = new CriteriaMale();
ICriteria female = new CriteriaFemale();
ICriteria single = new SingleCriteria();
ICriteria singleMale = new AndCriteria(single, male);
ICriteria singleFemale = new AndCriteria(single, female);
Console.WriteLine("Males: ");
PrintPersons(male.MeetCriteria(persons));
Console.WriteLine("\nFemales: ");
PrintPersons(female.MeetCriteria(persons));
Console.WriteLine("\nSingle Males: ");
PrintPersons(singleMale.MeetCriteria(persons));
Console.WriteLine("\nSingle Females: ");
PrintPersons(singleFemale.MeetCriteria(persons));
}
public Order Fetch(SingleCriteria<Order, int> criteria)
{
var obj = (Order)Activator.CreateInstance(typeof(Order), true);
MarkOld(obj);
Console.WriteLine("Searching for order id: {0}", criteria.Value);
return obj;
}
private void DataPortal_Fetch(SingleCriteria <int> tableId)
{
this.DataPortal_Fetch(new Criteria()
{
TableId = tableId.Value, RetrieveCounter = true, IncrementCounter = true
});
}
protected void Child_Insert(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"INSERT INTO BillItemPorterage(bill,remarks,quantity,rate)
VALUES (@bill,@remarks,@quantity,@rate)
SELECT SCOPE_IDENTITY()";
cmd.Parameters.AddWithValue("@bill", parentId.Value);
cmd.Parameters.AddWithValue("@remarks", Remarks);
cmd.Parameters.AddWithValue("@quantity", Quantity);
cmd.Parameters.AddWithValue("@rate", Rate);
try
{
int identity = Convert.ToInt32(cmd.ExecuteScalar());
LoadProperty(_Id, identity);
}
catch (Exception)
{
throw;
}
}
}
}
protected void Child_Update(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"UPDATE contactaddress SET
contact = @contact,
addressname = @addressname,
street = @street,
city = @city,
province = @province,
state = @state,
country = @country
WHERE contactaddress = @id";
cmd.Parameters.AddWithValue("@contact", parentId.Value);
cmd.Parameters.AddWithValue("@addressname", AddressName);
cmd.Parameters.AddWithValue("@street", Street);
cmd.Parameters.AddWithValue("@city", City);
cmd.Parameters.AddWithValue("@province", Province);
cmd.Parameters.AddWithValue("@state", State);
cmd.Parameters.AddWithValue("@country", Country);
cmd.Parameters.AddWithValue("@id", this.Id);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
protected void Child_Update(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"UPDATE BillRate
SET itemrate = @itemrate
,billingitem = @billingitem
,computation1 = @computation1
WHERE BillRate = @id";
cmd.Parameters.AddWithValue("@billingitem", parentId.Value);
cmd.Parameters.AddWithValue("@itemrate", ItemRate);
cmd.Parameters.AddWithValue("@computation1", Computation1);
cmd.Parameters.AddWithValue("@id", this.Id);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
public static void Delete(SingleCriteria <int> id, EventHandler <DataPortalResult <BaseItemInfo> > completed)
{
DataPortal <BaseItemInfo> dp = new DataPortal <BaseItemInfo>();
dp.DeleteCompleted += completed;
dp.BeginDelete(id);
}
public InvLib.ProductDetail Fetch(SingleCriteria<InvLib.ProductDetail, int> criteria)
{
var item = new InvLib.ProductDetail();
var p = (from r in MockDb.ProductData where r.Id == criteria.Value select r).Single();
LoadProperty(item, InvLib.ProductDetail.IdProperty, p.Id);
LoadProperty(item, InvLib.ProductDetail.NameProperty, p.Name);
LoadProperty(item, InvLib.ProductDetail.PriceProperty, p.Price);
LoadProperty(item, InvLib.ProductDetail.CategoryIdProperty, p.CategoryId);
var totalQoh = (from b in MockDb.BinData
where b.ProductId == p.Id
select b.Quantity).Sum();
LoadProperty(item, InvLib.ProductDetail.QohProperty, totalQoh);
var l = (from r in MockDb.BinData
join w in MockDb.WarehouseData on r.WarehouseId equals w.Id
where r.ProductId == p.Id
orderby w.Name
select new { BinId = r.Id, WarehouseName = w.Name, Qoh = r.Quantity }).GroupBy(s => s.WarehouseName);
SetIsReadOnly(item.Locations, false);
foreach (var bin in l)
{
var pli = new InvLib.ProductLocationInfo();
LoadProperty(pli, InvLib.ProductLocationInfo.WarehouseNameProperty, bin.Key);
var q = (from i in bin select i.Qoh).Sum();
LoadProperty(pli, InvLib.ProductLocationInfo.QohProperty, q);
item.Locations.Add(pli);
}
SetIsReadOnly(item.Locations, true);
return item;
}
public InvLib.ProductDetail Fetch(SingleCriteria <InvLib.ProductDetail, int> criteria)
{
var item = new InvLib.ProductDetail();
var p = (from r in MockDb.ProductData where r.Id == criteria.Value select r).Single();
LoadProperty(item, InvLib.ProductDetail.IdProperty, p.Id);
LoadProperty(item, InvLib.ProductDetail.NameProperty, p.Name);
LoadProperty(item, InvLib.ProductDetail.PriceProperty, p.Price);
LoadProperty(item, InvLib.ProductDetail.CategoryIdProperty, p.CategoryId);
var totalQoh = (from b in MockDb.BinData
where b.ProductId == p.Id
select b.Quantity).Sum();
LoadProperty(item, InvLib.ProductDetail.QohProperty, totalQoh);
var l = (from r in MockDb.BinData
join w in MockDb.WarehouseData on r.WarehouseId equals w.Id
where r.ProductId == p.Id
orderby w.Name
select new { BinId = r.Id, WarehouseName = w.Name, Qoh = r.Quantity }).GroupBy(s => s.WarehouseName);
SetIsReadOnly(item.Locations, false);
foreach (var bin in l)
{
var pli = new InvLib.ProductLocationInfo();
LoadProperty(pli, InvLib.ProductLocationInfo.WarehouseNameProperty, bin.Key);
var q = (from i in bin select i.Qoh).Sum();
LoadProperty(pli, InvLib.ProductLocationInfo.QohProperty, q);
item.Locations.Add(pli);
}
SetIsReadOnly(item.Locations, true);
return(item);
}
private void DataPortal_Fetch(SingleCriteria <int> id)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"SELECT itemprice
,item
,classification
,uom
,unitprice
,quantity
,remarks
FROM itemprice
WHERE item = @id";
cmd.Parameters.AddWithValue("@id", id.Value);
using (var dr = new SafeDataReader(cmd.ExecuteReader()))
{
while (dr.Read())
{
this.Add(ItemRate.Get(dr));
}
}
}
}
}
private void DataPortal_Fetch(SingleCriteria <int> id)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = string.Format(@"
SELECT bi.billitem,bi.bill,bi.cargo,bi.unitcount,bi.uom,bi.weightused,bi.stevedoringrate,
bi.stevedoringconst,bi.arrastrerate,bi.arrastreconst,bi.premiumrate,bi.qtyconversion,
i.item as {0}item,i.itemcode as {0}itemcode,i.itemname as {0}itemname,bi.istaxable
FROM billitem bi
INNER JOIN item i ON bi.cargo = i.item
WHERE bi.bill = @id", "Cargo");
cmd.Parameters.AddWithValue("@id", id.Value);
using (var dr = new SafeDataReader(cmd.ExecuteReader()))
{
while (dr.Read())
{
this.Add(BillItem.Get(dr));
}
}
}
}
}
protected void Child_Insert(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"INSERT INTO BillRate (itemrate,billingitem,computation1)
VALUES (@itemprice,@billingitem,@computation1)
SELECT SCOPE_IDENTITY()";
cmd.Parameters.AddWithValue("@billingitem", parentId.Value);
cmd.Parameters.AddWithValue("@itemprice", ItemRate);
if (Computation1 != null)
{
cmd.Parameters.AddWithValue("@computation1", Computation1);
}
else
{
cmd.Parameters.AddWithValue("@computation1", DBNull.Value);
}
try
{
int identity = Convert.ToInt32(cmd.ExecuteScalar());
LoadProperty(_Id, identity);
}
catch (Exception)
{
throw;
}
}
}
}
public InvLib.CustomerDetail Fetch(SingleCriteria <InvLib.CustomerDetail, int> criteria)
{
var item = new InvLib.CustomerDetail();
var p = (from r in MockDb.CustomerData
where r.Id == criteria.Value
join l in MockDb.LocationData on r.LocationId equals l.Id
select new { Id = r.Id, Name = r.Name, Lat = l.Lat, Long = l.Long }).Single();
LoadProperty(item, InvLib.CustomerDetail.IdProperty, p.Id);
LoadProperty(item, InvLib.CustomerDetail.NameProperty, p.Name);
LoadProperty(item, InvLib.CustomerDetail.LocationProperty, p.Lat + "/" + p.Long);
var orders = from o in MockDb.OrderData
where o.CustomerId == p.Id
select o;
SetIsReadOnly(item.Orders, false);
foreach (var order in orders)
{
var pli = new InvLib.CustomerOrderInfo();
LoadProperty(pli, InvLib.CustomerOrderInfo.IdProperty, order.Id);
LoadProperty(pli, InvLib.CustomerOrderInfo.OrderDateProperty, order.OrderDate);
var amt = (from li in MockDb.OrderLineItemData
where li.OrderId == order.Id
select li.Price * li.Quantity).Sum();
LoadProperty(pli, InvLib.CustomerOrderInfo.AmountProperty, amt);
item.Orders.Add(pli);
}
SetIsReadOnly(item.Orders, true);
return(item);
}
public void CreateObjectFactoryBusinessItem(SingleCriteria<ObjectFactoryBusinessItem, string> criteria)
{
ObjectFactoryBusinessItem item = new ObjectFactoryBusinessItem();
item.Id = "create_" + criteria.Value;
item.OperationResult = "CreateObjectFactoryBusinessItem/with parameters";
MarkNew(item);
}
public void DeleteObjectFactoryBusinessItem(SingleCriteria <ObjectFactoryBusinessItem, string> criteria)
{
ObjectFactoryBusinessItem item = new ObjectFactoryBusinessItem();
item.Id = "delete_" + criteria.Value;
item.OperationResult = "DeleteObjectFactoryBusinessItem/with parameters";
}
protected void Child_Update(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"UPDATE disbursementitem SET
disbursement = @disbursement,
particulars = @particulars,
amount = @amount
WHERE disbursementitem = @id";
cmd.Parameters.AddWithValue("@disbursement", parentId.Value);
cmd.Parameters.AddWithValue("@particulars", Particulars);
cmd.Parameters.AddWithValue("@amount", Amount);
cmd.Parameters.AddWithValue("@id", this.Id);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
protected void Child_Insert(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"INSERT INTO disbursementitem(disbursement,particulars,amount)
VALUES (@disbursement,@particulars,@amount)
SELECT SCOPE_IDENTITY()";
cmd.Parameters.AddWithValue("@disbursement", parentId.Value);
cmd.Parameters.AddWithValue("@particulars", Particulars);
cmd.Parameters.AddWithValue("@amount", Amount);
try
{
int identity = Convert.ToInt32(cmd.ExecuteScalar());
LoadProperty(_Id, identity);
}
catch (Exception)
{
throw;
}
}
}
}
public void FetchObjectFactoryBusinessItem(SingleCriteria<ObjectFactoryBusinessItem, string> criteria)
{
ObjectFactoryBusinessItem item = new ObjectFactoryBusinessItem();
item.Id = "fetch_" + criteria.Value;
item.OperationResult = "FetchObjectFactoryBusinessItem/with parameters";
MarkOld(item);
}
private void DataPortal_Fetch(SingleCriteria <int> id)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = string.Format(@"
SELECT pd.paymentdetail,pd.payment,pd.bill,pd.partialpayment,pd.amountdue,pd.amountpaid,
pd.paymenttype,pd.bank,pd.branch,pd.refno,pd.refdate,pd.comments,
b.bill as {0}bill,b.billno AS {0}billno,b.billdate as {0}billdate,b.totalbill as {0}totalbill
FROM paymentdetail pd
INNER JOIN bill b ON pd.bill = b.bill
WHERE pd.payment = @id", "Bill");
cmd.Parameters.AddWithValue("@id", id.Value);
using (var dr = new SafeDataReader(cmd.ExecuteReader()))
{
while (dr.Read())
{
this.Add(PaymentDetail.Get(dr));
}
}
}
}
}
protected void Child_Insert(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"INSERT INTO bankaccountdetail(bankaccount,bankname,accountnumber)
VALUES (@bankaccount,@bankname,@accountnumber)
SELECT SCOPE_IDENTITY()";
cmd.Parameters.AddWithValue("@bankaccount", parentId.Value);
cmd.Parameters.AddWithValue("@bankname", BankName);
cmd.Parameters.AddWithValue("@accountnumber", AccountNumber);
try
{
int identity = Convert.ToInt32(cmd.ExecuteScalar());
LoadProperty(_Id, identity);
}
catch (Exception)
{
throw;
}
}
}
}
protected void Child_Insert(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"INSERT INTO vehiclefeeitem(vehiclefee,invoiceno,vehicle,plateno,vehicletype,fee)
VALUES (@vehiclefee,@invoiceno,@vehicle,@plateno,@vehicletype,@fee)
SELECT SCOPE_IDENTITY()";
cmd.Parameters.AddWithValue("@vehiclefee", parentId.Value);
cmd.Parameters.AddWithValue("@invoiceno", InvoiceNo);
cmd.Parameters.AddWithValue("@vehicle", Vehicle);
cmd.Parameters.AddWithValue("@plateno", PlateNo);
cmd.Parameters.AddWithValue("@vehicletype", VehicleType);
cmd.Parameters.AddWithValue("@fee", Fee);
try
{
int identity = Convert.ToInt32(cmd.ExecuteScalar());
LoadProperty(_Id, identity);
}
catch (Exception)
{
throw;
}
}
}
}
protected void Child_Insert(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"INSERT INTO contactaddress(contact,addressname,street,city,province,state,country)
VALUES (@contact,@addressname,@street,@city,@province,@state,@country)
SELECT SCOPE_IDENTITY()";
cmd.Parameters.AddWithValue("@contact", parentId.Value);
cmd.Parameters.AddWithValue("@addressname", AddressName);
cmd.Parameters.AddWithValue("@street", Street);
cmd.Parameters.AddWithValue("@city", City);
cmd.Parameters.AddWithValue("@province", Province);
cmd.Parameters.AddWithValue("@state", State);
cmd.Parameters.AddWithValue("@country", Country);
try
{
int identity = Convert.ToInt32(cmd.ExecuteScalar());
LoadProperty(_Id, identity);
}
catch (Exception)
{
throw;
}
}
}
}
protected void Child_Update(SingleCriteria <int> parentId)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(ConfigHelper.GetDatabase(), false))
{
using (var cmd = ctx.Connection.CreateCommand())
{
cmd.CommandText = @"UPDATE vehiclefeeitem SET
vehiclefee = @vehiclefee,
invoiceno = @invoiceno,
vehicle = @vehicle,
plateno = @plateno,
vehicletype = @vehicletype,
fee = @fee
WHERE vehiclefeeitem = @id";
cmd.Parameters.AddWithValue("@vehiclefee", parentId.Value);
cmd.Parameters.AddWithValue("@invoiceno", InvoiceNo);
cmd.Parameters.AddWithValue("@vehicle", Vehicle);
cmd.Parameters.AddWithValue("@plateno", PlateNo);
cmd.Parameters.AddWithValue("@vehicletype", VehicleType);
cmd.Parameters.AddWithValue("@fee", Fee);
cmd.Parameters.AddWithValue("@id", this.Id);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
public object Fetch(SingleCriteria<Root, string> criteria)
{
var obj = new Root();
obj.Data = criteria.Value;
obj.MarkAsOld();
return obj;
}
private void DataPortal_Fetch(SingleCriteria<MockEditableRoot, Guid> criteria)
{
if (criteria.Value != MockEditableRootId)
throw new Exception();
LoadProperty<Guid>(IdProperty, MockEditableRootId);
LoadProperty<string>(DataPortalMethodProperty, "fetch");
}
public object Create(SingleCriteria<Root, string> criteria)
{
var obj = new Root();
obj.Data = "Create " + criteria.Value;
obj.Location = ApplicationContext.ExecutionLocation;
obj.MarkAsNew();
return obj;
}
public void SerializeCriteriaSuccess()
{
UnitTestContext context = GetContext();
var criteria = new SingleCriteria<SerializationTests, string>("success");
var actual = MobileFormatter.Serialize(criteria);
context.Assert.IsNotNull(actual);
context.Assert.Success();
context.Complete();
}
private void DataPortal_Fetch(SingleCriteria<CompanyInfoList, string> criteria)
{
ExceptionManager.Process(() =>
{
PreFetch();
using (var repository = new Repository())
{
repository.GetCompanyInfos(criteria.Value).ForEach(one => Add(CompanyInfo.GetCompanyInfo(one)));
}
PostFetch();
});
}
public void DataPortal_Fetch(
SingleCriteria<MockEditableRoot, Guid> criteria,
LocalProxy<MockEditableRoot>.CompletedHandler handler)
{
if (criteria.Value != MockEditableRootId)
throw new Exception();
LoadProperty<Guid>(IdProperty, MockEditableRootId);
LoadProperty<string>(DataPortalMethodProperty, "fetch");
handler(this, null);
}
public void DeserializeCriteriaSuccess()
{
UnitTestContext context = GetContext();
var expected = new SingleCriteria<SerializationTests, string>("success");
var buffer = MobileFormatter.Serialize(expected);
var actual = (SingleCriteria<SerializationTests, string>)MobileFormatter.Deserialize(buffer);
context.Assert.AreEqual(expected.Value, actual.Value);
context.Assert.Success();
context.Complete();
}
public void Delete(SingleCriteria<InvLib.ProductEdit, int> criteria)
{
var p = (from r in MockDb.ProductData where r.Id == criteria.Value select r).Single();
MockDb.ProductData.Remove(p);
var b = (from r in MockDb.BinData where r.ProductId == criteria.Value select r);
foreach (var bin in b)
MockDb.BinData.Remove(bin);
var l = (from r in MockDb.OrderLineItemData where r.ProductId == criteria.Value select r);
foreach (var line in l)
MockDb.OrderLineItemData.Remove(line);
}
public InvLib.ProductEdit Fetch(SingleCriteria<InvLib.ProductEdit, int> criteria)
{
var item = new InvLib.ProductEdit();
using (BypassPropertyChecks(item))
{
var p = (from r in MockDb.ProductData where r.Id == criteria.Value select r).Single();
LoadProperty(item, InvLib.ProductEdit.IdProperty, p.Id);
item.Name = p.Name;
item.Price = p.Price;
item.CategoryId = p.CategoryId;
}
MarkOld(item);
return item;
}
private void DataPortal_Fetch(SingleCriteria<CompanyEdit, int> criteria)
{
ExceptionManager.Process(
() =>
{
using (var repository = new Repository())
{
var dto = repository.GetCompany(criteria.Value);
LoadProperty(CompanyIDProperty, dto.CompanyID);
LoadProperty(CompanyNameProperty, dto.CompanyName);
LoadProperty(NotesProperty, dto.Notes);
LoadProperty(EmployeesProperty, EmlpoyeeEditList.GetEmlpoyeeEditList(dto));
}
});
}
public TweekedCsla.Order Fetch(SingleCriteria<TweekedCsla.Order, int> criteria)
{
// Using AutoMapper
return new OrderTranslator().From(OrderRepository.FetchById(criteria.Value));
// Without automapper.
// TweekedCsla.Order obj = TweekedCsla.Order.NewOrder();
// MarkOld(obj);
//
// OrderModel data = OrderRepository.FetchById(criteria.Value);
// using (BypassPropertyChecks(obj))
// {
// LoadProperty(obj, TweekedCsla.Order.IdProperty, data.Id);
//
// obj.CustomerName = data.CustomerName;
//
// LineItems list = LineItems.NewList();
// foreach (LineItemModel item in data.LineItems)
// {
// LineItem current = LineItem.NewItem();
// MarkOld(current);
//
//
// using (BypassPropertyChecks(current))
// {
// LoadProperty(current, LineItem.IdProperty, item.Id);
// LoadProperty(current, LineItem.NameProperty, item.Name);
// }
//
// CheckRules(current);
// list.Add(current);
// }
//
// LoadProperty(obj, TweekedCsla.Order.LineItemsProperty, list);
// }
// CheckRules(obj);
// return obj;
}
public void DataPortal_Delete(
SingleCriteria<MockEditableRoot, Guid> criteria,
LocalProxy<MockEditableRoot>.CompletedHandler handler)
{
LoadProperty<string>(DataPortalMethodProperty, "delete");
handler(this, null);
}
private void DataPortal_Delete(SingleCriteria<MockEditableRoot, Guid> criteria)
{
Guid id = ReadProperty<Guid>(IdProperty);
if (id != MockEditableRootId)
throw new Exception();
LoadProperty<string>(DataPortalMethodProperty, "delete");
}
public void DataPortal_Fetch(SingleCriteria<MockList, string> criteria)
{
Fetch(criteria.Value);
}
private void DataPortal_Fetch(SingleCriteria<ReadOnlyPerson, Guid> criteria)
{
LoadProperty<Guid>(IdProperty, criteria.Value);
LoadProperty(NameProperty, criteria.Value.ToString());
LoadProperty(BirthdateProperty, new DateTime(1980, 1, 1));
}
public void Delete(SingleCriteria<Order, int> criteria)
{
// delete data
Console.WriteLine("Deleting order id: {0}", criteria.Value);
}
public void DataPortal_Delete(
SingleCriteria<MockEditableRoot, Guid> criteria)
{
LoadProperty<string>(DataPortalMethodProperty, "delete");
}
public void DeleteObjectFactoryBusinessItem(SingleCriteria<ObjectFactoryBusinessItem, string> criteria)
{
ObjectFactoryBusinessItem item = new ObjectFactoryBusinessItem();
item.Id = "delete_" + criteria.Value;
item.OperationResult = "DeleteObjectFactoryBusinessItem/with parameters";
}
public void Delete(SingleCriteria<Root, string> criteria)
{
Csla.ApplicationContext.GlobalContext["ObjectFactory"] = "Delete";
}
public void Delete(SingleCriteria<TweekedCsla.Order, int> criteria)
{
OrderRepository.DeleteById(criteria.Value);
}
public void DataPortal_Fetch(SingleCriteria<MockList, string> criteria, LocalProxy<MockList>.CompletedHandler completed)
{
Fetch(criteria.Value, completed);
}
