public static OrganizationDiaryDetails GetById(string id) { OrganizationDiaryDetails details = null; if (string.IsNullOrEmpty(id)) { return(details); } using (pm2Entities entities = new pm2Entities()) { return((from m in entities.Bud_OrgDiaryDetails where m.OrgDiaryDetailsId == id select new OrganizationDiaryDetails { Id = m.OrgDiaryDetailsId, Code = m.OrgdetailsCode, Amount = m.Amount, Name = m.Name, CBSCode = m.CBSCode, Note = m.Note, InDiaryId = m.Bud_OrgDiaryCost.OrgDiaryId }).FirstOrDefault <OrganizationDiaryDetails>()); } }
public void Add(OrganizationDiaryDetails orgDetails) { if (orgDetails != null) { using (pm2Entities entities = new pm2Entities()) { Bud_OrgDiaryCost cost = (from m in entities.Bud_OrgDiaryCost where m.OrgDiaryId == orgDetails.InDiaryId select m).FirstOrDefault <Bud_OrgDiaryCost>(); Bud_OrgDiaryDetails details = new Bud_OrgDiaryDetails { OrgDiaryDetailsId = orgDetails.Id, OrgdetailsCode = orgDetails.Code, Name = orgDetails.Name, CBSCode = orgDetails.CBSCode, Bud_OrgDiaryCost = cost, Amount = orgDetails.Amount, Note = orgDetails.Note }; entities.AddToBud_OrgDiaryDetails(details); entities.SaveChanges(); } } }