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; }