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