public static int Save(tblMRNoteDTO tblMRNoteDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblMRNote = tblMRNoteDTO.ToEntity(); if (tblMRNoteDTO.MRId == 0) { dbObject.tblMRNotes.Add(tblMRNote); } else { tblMRNote = dbObject.tblMRNotes.Find(tblMRNoteDTO.MRId); tblMRNote.MrNo = tblMRNoteDTO.MrNo; tblMRNote.BillId = tblMRNoteDTO.BillId; tblMRNote.MRDate = tblMRNoteDTO.MRDate; tblMRNote.RecievedFrom = tblMRNoteDTO.RecievedFrom; tblMRNote.LocationFrom = tblMRNoteDTO.LocationFrom; tblMRNote.LocationTo = tblMRNoteDTO.LocationTo; tblMRNote.NoofPackages = tblMRNoteDTO.NoofPackages; tblMRNote.Weight = tblMRNoteDTO.Weight; tblMRNote.AmountRecieved = tblMRNoteDTO.AmountRecieved; tblMRNote.WayOfRecieve = tblMRNoteDTO.WayOfRecieve; tblMRNote.Fright = tblMRNoteDTO.Fright; tblMRNote.StCharges = tblMRNoteDTO.StCharges; tblMRNote.Hamali = tblMRNoteDTO.Hamali; tblMRNote.Other1 = tblMRNoteDTO.Other1; tblMRNote.Other2 = tblMRNoteDTO.Other2; tblMRNote.Other3 = tblMRNoteDTO.Other3; tblMRNote.Other4 = tblMRNoteDTO.Other4; tblMRNote.TotalAmount = tblMRNoteDTO.TotalAmount; } dbObject.SaveChanges(); return(tblMRNote.MRId); } }