public void DeleteData(int IDDetail)
{
DetailDocument de = db.DetailDocuments.Where(x => x.IDDetail == IDDetail).SingleOrDefault();
db.DetailDocuments.DeleteOnSubmit(de);
db.SubmitChanges();
}
public static MasterDocument BuildSimpleMasterAndDetail(out DetailDocument detail)
{
var master = new MasterDocument
{
Id = 1,
Name = "Chips",
DetailPlaceHolders = new DocumentPlaceholderCollection <DetailDocument, WhatMasterNeedsToKnowAboutDetail>()
};
var masterData = new WhatDetailNeedsToKnowAboutMaster {
Name = master.Name
};
detail = new DetailDocument
{
Id = 25,
Name = "Cheetos"
};
var detailData = new WhatMasterNeedsToKnowAboutDetail {
Name = detail.Name
};
detail.MasterDocumentPointer =
DocumentPlaceholder <MasterDocument, WhatDetailNeedsToKnowAboutMaster>
.CreatePlaceholderAndUpdateReverseCollection(master.Id, masterData, master.DetailPlaceHolders, detail.Id, detailData);
return(master);
}
private static void AssertPointIdAndKeyOnCollectionReverse(DetailDocument detail)
{
var placeholder = detail.MasterDocumentPointer;
Assert.IsNotNull(placeholder);
Assert.AreEqual("MasterDocuments/1", placeholder.DocKey);
Assert.AreEqual("Chips", placeholder.Data.Name);
}
public void Should_serialize_collection_pointers_reversely()
{
DetailDocument detail;
Helpers.BuildSimpleMasterAndDetail(out detail);
DetailDocument detail2 = Helpers.SerializeCopyWithJSON(detail);
AssertPointIdAndKeyOnCollectionReverse(detail2);
}
public void UpdateData(int IDDetail, string StyleNo, string MaterialStyle, string MaterialDetails, string Unit, float NumberRequest, float NumberReceived, decimal price, decimal TotalAmount)
{
DetailDocument de = db.DetailDocuments.Where(x => x.IDDetail == IDDetail).SingleOrDefault();
de.StyleNo = StyleNo;
de.MaterialStyle = MaterialStyle;
de.MaterialDetails = MaterialDetails;
de.Unit = Unit;
de.NumberRequest = NumberRequest;
de.NumberReceived = NumberReceived;
de.Price = price;
de.TotalAmount = TotalAmount;
db.SubmitChanges();
}
public void InsertData(int IDDocument, string StyleNo, string MaterialStyle, string MaterialDetails, string Unit, float NumberRequest, float NumberReceived, decimal price, decimal TotalAmount)
{
DetailDocument de = new DetailDocument();
de.IDDocument = IDDocument;
de.StyleNo = StyleNo;
de.MaterialStyle = MaterialStyle;
de.MaterialDetails = MaterialDetails;
de.Unit = Unit;
de.NumberRequest = NumberRequest;
de.NumberReceived = NumberReceived;
de.Price = price;
de.TotalAmount = TotalAmount;
db.DetailDocuments.InsertOnSubmit(de);
db.SubmitChanges();
}
private static void AssertPointIdAndKeyOnCollectionReverse(DetailDocument detail)
{
var placeholder = detail.MasterDocumentPointer;
Assert.IsNotNull(placeholder);
Assert.AreEqual("MasterDocuments/1", placeholder.DocKey);
Assert.AreEqual("Chips", placeholder.Data.Name);
}