public Response Insert(TitikLokasi data, bool isCommit = true)
{
string message = "Failed";
bool result = false;
Response res = new Response();
try
{
db.Set <TitikLokasi>().Add(data);
if (isCommit)
{
db.SaveChanges();
message = "Save data bank success";
result = true;
}
res.ID = data.ID;
res.Message = message;
res.Result = result;
return(res);
}
catch (Exception ex)
{
res.Message = ex.Message;
res.Result = false;
return(res);
}
}
public Response Update(TitikLokasi data, bool isCommit = true)
{
string message = "Failed";
bool result = false;
Response res = new Response();
try
{
if (data.ID != Guid.Empty)
{
var temp = (from x in db.TitikLokasi
where x.ID == data.ID
select x).FirstOrDefault();
temp.KelasJalan = data.KelasJalan;
temp.AdaKontruksi = data.AdaKontruksi;
temp.Address = data.Address;
temp.AddressReal = data.AddressReal;
temp.AdvTypeID = data.AdvTypeID;
temp.Cabang = data.Cabang;
temp.KodeFile = data.KodeFile;
temp.Kota = data.Kota;
temp.Lampu = data.Lampu;
temp.LastUpdateByUserID = data.LastUpdateByUserID;
temp.LastUpdateDate = DateTime.Now;
temp.Latitude = data.Latitude;
temp.Longitude = data.Longitude;
temp.NoBillboard = data.NoBillboard;
temp.PIC = data.PIC;
temp.Provinsi = data.Provinsi;
temp.Pulau = data.Pulau;
temp.Status = data.Status;
temp.Tinggi = data.Tinggi;
temp.TransaksiCount = data.TransaksiCount;
temp.Type = data.Type;
temp.LastUpdateByUserID = data.LastUpdateByUserID;
temp.LastUpdateDate = data.LastUpdateDate;
temp.TotalView = data.TotalView;
if (isCommit)
{
db.SaveChanges();
message = "Save data bank success";
result = true;
}
}
res.ID = data.ID;
res.Message = message;
res.Result = result;
return(res);
}
catch (Exception ex)
{
res.Message = ex.Message;
res.Result = false;
return(res);
}
}
