partial void UpdateTbl_Deal(Tbl_Deal instance);
partial void DeleteTbl_Deal(Tbl_Deal instance);
private void detach_Tbl_Deals1(Tbl_Deal entity)
{
this.SendPropertyChanging();
entity.Tbl_UserAccess1 = null;
}
partial void InsertTbl_Deal(Tbl_Deal instance);
private void attach_Tbl_Deals(Tbl_Deal entity)
{
this.SendPropertyChanging();
entity.Tbl_UserAccess = this;
}
private void detach_Tbl_Deals(Tbl_Deal entity)
{
this.SendPropertyChanging();
entity.Tbl_DealPriceCategory = null;
}
private void attach_Tbl_Deals(Tbl_Deal entity)
{
this.SendPropertyChanging();
entity.Tbl_DealCategory = this;
}
private void detach_Tbl_Deals(Tbl_Deal entity)
{
this.SendPropertyChanging();
entity.Tbl_DealType = null;
}
public int ShareTheDeal(string dealTitle, string dealDesc, decimal dealPrice, int dealCategory, string dealUrl, byte[] imageData,string userName,DateTime dealStartDate,DateTime dealEndDate)
{
int latestDealId;
int priceCategory;
int userAccessId;
using (var context = DataAccess.GetNoTrackingDataContext())
{
latestDealId = DealsCompiledQueries.FunGetLatestDealID(context);
}
using (var context = DataAccess.GetNoTrackingDataContext())
{
priceCategory = DealsCompiledQueries.FunGetDealPriceCategoryID(context, dealPrice);
}
using (var context = DataAccess.GetNoTrackingDataContext())
{
userAccessId = UserCompiledQueries.FunGetUserAccessID(context, userName);
}
using (var context = DataAccess.GetDataContext())
{
var deal = new Tbl_Deal
{
UserAccessID = userAccessId,
DealURL = dealUrl,
DealStatus = 2,
DealPrice = dealPrice,
DealTopicName = dealTitle,
DealDescription = dealDesc,
DealDegree = 0,
DealPostedDate = DateTime.Now,
ApprovedBy = userAccessId,
DealType = 10,
DealPicture = "/Test/Test.jpg",
DealStartDate = dealStartDate,
DealEndDate = dealEndDate,
DealCategoryId = dealCategory,
DealPriceCategoryId = priceCategory,
DealImageData = imageData
};
context.Tbl_Deals.InsertOnSubmit(deal);
context.SubmitChanges();
}
return latestDealId + 1;
}
