public static void Load(this skPerson Object)
{
ObjectMessenger OM = new ObjectMessenger();
OM.Send("PersonObject", Object);
UI.Enviroment.LoadNewTab("PersonDetailsView", Object.FullName);
}
public void AddNewPerson(skPerson PersonObject, int AddressID)
{
if (PersonObject != null)
{
dtPerson newperson = new dtPerson
{
EbayName = PersonObject.EbayName,
Email = PersonObject.Email,
FirstName = PersonObject.FirstName,
HomePhone = PersonObject.HomePhone,
SureName = PersonObject.Surname,
WorkPhone = PersonObject.WorkPhone,
Created = DateTime.Now,
Updated = DateTime.Now
};
dtAddressPersonRelationShip relationship = new dtAddressPersonRelationShip
{
AddressID = AddressID,
dtPerson = newperson
};
DB.dtAddressPersonRelationShips.InsertOnSubmit(relationship);
DB.SubmitChanges();
}
}
public void UpdatePerson(skPerson PersonObject)
{
dtPerson person = DB.dtPersons.SingleOrDefault(x => x.pID == PersonObject.pID);
person.EbayName = PersonObject.EbayName;
person.FirstName = PersonObject.FirstName;
person.SureName = PersonObject.Surname;
person.Email = PersonObject.Email;
person.WorkPhone = PersonObject.WorkPhone;
person.HomePhone = PersonObject.HomePhone;
person.Updated = DateTime.Now;
DB.SubmitChanges();
}
public NewPersonViewModel()
{
try
{
AddressObject = new skAddresses();
PersonObject = new skPerson();
_AddNewPerson = new Command(Submit);
AddressList = new ObservableCollection <skAddresses>(skAddresses.GetAddressList());
}
catch (Exception e)
{
ExepionLogger.Logger.LogException(e);
ExepionLogger.Logger.Show(e);
}
}
public void AddNewPerson(skPerson PersonObject)
{
if (PersonObject != null)
{
dtPerson newperson = new dtPerson
{
EbayName = PersonObject.EbayName,
Email = PersonObject.Email,
FirstName = PersonObject.FirstName,
HomePhone = PersonObject.HomePhone,
SureName = PersonObject.Surname,
WorkPhone = PersonObject.WorkPhone,
Created = DateTime.Now,
Updated = DateTime.Now
};
DB.dtPersons.InsertOnSubmit(newperson);
DB.SubmitChanges();
}
}
public void AddNewPerson(skPerson PersonObject, skAddresses AddressObject)
{
if (PersonObject != null)
{
dtPerson newperson = new dtPerson
{
EbayName = PersonObject.EbayName,
Email = PersonObject.Email,
FirstName = PersonObject.FirstName,
HomePhone = PersonObject.HomePhone,
SureName = PersonObject.Surname,
WorkPhone = PersonObject.WorkPhone,
Created = DateTime.Now,
Updated = DateTime.Now
};
dtAddress newaddress = new dtAddress
{
AddressLine1 = AddressObject.AddressLine1,
AddressLine2 = AddressObject.AddressLine2,
AddressLine3 = AddressObject.AddressLine3,
Country = AddressObject.Country,
County = AddressObject.County,
PostCode = AddressObject.PostCode,
isActive = true,
Town = AddressObject.Town
};
dtAddressPersonRelationShip relationship = new dtAddressPersonRelationShip
{
dtAddress = newaddress,
dtPerson = newperson
};
DB.dtAddressPersonRelationShips.InsertOnSubmit(relationship);
DB.SubmitChanges();
}
}
public NewAddressViewModel()
{
_SubmitNewAddressCommand = new Command(SubmitNewAddressMethod);
_AddressObject = new skAddresses();
object LinkObject = ObjectMessenger.FindObject("ADDRESSLINKOBJECT");
if (LinkObject != null)
{
Type ObjectType = LinkObject.GetType();
switch (ObjectType.Name)
{
case "skPerson":
PersonObject = LinkObject as skPerson;
break;
case "skvendors":
VendorObject = LinkObject as skvendors;
break;
}
}
}
public void AddNewPerson(skPerson PersonObject, skAddresses AddressObject)
{
base.Channel.AddNewPerson(PersonObject, AddressObject);
}
public void AddNewSale(skSales TransactionObject, skPerson PersonObject, skAddresses AddressObject, int UserID)
{
PersonRepo PersonRepo = new PersonRepo();
PersonRepo.AddNewPerson(PersonObject, AddressObject);
var personid = DB.dtPersons.OrderBy(x => x.Created).FirstOrDefault().pID;
dtSale newtransaction = new dtSale
{
SoldValue = TransactionObject.Amount,
PaypayFees = TransactionObject.PayPalFees,
PandP = TransactionObject.Postage,
SaleMethod = TransactionObject.SaleMethod,
SoldDate = TransactionObject.SaleDate,
SoldBy = UserID,
PayPalTransactionID = TransactionObject.PayPalTransactionID,
Created = DateTime.Now,
Updated = DateTime.Now,
Title = TransactionObject.Title,
Description = TransactionObject.Description,
PersonID = personid
};
DB.dtSales.InsertOnSubmit(newtransaction);
DB.SubmitChanges();
int tid = MostRecentsalesID();
decimal pvalue = Math.Abs(Convert.ToDecimal(TransactionObject.PayPalFees)) * (-1);
decimal ppvalue = Math.Abs(Convert.ToDecimal(TransactionObject.Postage)) * (-1);
dtTransactionLedger newsaleledger = new dtTransactionLedger
{
SaleID = tid,
PurchaseID = null,
TotelAmount = Convert.ToDecimal(TransactionObject.Amount),
TransactionType = "Item Sale",
TransactionDateTime = Convert.ToDateTime(TransactionObject.SaleDate)
};
dtTransactionLedger newspaypal = new dtTransactionLedger
{
SaleID = tid,
PurchaseID = null,
TotelAmount = pvalue,
TransactionType = "PayPal Fees",
TransactionDateTime = Convert.ToDateTime(TransactionObject.SaleDate)
};
dtTransactionLedger newepostage = new dtTransactionLedger
{
SaleID = tid,
PurchaseID = null,
TotelAmount = ppvalue,
TransactionType = "Sale Postage",
TransactionDateTime = Convert.ToDateTime(TransactionObject.SaleDate)
};
foreach (skStock s in TransactionObject.StockList)
{
dtStockHistory newstatus = new dtStockHistory
{
StoockID = Convert.ToInt32(s.Stockid),
Status = "Stock Sold",
Value = 0,
UserID = UserID,
Created = DateTime.Now,
StatusID = 1
};
DB.dtStockHistories.InsertOnSubmit(newstatus);
dtStockDetail SD = DB.dtStockDetails.Single(x => x.StockID == s.Stockid);
SD.SaleValue = s.SaleValue;
}
List <long> StockIds = new List <long>();
foreach (skStock s in TransactionObject.StockList)
{
StockIds.Add(s.Stockid);
}
var setsold = from ST in DB.dtStocks
where StockIds.Contains(ST.sID)
select ST;
foreach (dtStock s in setsold)
{
s.Sold = true;
s.SaleID = tid;
}
DB.dtTransactionLedgers.InsertOnSubmit(newspaypal);
DB.dtTransactionLedgers.InsertOnSubmit(newepostage);
DB.dtTransactionLedgers.InsertOnSubmit(newsaleledger);
DB.SubmitChanges();
}
public void UpdatePerson(skPerson PersonObject)
{
PersonRepo.UpdatePerson(PersonObject);
}
public void AddNewSale(skAddresses AddressObject, skPerson PersonObject, skSales TransactionObject, int UserID)
{
TransactionRepo.AddNewSale(TransactionObject, PersonObject, AddressObject, UserID);
}
public void AddNewPerson(skPerson PersonObject, skAddresses AddressObject)
{
PersonRepo.AddNewPerson(PersonObject, AddressObject);
}
public void AddNewPerson(skPerson PersonObject, int AddressID)
{
PersonRepo.AddNewPerson(PersonObject, AddressID);
}
public void AddNewPerson(skPerson PersonObject)
{
PersonRepo.AddNewPerson(PersonObject);
}
public void AddNewPerson(skPerson PersonObject, int AddressID)
{
base.Channel.AddNewPerson(PersonObject, AddressID);
}
public void AddNewPerson(skPerson PersonObject)
{
base.Channel.AddNewPerson(PersonObject);
}
public void UpdatePerson(skPerson PersonObject)
{
base.Channel.UpdatePerson(PersonObject);
}
public void AddNewSale(skAddresses AddressObject, skPerson PersonObject, skSales TransactionObject, int UserID)
{
base.Channel.AddNewSale(AddressObject, PersonObject, TransactionObject, UserID);
}
