public string SaveUpdateVisit(VisitModel model) { ShomaRMEntities db = new ShomaRMEntities(); string msg = ""; var visitID = db.tbl_Visit.Where(p => p.VisitID == model.VisitID).FirstOrDefault(); if (model.VisitID == 0) { var saveVisit = new tbl_Visit() { VisitID = model.VisitID, ProspectID = model.ProspectID, VisitDateTime = model.VisitDateTime, ResultCode = model.ResultCode, VisitNumber = model.VisitNumber, Details = model.Details, Activity = model.Activity, VisitIncharge = model.VisitIncharge, VisitSlot = model.VisitSlot, }; db.tbl_Visit.Add(saveVisit); db.SaveChanges(); msg = "Visit Saved Successfully"; } else { var visitData = db.tbl_Visit.Where(p => p.VisitID == model.VisitID).FirstOrDefault(); if (visitData != null) { visitData.VisitID = model.VisitID; visitData.ProspectID = model.ProspectID; visitData.VisitDateTime = model.VisitDateTime; visitData.ResultCode = model.ResultCode; visitData.VisitNumber = model.VisitNumber; visitData.Details = model.Details; visitData.Activity = model.Activity; visitData.VisitIncharge = model.VisitIncharge; visitData.VisitSlot = model.VisitSlot; } db.SaveChanges(); msg = "Visit Updated Successfully"; } db.Dispose(); return(msg); }
public static void addVisitPass(int iw, int ip) { using (AquaparkDBDataContext db = new AquaparkDBDataContext()) { var insVis = new tbl_Visit { StartTime = DateTime.Now, StopTime = null, IDWatch = iw, IDPriceEntry = null, IDPass = ip }; db.tbl_Visits.InsertOnSubmit(insVis); db.SubmitChanges(); } }