private static void UpdatePhones(BranchDTO branchDTO, Branch branch, RampUpProjectEntities dbContext)
{
if (branch.Phones != null)
{
foreach (Phone phone in branch.Phones)
{
if (phone.Phone_Id != 0)
{
dbContext.Entry(phone).State = System.Data.Entity.EntityState.Modified;
}
else
{
dbContext.Entry(phone).State = System.Data.Entity.EntityState.Added;
}
}
List <int> phones = branch.Phones.Select(y => y.Phone_Id).ToList();
List <Phone> toBeDeletedPhones = dbContext.Phones.Where(x => !phones.Contains(x.Phone_Id) && x.Branch_Id == branchDTO.Branch_Id).ToList();
foreach (Phone phone in toBeDeletedPhones)
{
dbContext.Entry(phone).State = System.Data.Entity.EntityState.Deleted;
}
}
}
public IHttpActionResult Post(BranchDTO branch)
{
// Would implement model state validation and return BadRequest if it fails
// Would need to map DTO to valid branch data object before inserting
// Would return the newly created record which would have been mapped back into a DTO and should now include the incremented ID
throw new NotImplementedException();
}
public override Task <BranchDTO> CreateBranch(BranchDTO request, ServerCallContext context)
{
var id = _branchDao.Insert(_mapper.Map <Branch>(request));
var branch = _branchDao.Get(id);
return(Task.FromResult(_mapper.Map <BranchDTO>(branch)));
}
public ActionResult CreateAction([Bind("Id,BankId,BranchName,RoutingNumber")] BranchDTO branch)
{
try
{
Branch newBranch = new Branch();
if (branch != null)
{
newBranch = new Branch
{
BankId = branch.BankId,
BranchName = branch.BranchName,
RoutingNumber = branch.RoutingNumber,
EntityState = EntityState.Added
};
_businessLayer.AddBranch(newBranch);
}
return(Ok(newBranch));
}
catch (Exception ex)
{
//return new JsonResult(new { HttpStatusCode = NotFound(HttpStatusCode.BadRequest), ex.Message });
throw new Exception(ex.Message);
}
}
private static void UpdateFields(BranchDTO branchDTO, Branch branch, RampUpProjectEntities dbContext)
{
if (branch.Fields != null)
{
foreach (Field field in branch.Fields)
{
if (field.Field_Id != 0)
{
dbContext.Entry(field).State = System.Data.Entity.EntityState.Modified;
}
else
{
dbContext.Entry(field).State = System.Data.Entity.EntityState.Added;
}
}
List <int> fields = branch.Fields.Select(y => y.Field_Id).ToList();
List <Field> toBeDeletedFields = dbContext.Fields.Where(x => !fields.Contains(x.Field_Id) && x.Branch_Id == branchDTO.Branch_Id).ToList();
foreach (Field field in toBeDeletedFields)
{
dbContext.Entry(field).State = System.Data.Entity.EntityState.Deleted;
}
}
}
public BranchBM(BranchDTO branchDto, AddressBM addressBm)
{
this.id = branchDto.id;
this.name = branchDto.name;
this.comment = branchDto.comment;
this.address = addressBm;
}
public IHttpActionResult Put(BranchDTO branch)
{
// Would implement model state validation and return BadRequest if it fails
// Would lookup the current record based on the posted ID, if this cannot be found return suitable error message
throw new NotImplementedException();
}
public async Task <ActionResult> pvwAddBranch([FromBody] BranchDTO _sarpara)
{
BranchDTO _Branch = new BranchDTO();
try
{
string baseadress = config.Value.urlbase;
HttpClient _client = new HttpClient();
_client.DefaultRequestHeaders.Add("Authorization", "Bearer " + HttpContext.Session.GetString("token"));
var result = await _client.GetAsync(baseadress + "api/Branch/GetBranchById/" + _sarpara.BranchId);
string valorrespuesta = "";
if (result.IsSuccessStatusCode)
{
valorrespuesta = await(result.Content.ReadAsStringAsync());
_Branch = JsonConvert.DeserializeObject <BranchDTO>(valorrespuesta);
}
if (_Branch == null)
{
_Branch = new BranchDTO();
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
}
return(PartialView(_Branch));
}
public async Task <IActionResult> Update(BranchDTO branchDto, int id)
{
var branch = _mapper.Map <Branch>(branchDto);
await _branchService.Update(branch, id);
return(Ok(branch));
}
public BranchDTO GetBranch(int branchID)
{
bool lockWasTaken = false;
BranchDTO branchDTO = null;
using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) {
try {
Monitor.Enter(dbContext, ref lockWasTaken);
Branch branch = dbContext.Branches.Where(x => x.Branch_Id == branchID).FirstOrDefault();
if (branch != null)
{
branchDTO = ConvertBranchToBranchDTO(branch);
}
if (lockWasTaken)
{
Monitor.Exit(dbContext);
lockWasTaken = false;
}
} catch (Exception) {
if (lockWasTaken)
{
Monitor.Exit(dbContext);
lockWasTaken = false;
}
throw;
}
return(branchDTO);
}
}
public Response <bool> Put(BranchDTO model)
{
model.LastUpdateOperId = CurrentUser.Id;
model.LastUpdateOperName = CurrentUser.Name;
model.LastUpdateTime = DateTime.Now.ToString();
return(_client.UpdateBranch(model).Body);
}
public override Task <BooleanObject> UpdateBranch(BranchDTO request, ServerCallContext context)
{
var success = _branchDao.Update(_mapper.Map <Branch>(request));
return(Task.FromResult(new BooleanObject()
{
Body = success
}));
}
public IHttpActionResult UpdateBranch([FromBody] BranchDTO branchDTO)
{
if (branchDTO == null)
{
return(BadRequest("BranchDTO cannot be null"));
}
branchSvc.UpdateBranch(branchDTO);
return(Ok());
}
private BranchDTO Resolve(List <String> item)
{
BranchDTO result = new BranchDTO();
result.id = int.Parse(item[0]);
result.name = item[1];
result.comment = item[2];
result.addressId = int.Parse(item[3]);
return(result);
}
public IHttpActionResult GetBranch(int?branchID)
{
if (branchID == null || branchID == 0)
{
return(BadRequest("BranchID cannot be null"));
}
BranchDTO branch = branchSvc.GetBranch((int)branchID);
return(Ok(branch));
}
public static Branch ToModel(this BranchDTO ObjectToConvert)
{
return(new Branch()
{
ID = ObjectToConvert.ID,
Name = ObjectToConvert.Name,
Company = ObjectToConvert.Company.ToModel(),
Address = ObjectToConvert.Address.ToModel(),
Users = ObjectToConvert.Users.Select(x => x.ToModel()).ToList()
});
}
public Response <BranchDTO> Post(BranchDTO model)
{
model.CreateOperId = CurrentUser.Id;
model.CreateOperName = CurrentUser.Name;
model.CreateTime = DateTime.Now.ToString();
model.LastUpdateOperId = CurrentUser.Id;
model.LastUpdateOperName = CurrentUser.Name;
model.LastUpdateTime = DateTime.Now.ToString();
return(_client.CreateBranch(model));
}
protected override void Because_of()
{
var branchDto = new BranchDTO {
ID = 51, Name = "B1"
};
var orgDto = new OrganizationDTO {
ID = 5, Name = "O1"
};
orgDto.BranchCollection.Models = new BranchDTO[] { branchDto };
Mapper.Map <Organization>(orgDto);
}
public void Should_report_missing_constructor()
{
var branchDto = new BranchDTO {
ID = 51, Name = "B1"
};
var orgDto = new OrganizationDTO {
ID = 5, Name = "O1"
};
orgDto.BranchCollection.Models = new BranchDTO[] { branchDto };
new Action(() => Mapper.Map <Organization>(orgDto)).ShouldThrow <AutoMapperMappingException>(
ex => ex.InnerException.Message.ShouldStartWith(typeof(CollectionController <Branch, short, EventArgs>) + " needs to have a constructor with 0 args or only optional args"));
}
public ActionResult BranchListProvide()
{
if (!base.HasPermission("branch", PermissionOperate.manager))
{
return(null);
}
BranchDTO branchDTO = new BranchDTO();
UpdateModel <BranchDTO>(branchDTO);
PagedList <Branch> list = _branchService.GetPageList(PageIndex, PageSize, branchDTO);
return(JsonList <Branch>(list, list.TotalItemCount));
}
public void GetById_calls_dataProvider_and_returns_apiresponse()
{
// Arrange
var number = 1;
var data = new BranchDTO();
_dataProvider.GetBranchByNumber(Arg.Any <int>()).Returns(data);
// Act
var result = _controller.Get(1);
// Assert
_dataProvider.Received(1).GetBranchByNumber(Arg.Is(number));
Assert.IsInstanceOf <OkNegotiatedContentResult <ApiResponse <BranchDTO> > >(result);
}
public BranchDTO AddBranch(BranchDTO branchDTO)
{
try {
Branch branch = ConvertBranchDTOToBranch(branchDTO);
using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) {
dbContext.Branches.Add(branch);
dbContext.SaveChanges();
}
return(ConvertBranchToBranchDTO(branch));
} catch (Exception) {
throw;
}
}
public void GetUserBranchesResponseTest()
{
var message = new GetUserBranchesResponse();
Assert.AreEqual(message.Kind, MessageKind.GetUserBranchesResponse);
var branch = new BranchDTO();
branch.Address = "Address";
branch.BranchID = Guid.NewGuid();
branch.LegalName = "LegalName";
branch.Title = "Title";
var item = new UserBranchMapItemDTO();
item.BranchID = branch.BranchID;
item.EventDate = new DateTime(2015, 06, 07);
item.UserBranchMapID = Guid.Empty;
item.UserID = Guid.NewGuid();
message.Branches.Add(branch);
message.UserBranchMapItems.Add(item);
var serializer = new ProtocolSerializer(ProtocolVersion.Version10);
var data = serializer.Serialize(message);
Assert.IsNotNull(data);
var savedMessage = serializer.DeserializeGetUserBranchesResponse(data);
Assert.IsNotNull(savedMessage);
Assert.AreEqual(serializer.GetMessageInfoOrNull(data).Kind, MessageKind.GetUserBranchesResponse);
Assert.AreEqual(savedMessage.Branches.Count, 1);
Assert.AreEqual(savedMessage.UserBranchMapItems.Count, 1);
var savedBranch = savedMessage.Branches[0];
var savedItem = savedMessage.UserBranchMapItems[0];
Assert.AreEqual(savedBranch.Address, savedBranch.Address);
Assert.AreEqual(savedBranch.BranchID, savedBranch.BranchID);
Assert.AreEqual(savedBranch.LegalName, savedBranch.LegalName);
Assert.AreEqual(savedBranch.Title, savedBranch.Title);
Assert.AreEqual(savedItem.BranchID, item.BranchID);
Assert.AreEqual(savedItem.EventDate, item.EventDate);
Assert.AreEqual(savedItem.UserBranchMapID, item.UserBranchMapID);
Assert.AreEqual(savedItem.UserID, item.UserID);
}
/// <summary>
/// Saves a new branch or updates an already existing branch.
/// </summary>
/// <param name="branch">Branch to be saved or updated.</param>
/// <param name="branchId">BranchId of the branch creating or updating</param>
/// <returns>branchId</returns>
public long SaveBranch(BranchDTO branchDTO, string userId)
{
long branchId = 0;
if (branchDTO.BranchId == 0)
{
var branch = new Branch()
{
Name = branchDTO.Name,
PhoneNumber = branchDTO.PhoneNumber,
Location = branchDTO.Location,
CreatedOn = DateTime.Now,
TimeStamp = DateTime.Now,
CreatedBy = userId,
Deleted = false,
MillingChargeRate = branchDTO.MillingChargeRate,
};
this.UnitOfWork.Get <Branch>().AddNew(branch);
this.UnitOfWork.SaveChanges();
branchId = branch.BranchId;
return(branchId);
}
else
{
var result = this.UnitOfWork.Get <Branch>().AsQueryable()
.FirstOrDefault(e => e.BranchId == branchDTO.BranchId);
if (result != null)
{
result.Name = branchDTO.Name;
result.UpdatedBy = userId;
result.PhoneNumber = branchDTO.PhoneNumber;
result.Location = branchDTO.Location;
result.TimeStamp = DateTime.Now;
result.Deleted = branchDTO.Deleted;
result.MillingChargeRate = branchDTO.MillingChargeRate;
result.DeletedBy = branchDTO.DeletedBy;
result.DeletedOn = branchDTO.DeletedOn;
this.UnitOfWork.Get <Branch>().Update(result);
this.UnitOfWork.SaveChanges();
}
return(branchDTO.BranchId);
}
return(branchId);
}
/// <summary>
/// 获取周边网点
/// </summary>
/// <param name="locationx">经度</param>
/// <param name="locationy">纬度</param>
/// <returns></returns>
public IList <BranchDTO> GetBranch(double locationx, double locationy)
{
IList <Branch> listBranch = this.GetALL().Where(b => b.Status == 1).ToList();
//计算距离
IList <BranchDTO> listBranchDTO = new List <BranchDTO>();
foreach (Branch branch in listBranch)
{
BranchDTO dtoBranch = new BranchDTO(branch);
dtoBranch.Distance = DistanceHelper.GetDistance(locationy, locationx, double.Parse(dtoBranch.Latitude ?? "24.737727"), double.Parse(dtoBranch.Longitude ?? "118.656141"));
listBranchDTO.Add(dtoBranch);
}
if (listBranchDTO != null && listBranchDTO.Count > 0)
{
listBranchDTO = listBranchDTO.OrderBy(b => b.Distance).ToList();
}
listBranchDTO = listBranchDTO.Take(8).ToList();
return(listBranchDTO);
}
public IActionResult SaveBranchDetails([FromBody] BranchDTO BranchDTO)
{
bool isSaved = false;
try
{
if (BranchDTO.lstBranchDocStoreDTO.Count > 0)
{
string OldFolder = "Upload";
string NewFolder = "Original";
string webRootPath = _hostingEnvironment.ContentRootPath;
string OldPath = Path.Combine(webRootPath, OldFolder);
string newPath = Path.Combine(webRootPath, NewFolder);
if (!Directory.Exists(newPath))
{
Directory.CreateDirectory(newPath);
}
for (int i = 0; i < BranchDTO.lstBranchDocStoreDTO.Count; i++)
{
if (!string.IsNullOrEmpty(BranchDTO.lstBranchDocStoreDTO[i].pDOCSTOREPATH))
{
string OldFullPath = Path.Combine(OldPath, BranchDTO.lstBranchDocStoreDTO[i].pDOCSTOREPATH);
string NewFullPath = Path.Combine(newPath, BranchDTO.lstBranchDocStoreDTO[i].pDOCSTOREPATH);
BranchDTO.lstBranchDocStoreDTO[i].pDOCSTOREPATH = NewFullPath;
if (System.IO.File.Exists(OldFullPath))
{
System.IO.File.Move(OldFullPath, NewFullPath);
}
}
}
}
isSaved = objBranch.SaveBranchDetails(BranchDTO, Con);
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
return(Ok(isSaved));
}
public IActionResult getBranchDetails()
{
BranchDTOdetails = new BranchDTO();
try
{
BranchDTOdetails = objBranch.getBranchDetails(Con);
if (BranchDTOdetails != null)
{
return(Ok(BranchDTOdetails));
}
else
{
return(StatusCode(StatusCodes.Status204NoContent));
}
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw new FinstaAppException(ex.ToString());
}
}
public ResultBM GetBranch(int branchId)
{
try
{
AddressBLL addressBll = new AddressBLL();
ResultBM addressResult = null;
BranchDAL branchDal = new BranchDAL();
BranchDTO branchDto = branchDal.GetBranch(branchId);
BranchBM branchBm = null;
//Si la sede existe, debería existir la dirección
if (branchDto != null)
{
addressResult = addressBll.GetAddress(branchDto.addressId);
if (addressResult.IsValid())
{
if (addressResult.GetValue() != null)
{
branchBm = new BranchBM(branchDto, addressResult.GetValue <AddressBM>());
}
else
{
return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("RETRIEVING_ERROR")));
}
}
else
{
return(addressResult);
}
}
return(new ResultBM(ResultBM.Type.OK, "Operación exitosa.", branchBm));
}
catch (Exception exception)
{
return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("RETRIEVING_ERROR") + " " + exception.Message, exception));
}
}
public bool SubmitChanges(BranchDTO branchDTO)
{
if (branchDTO != null)
{
if (branchDTO.ID != Guid.Empty)
{
Branch item = new Branch();
item.ID = branchDTO.ID;
item.LocationName = branchDTO.LocationName;
item.Address = branchDTO.Address;
item.PhoneNumber = branchDTO.PhoneNumber;
item.ZipCode = branchDTO.ZipCode;
return(LocationsDataProvider.SubmitChanges(item));
}
else
{
Branch item = new Branch();
item.LocationName = branchDTO.LocationName;
item.Address = branchDTO.Address;
item.PhoneNumber = branchDTO.PhoneNumber;
item.ZipCode = branchDTO.ZipCode;
return(LocationsDataProvider.SubmitChanges(item));
}
}
return(false);
}
public ActionResult BranchListMap()
{
IList <Branch> listBranch = _branchService.GetALL().Where(b => b.Status == 1).ToList();
string point = RQuery["point"];
string _X = "0.00"; //经度
string _Y = "0.00"; //纬度
if (!string.IsNullOrWhiteSpace(point))
{
string[] arrPoint = point.Split(',');
if (arrPoint.Length > 1)
{
_X = arrPoint[0]; //经度
_Y = arrPoint[1]; //纬度
}
}
ViewBag.longitude = _X;
ViewBag.latitude = _Y;
//计算距离
IList <BranchDTO> listBranchDTO = new List <BranchDTO>();
foreach (Branch branch in listBranch)
{
BranchDTO dtoBranch = new BranchDTO(branch);
dtoBranch.Distance = DistanceHelper.GetDistance(double.Parse(_Y), double.Parse(_X), double.Parse(dtoBranch.Latitude ?? "24.737727"), double.Parse(dtoBranch.Longitude ?? "118.656141"));
listBranchDTO.Add(dtoBranch);
}
if (listBranchDTO != null && listBranchDTO.Count > 0)
{
listBranchDTO = listBranchDTO.OrderBy(b => b.Distance).ToList();
}
listBranchDTO = listBranchDTO.Take(10).ToList();
return(View(listBranchDTO));
}
