public Certificate360 Map(Certificate360 certificate,
Premise certPremise,
HalalTeam certHalalTeam)
{
if (!_certificateCache.TryGetValue(certificate.ID, out Certificate360 result))
{
certificate.Teams = new List <HalalTeam>();
certificate.Premise = new Premise();
_certificateCache[certificate.ID] = certificate;
result = certificate;
}
if (certPremise.ID != 0)
{
if (!_certPremiseCache.TryGetValue(certPremise.ID, out Premise certPremiseOut))
{
_certPremiseCache[certPremise.ID] = certPremise;
certPremiseOut = certPremise;
result.Premise = certPremise;
}
}
if (certHalalTeam.ID != 0)
{
if (!_certHalalTeamCache.ContainsKey(certHalalTeam.ID))
{
_certHalalTeamCache[certHalalTeam.ID] = certHalalTeam;
result.Teams.Add(certHalalTeam);
}
}
return(result);
}
public ActionResult InlineEditingDeletePartial(int premiseID)
{
using (MyDbContext myDbContext = new MyDbContext())
{
if (premiseID != 0)
{
try
{
Premise premise = myDbContext.Premises.Find(premiseID);
myDbContext.Premises.Remove(premise);
myDbContext.SaveChanges();
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
}
ViewBag.CountryID = myDbContext.Countries.OrderBy(c => c.CountryID).ToList();
return(PartialView("GridViewPartial", myDbContext.Premises.ToList()));
}
}
public async Task InsertOrReplace(Premise premise)
{
var param = new DynamicParameters();
param.Add("@ID", premise.ID);
param.Add("@Name", premise.Name);
param.Add("@IsLocal", premise.IsLocal);
param.Add("@Type", premise.Type);
param.Add("@Area", premise.Area);
param.Add("@Schedule", premise.Schedule);
param.Add("@BlockNo", premise.ID);
param.Add("@UnitNo", premise.UnitNo);
param.Add("@FloorNo", premise.FloorNo);
param.Add("@BuildingName", premise.BuildingName);
param.Add("@Address1", premise.Address1);
param.Add("@Address2", premise.Address2);
param.Add("@City", premise.City);
param.Add("@Province", premise.Province);
param.Add("@Country", premise.Country);
param.Add("@Postal", premise.Postal);
param.Add("@Longtitude", premise.Longitude);
param.Add("@Latitude", premise.Latitude);
param.Add("@Grade", premise.Grade);
param.Add("@IsHighPriority", premise.IsHighPriority);
await SqlMapper.ExecuteAsync(_unitOfWork.Connection,
"InsertOrReplacePremise",
param,
commandType : CommandType.StoredProcedure,
transaction : _unitOfWork.Transaction);
}
public Model.Request Map(Model.Request request,
Code customerCode,
Code groupCode,
HalalTeam halal,
Premise premise,
Characteristic characteristic,
RFA rfa,
Log log,
Attachment attachment,
RequestLineItem lineItem,
Review review,
ReviewLineItem reviewLineItem,
Characteristic lineItemChar)
{
return(InternalMap(request,
customerCode,
groupCode,
lineItem,
lineItemChar,
halal,
premise,
characteristic,
attachment,
rfa,
log,
review,
reviewLineItem));
}
public Premise MapEntityToObject(TWMPREMISE entity)
{
if (entity != null)
{
Premise obj = new Premise();
obj.CD_DIST = entity.CD_DIST;
obj.CD_WR = entity.CD_WR;
obj.ID_PREMISE = entity.ID_PREMISE;
obj.CD_SIC = entity.CD_SIC;
obj.CD_RATE_CLASS = entity.CD_RATE_CLASS;
obj.CD_REVENUE_CLASS = entity.CD_REVENUE_CLASS;
obj.CD_ADDRESS = entity.CD_ADDRESS;
obj.FG_HAZARD = entity.FG_HAZARD;
obj.FG_KEY_AVAIL = entity.FG_KEY_AVAIL;
obj.QT_BASELOAD = entity.QT_BASELOAD;
obj.QT_HEATING_FACTOR = entity.QT_HEATING_FACTOR;
obj.ID_SERVICE = entity.ID_SERVICE;
if (entity.TWMPREMISEMOREs != null && entity.TWMPREMISEMOREs.Count > 0)
{
obj.PremiseMore = new PremiseMoreBl().Get(entity.TWMPREMISEMOREs);
}
return(obj);
}
return(null);
}
public Certificate Map(Certificate certificate,
Premise premise = null,
Premise mailingPremise = null,
Menu menu = null)
{
if (!_cache.TryGetValue(certificate.ID, out Certificate result))
{
result = certificate;
certificate.Premise = premise;
certificate.MailingPremise = mailingPremise;
_cache[certificate.ID] = certificate;
}
if ((menu?.ID ?? 0) > 0 &&
!_menuCache.ContainsKey(menu.ID))
{
_menuCache[menu.ID] = menu;
if (result.Menus == null)
{
result.Menus = new List <Menu>();
}
result.Menus.Add(menu);
}
return(result);
}
public async Task UpdateRequestPremise(Premise premise, long RequestID)
{
var param = new DynamicParameters();
param.Add("@ID", premise.ID);
param.Add("@IsLocal", premise.Type);
param.Add("@Name", premise.Name);
param.Add("@Type", premise.Type);
param.Add("@Area", premise.Area);
param.Add("@Schedule", premise.Schedule);
param.Add("@BlockNo", premise.BlockNo);
param.Add("@UnitNo", premise.UnitNo);
param.Add("@FloorNo", premise.FloorNo);
param.Add("@BuildingName", premise.BuildingName);
param.Add("@Address1", premise.Address1);
param.Add("@Address2", premise.Address2);
param.Add("@City", premise.City);
param.Add("@Province", premise.Province);
param.Add("@Country", premise.Country);
param.Add("@Postal", premise.Postal);
param.Add("@Longitude", premise.Longitude);
param.Add("@Latitude", premise.Latitude);
param.Add("@CreatedOn", premise.CreatedOn);
param.Add("@ModifiedOn", premise.ModifiedOn);
param.Add("@IsDeleted", premise.IsDeleted);
param.Add("@ReqID", RequestID);
param.Add("@IsPrimary", premise.IsPrimary);
param.Add("@ChangeType", premise.ChangeType);
await SqlMapper.ExecuteAsync(_unitOfWork.Connection,
"UpdateReqPremise",
param,
commandType : CommandType.StoredProcedure,
transaction : _unitOfWork.Transaction);
}
public async Task <IHttpActionResult> Put([FromODataUri] int key, Premise update)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (key != update.Id)
{
return(BadRequest());
}
db.Entry(update).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PremiseExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(update));
}
ResponseModel IPremiseService.AddPremise(PremiseModel model)
{
var hasOrganization = this.dbContext.Organization.WhereActiveOrganization(u => u.OrganizationID == model.OrganizationID).Any();
if (!hasOrganization)
{
return(new ResponseModel {
Status_Code = (int)StatusCode.Error, Message = string.Format("Organization does not exist for id - {0}", model.OrganizationID)
});
}
var userRole = this.dbContext.Role.WhereActiveAccessibleRole().First();
// create premise with role
var premise = new Premise();
premise.PremiseName = model.PremiseName;
premise.PremiseDesc = model.PremiseDesc;
premise.OrganizationID = model.OrganizationID;
premise.Role.Add(userRole);
premise.CreatedBy = this.context.Current.UserId;
premise.CreatedOn = DateTime.UtcNow;
premise.ModifiedBy = this.context.Current.UserId;
premise.ModifiedOn = DateTime.UtcNow;
premise.IsActive = true;
premise.IsDeleted = false;
this.dbContext.Premise.Add(premise);
this.dbContext.SaveChanges();
return(new ResponseModel {
Message = "Premise added successfully", Status_Code = (int)StatusCode.Ok
});
}
public async Task <Certificate> Select(CertificateOptions certificate)
{
var param = new DynamicParameters();
param.Add("@Number", certificate.Number);
param.Add("@Status", certificate.Status);
param.Add("@Scheme", certificate.Number);
param.Add("@SubScheme", certificate.SubScheme);
param.Add("@CustomerID", certificate.CustomerID);
param.Add("@PremiseID", certificate.PremiseID);
var mapper = new CertificateMapper();
return((await SqlMapper.QueryAsync(_unitOfWork.Connection,
"SelectCertificateFull",
new[]
{
typeof(Certificate),
typeof(Premise),
typeof(Customer)
},
obj =>
{
Certificate ce = obj[0] as Certificate;
Premise pr = obj[1] as Premise;
Customer cu = obj[2] as Customer;
return mapper.Map(ce, pr, cu);
},
param,
splitOn: "PremiseID,CustomerID",
commandType: CommandType.StoredProcedure,
transaction: _unitOfWork.Transaction)).FirstOrDefault());
}
public async Task <IActionResult> PutPremise(long id, Premise premise)
{
if (id != premise.Id)
{
return(BadRequest());
}
_context.Entry(premise).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PremiseExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <Premise> > PostPremise(Premise premise)
{
_context.Premises.Add(premise);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetPremise", new { id = premise.Id }, premise));
}
public ActionResult Edit(int premiseID)
{
using (MyDbContext myDbContext = new MyDbContext()) {
Premise premise = myDbContext.Premises.Find(premiseID);
//ViewBag.CountryID = myDbContext.Countries.Where(c => c.CountryID >= premise.CountryID).OrderBy(c => c.CountryID).ToList();
return(View(premise));
}
}
public void Create(Premise obj)
{
if (obj != null)
{
Delete(obj);
Insert(obj);
}
}
public async Task <Premise> Create(Premise premise)
{
return(await _requestProvider.BuildUpon(_url)
.Uri("/api/premise")
.Method(HttpMethod.Post)
.Content(new JsonContent(premise))
.AddInterceptor(new JsonDeserializerInterceptor())
.Execute <Premise>());
}
public void Delete(Premise obj)
{
Delete(obj.CD_DIST, obj.CD_WR, obj.ID_PREMISE, obj.ID_SERVICE);
if (obj.PremiseMore != null)
{
new PremiseMoreBl().Delete(obj.PremiseMore);
}
}
public CertificateBatch Map(CertificateBatch batch,
Certificate certificate = null,
Premise premise = null,
Premise mailingPremise = null,
Comment comment = null,
Menu menu = null)
{
if (!_batchCache.TryGetValue(batch.ID, out CertificateBatch result))
{
_batchCache[batch.ID] = batch;
result = batch;
}
Certificate outCertificate = null;
if ((certificate?.ID ?? 0) > 0 &&
!_certificateCache.TryGetValue(certificate.ID, out outCertificate))
{
outCertificate = certificate;
_certificateCache[certificate.ID] = certificate;
certificate.Premise = premise;
certificate.MailingPremise = mailingPremise;
if (result.Certificates == null)
{
result.Certificates = new List <Certificate>();
}
result.Certificates.Add(certificate);
}
if ((comment?.ID ?? 0) > 0 &&
!_commentCache.ContainsKey(comment.ID))
{
_commentCache[comment.ID] = comment;
if (result.Comments == null)
{
result.Comments = new List <Comment>();
}
result.Comments.Add(comment);
}
if ((menu?.ID ?? 0) > 0 &&
!_menuCache.ContainsKey(menu.ID))
{
_menuCache[menu.ID] = menu;
if (outCertificate.Menus == null)
{
outCertificate.Menus = new List <Menu>();
}
outCertificate.Menus.Add(menu);
}
return(batch);
}
public Model.Request Map(Model.Request request,
RequestLineItem lineItem = null,
Premise premise = null)
{
return(InternalMap(request,
lineItem: lineItem,
premise: premise
));
}
public void Update(Premise obj)
{
UpdateRoot(obj);
if (obj.PremiseMore != null)
{
//Use Create here because of "pivot" table
new PremiseMoreBl().Create(obj.PremiseMore);
}
}
public ActionResult Create()
{
using (MyDbContext myDbContext = new MyDbContext()) {
ViewBag.CountryID = myDbContext.Countries.OrderBy(c => c.CountryID).ToList();
Premise premise = new Premise {
System_Code = "TT0001"
};
return(View(premise));
}
}
public void SavePremise()
{
var premise = new Premise();
premise.Id = PremiseId > 0 ? PremiseId : 0;
premise.Text = PremiseText;
DomainLogic.DataService.SavePremise(premise);
ResetPremise();
}
public async Task <IHttpActionResult> Post(Premise premise)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Premises.Add(premise);
await db.SaveChangesAsync();
return(Created(premise));
}
public void SavePremise(Premise premise)
{
premise.EncodedText = DataUtils.EncodeTextInBytes(premise.Text);
if (premise.Id > 0)
{
_connection.Update(premise);
}
else
{
_connection.Insert(premise);
}
}
public Certificate360 Map(Certificate360 certificate360,
Customer customer,
Code customerCode,
Code customerGroupCode,
Officer cutomerOfficer,
Premise premise)
{
if (!_certificateCache.TryGetValue(certificate360.ID, out Certificate360 result))
{
result = certificate360;
certificate360.Premise = premise;
certificate360.Customer = customer;
if (customer != null &&
(customerCode?.ID ?? 0L) != 0L)
{
if (certificate360.Customer.Code == null)
{
certificate360.Customer.Code = new Code();
}
certificate360.Customer.Code = customerCode;
}
if (customer != null &&
(customerGroupCode?.ID ?? 0L) != 0L)
{
if (certificate360.Customer.GroupCode == null)
{
certificate360.Customer.GroupCode = new Code();
}
certificate360.Customer.GroupCode = customerGroupCode;
}
_certificateCache[certificate360.ID] = certificate360;
if (customer != null &&
(cutomerOfficer?.ID ?? Guid.Empty) != Guid.Empty)
{
if (certificate360.Customer.Officer == null)
{
certificate360.Customer.Officer = new Officer();
}
certificate360.Customer.Officer = cutomerOfficer;
}
_certificateCache[certificate360.ID] = certificate360;
}
return(result);
}
/*distance algo for doing ranging*/
public double distanceAlgo(Property property, Premise premise)
{
double calculation = 0;
int R = 6371;
double latitude1 = Convert.ToDouble(property.Latitude);
double latitude2 = Convert.ToDouble(premise.premises_lat);
double longitude1 = Convert.ToDouble(property.Longitude);
double longitude2 = Convert.ToDouble(premise.premises_long);
calculation = R * Math.Acos(Math.Cos(toRad(latitude1)) * Math.Cos(toRad(latitude2)) * Math.Cos(toRad(longitude2) - toRad(longitude1)) + Math.Sin(toRad(latitude1)) * Math.Sin(toRad(latitude2)));
return(calculation);
}
public Model.Request Map(Model.Request request,
Code customerCode = null,
RequestLineItem lineItem = null,
Premise premise = null,
RFA rfa = null,
Characteristic lineItemChar = null)
{
return(InternalMap(request,
customerCode,
lineItem: lineItem,
premise: premise,
rfa: rfa,
lineItemChar: lineItemChar));
}
List <Premise> ReadPremises(string filename)
{
StreamReader reader = new StreamReader(filename);
List <Premise> premises = new List <Premise>();
while (!reader.EndOfStream)
{
Premise premise = new Premise();
premise.title = reader.ReadLine();
premise.text = reader.ReadLine();
premises.Add(premise);
}
return(premises);
}
public ActionResult Delete(int id)
{
Premise premise = null;
try
{
premise = db.Premises.Where(c => c.Id == id).First();
db.Premises.Remove(premise);
db.SaveChanges();
}
catch { }
JsonResult data = Json(premise);
return(data);
}
// Update is called once per frame
void Update()
{
if (Input.GetKeyUp(KeyCode.A))
{
Premise premise = new Premise();
premise.Text = "Maicăta e așa proastă…";
DomainLogic.DB.SavePremise(premise);
}
if (Input.GetKeyUp(KeyCode.D))
{
DomainLogic.DB.GetPremise();
}
}
public Certificate Map(Certificate certificate,
Premise premise = null,
Premise mailingPremise = null,
Code code = null)
{
if (!_cache.TryGetValue(certificate.ID, out Certificate result))
{
result = certificate;
certificate.Premise = premise;
certificate.MailingPremise = mailingPremise;
certificate.CustomerCode = code;
_cache[certificate.ID] = certificate;
}
return(certificate);
}
public static ProtocolStack WithPremise(Premise premise, string key = "")
{
ProtocolStack constructing = new ProtocolStack();
Premise createPremise, updatePremise, deletePremise;
createPremise = premise.Clone();
updatePremise = premise.Clone();
updatePremise.nullable = true;
deletePremise = new Premise();
constructing.Create = Protocol.WithPremise(createPremise, key);
constructing.Update = Protocol.WithPremise(updatePremise, key);
constructing.Delete = Protocol.WithPremise(deletePremise, key);
return constructing;
}
