public void AddNewAddress(skAddresses AddressObject, int ObjectID, Type ObjectType)
{
if (ObjectType.Name == "skPerson")
{
dtAddress NewAdress = new dtAddress
{
AddressLine1 = AddressObject.AddressLine1,
AddressLine2 = AddressObject.AddressLine2,
AddressLine3 = AddressObject.AddressLine3,
Country = AddressObject.Country,
County = AddressObject.County,
PostCode = AddressObject.PostCode,
Town = AddressObject.Town,
isActive = true,
Created = DateTime.Now,
Updated = DateTime.Now
};
dtAddressPersonRelationShip relationship = new dtAddressPersonRelationShip
{
dtAddress = NewAdress,
PersonID = ObjectID
};
DB.dtAddressPersonRelationShips.InsertOnSubmit(relationship);
DB.SubmitChanges();
}
else
{
dtAddress NewAdress = new dtAddress
{
AddressLine1 = AddressObject.AddressLine1,
AddressLine2 = AddressObject.AddressLine2,
AddressLine3 = AddressObject.AddressLine3,
Country = AddressObject.Country,
County = AddressObject.County,
PostCode = AddressObject.PostCode,
Town = AddressObject.Town,
isActive = true,
Created = DateTime.Now,
Updated = DateTime.Now
};
DB.dtAddresses.InsertOnSubmit(NewAdress);
DB.SubmitChanges();
dtVendor vendor = DB.dtVendors.Where(x => x.vID == ObjectID).Single();
vendor.AddresseID = DB.dtAddresses.OrderByDescending(x => x.Created).Single().aID;
DB.SubmitChanges();
}
}
public PurchaseDetailsViewModel()
{
if (DesignerProperties.GetIsInDesignMode(new System.Windows.DependencyObject()))
{
return;
}
Data = new DataFunctions();
_PurchaseObj = Data.GetPurchaseDetails(StaticDataReposityory.SelectedSaleID);
if (_PurchaseObj.VendorId != null)
{
_VendorObj = Data.GetVendorDetails(Convert.ToInt32(_PurchaseObj.VendorId));
_Addressobj = Data.GetAddressObject(Convert.ToInt32(_VendorObj.AddresseID));
}
}
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 UpdateAddress(skAddresses AddressObject)
{
if (AddressObject != null)
{
dtAddress addressobject = DB.dtAddresses.Single(x => x.aID == AddressObject.AddressID);
addressobject.AddressLine1 = addressobject.AddressLine1;
addressobject.AddressLine2 = addressobject.AddressLine2;
addressobject.AddressLine3 = addressobject.AddressLine3;
addressobject.Country = addressobject.Country;
addressobject.County = addressobject.County;
addressobject.PostCode = addressobject.PostCode;
addressobject.Town = addressobject.Town;
addressobject.Updated = DateTime.Now;
DB.SubmitChanges();
}
}
public void AddNewAddress(skAddresses AddressObject)
{
if (AddressObject != null)
{
dtAddress NewAdress = new dtAddress
{
AddressLine1 = AddressObject.AddressLine1,
AddressLine2 = AddressObject.AddressLine2,
AddressLine3 = AddressObject.AddressLine3,
Country = AddressObject.Country,
County = AddressObject.County,
PostCode = AddressObject.PostCode,
Town = AddressObject.Town,
isActive = true,
Created = DateTime.Now,
Updated = DateTime.Now
};
DB.dtAddresses.InsertOnSubmit(NewAdress);
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 NewVendorViewModel()
{
if (DesignerProperties.GetIsInDesignMode(new System.Windows.DependencyObject()))
{
return;
}
try
{
if (DesignerProperties.GetIsInDesignMode(new System.Windows.DependencyObject()))
{
return;
}
_VendorObj = new skvendors();
_AddressObj = new skAddresses();
AddressesList = new ObservableCollection <skAddresses>(skAddresses.GetAddressList());
InitialiseCommands();
}
catch (Exception E)
{
ExepionLogger.Logger.LogException(E);
ExepionLogger.Logger.Show(E);
}
}
public bool AddNewVendor(skvendors VendorObj, skAddresses AddressObject)
{
if (VendorObj != null)
{
dtVendor NewVendor = new dtVendor
{
VendorsName = VendorObj.VendorsName,
VendorsDescption = VendorObj.VendorsDescption,
OnlineVender = VendorObj.onlineVendor,
};
dtAddress NewAdress = new dtAddress
{
AddressLine1 = AddressObject.AddressLine1,
AddressLine2 = AddressObject.AddressLine2,
AddressLine3 = AddressObject.AddressLine3,
Country = AddressObject.Country,
County = AddressObject.County,
PostCode = AddressObject.PostCode,
Town = AddressObject.Town,
isActive = true
};
NewAdress.dtVendors.Add(NewVendor);
DB.dtAddresses.InsertOnSubmit(NewAdress);
DB.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
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 AddNewAddress(skAddresses AddressObject)
{
base.Channel.AddNewAddress(AddressObject);
}
public void AddNewVendor(skvendors VendorObject, skAddresses AddressObject)
{
base.Channel.AddNewVendor(VendorObject, AddressObject);
}
public void AddNewSale(skAddresses AddressObject, skPerson PersonObject, skSales TransactionObject, int UserID)
{
TransactionRepo.AddNewSale(TransactionObject, PersonObject, AddressObject, UserID);
}
public void AddNewAddress(skAddresses AddressObject, int ObjectID, Type ObjectType)
{
AddressRepo.AddNewAddress(AddressObject, ObjectID, ObjectType);
}
public void AddNewPerson(skPerson PersonObject, skAddresses AddressObject)
{
PersonRepo.AddNewPerson(PersonObject, AddressObject);
}
public void AddNewVendor(skvendors VendorObject, skAddresses AddressObject)
{
VendorRepo.AddNewVendor(VendorObject, AddressObject);
}
public void AddNewAddress(skAddresses AddressObject)
{
AddressRepo.AddNewAddress(AddressObject);
}
public void AddNewPerson(skPerson PersonObject, skAddresses AddressObject)
{
base.Channel.AddNewPerson(PersonObject, AddressObject);
}
public void AddNewSale(skAddresses AddressObject, skPerson PersonObject, skSales TransactionObject, int UserID)
{
base.Channel.AddNewSale(AddressObject, PersonObject, TransactionObject, UserID);
}
public void AddNewAddress(skAddresses AddressObject, int ObjectID, Type ObjectType)
{
base.Channel.AddNewAddress(AddressObject, ObjectID, ObjectType);
}