void AddExecute(object param)
{
ClientLocation clientLocation;
if (currentClientDef != null)
{
clientLocation = currentClientDef.Clone();
}
else
{
clientLocation = new ClientLocation();
clientLocation.ExtSys = ExtSyss[0].EXT_SYS;
clientLocation.OverrideKeySource = OverRideKeySources[0].OVERRIDE_KEY_SOURCE;
clientLocation.ExtWorkTypeSourceDescr = ExtWorkTypeSources[0].DESCR;
}
clientLocation.ExtClientKey = null;// Force them to type in a new one
clientLocation.IsAdding = true;
this.ClientDefListViewModel.ClientLocations.Add(clientLocation);
ClientDefListViewModel.CurrentClientLocation = clientLocation;
//this.ClientDefListViewModel.clientLocations.Add(clientLocation);
//ClientDefListViewModel.currentClientLocation = clientLocation;
ClientDefListViewModel.EnablePicker = false;
CurrentClientDef = clientLocation;
CurrentClientDef.Modified = true;
}
public override ClientLocation RowConverter(IDataRecord row)
{
ClientLocation ec = new ClientLocation();
rowcount++;
int lastgood = 0;
try
{
ec.ExtSys = row["ext_sys"].ToString();
lastgood++;
ec.ExtClientKey = row["ext_client_key"].ToString();
lastgood++;
ec.DefaultInvoiceGrpID = CastDbValue(row, "default_invoice_grp_id");
lastgood++;
ec.Description = CastDbValue(row, "descr");
lastgood++;
ec.CostCode = CastDbValue(row, "cost_code");
lastgood++;
ec.ExtWorkTypeSourceDescr = CastDbValue(row, "ext_work_type_source_descr");
lastgood++;
ec.OverrideKeySource = CastDbValue(row, "override_key_source");
lastgood++;
ec.DefaultTatThreshold = CastDbValue(row, "default_tat_threshold");
lastgood++;
ec.Modified = false;
}
catch (Exception ex)
{
throw ex;
}
return(ec);
}
public async Task <IActionResult> Post([FromBody] ClientLocation client)
{
if (ModelState.IsValid)
{
var location = new Location
{
Address = client.Address,
City = client.City
};
var newClient = new Client {
ClientName = client.ClientName
};
try
{
var locationAdded = await _repoLoc.Create(location);
newClient.LocationId = locationAdded.LocationId;
var addedClient = await _repo.Create(newClient);
return(Ok(addedClient));
}
catch (Exception ex)
{
_logger.LogError($"Exception thrown while getting client: {ex}");
}
}
return(BadRequest($"Error ocurred"));
}
public ActionResult Create(ClientLocation model)
{
SetSessionVariables();
if (model != null)
{
model.CreatedBy = GetSessionObject().UserID;
model.CreatedDateTime = DateTime.Now;
model.ClientID = GetSessionObject().ClientID.Value;
model.ClientLocationStatus = true;
}
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Common.Instance.ApiClientControllerName);
//HTTP POST
var postTask = client.PostAsJsonAsync <ClientLocation>(Common.Instance.ApiClientAddClientLocation, model);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
}
ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator.");
return(RedirectToAction("Index"));
}
public SpaceDetailsListSearchResponse()
{
space = new ClientWorkSpaceFloorPlan();
client = new ClientMaster();
location = new ClientLocation();
//facilities = new List<FacilityMaster>();
}
//private int lastEntry = 0;
//static private int debugENTRIES = 0;
protected override void RowConverter(ClientLocation item, DataRow row)
{
rowcount++;
int lastEntry = 0;
try
{
//if (lastEntry > 2636)
// debugENTRIES = 331;//break;
item.ExtSys = row["ext_sys"].ToString();
lastEntry++;
item.ExtClientKey = row["ext_client_key"].ToString();
lastEntry++;
item.DefaultInvoiceGrpID = CastDbValueRow(row, "default_invoice_grp_id", true, "decimal");
lastEntry++;
item.Description = CastDbValueRow(row, "descr");
lastEntry++;
item.CostCode = CastDbValueRow(row, "cost_code");
lastEntry++;
item.ExtWorkTypeSourceDescr = CastDbValueRow(row, "ext_work_type_source_descr");
lastEntry++;
item.OverrideKeySource = CastDbValueRow(row, "override_key_source");
lastEntry++;
item.DefaultTatThreshold = CastDbValueRow(row, "default_tat_threshold", true, "decimal");
lastEntry++;
item.Modified = false;
}
catch (Exception sysEx)
{
throw sysEx;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
ClientSetting setting = new ClientSetting();
setting.HomeUrl = this.tbHomeUrl.Text;
ClientLocation location = new ClientLocation();
double posX = 0;
double.TryParse(this.tbPositionX.Text, out posX);
location.X = posX;
double posY = 0;
double.TryParse(this.tbPositionY.Text, out posY);
location.Y = posY;
double width = 0;
double.TryParse(this.tbWidth.Text, out width);
location.Width = width;
double height = 0;
double.TryParse(this.tbHeight.Text, out height);
location.Height = height;
setting.Location = location;
if (SettingChanged != null)
{
SettingChanged(setting);
}
this.Close();
}
public WorkSpaceDetailsResponse()
{
selectedSpace = new ClientWorkSpaceFloorPlan();
client = new ClientMaster();
location = new ClientLocation();
clientFloors = new List <ClientFloorDetails>();
}
void LocationManager_LocationsUpdated(object sender, CLLocationsUpdatedEventArgs e)
{
var currentLocation = e.Locations[0];
this.lastLocation = new ClientLocation {
Latitude = currentLocation.Coordinate.Latitude, Longitude = currentLocation.Coordinate.Longitude, Altitude = currentLocation.Altitude
};
}
public override void Remove(ClientLocation client)
{
string sql = String.Format("DELETE FROM {0}.EXT_CLIENT WHERE EXT_SYS = :EXT_SYS and EXT_CLIENT_KEY = :EXT_CLIENT_KEY", SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":EXT_SYS", client.ExtSys, OracleType.VarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":EXT_CLIENT_KEY", client.ExtClientKey, OracleType.VarChar, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
}
public ClientLocation Post([FromBody] ClientLocation clientLocation)
{
db.ClientLocations.Add(clientLocation);
db.SaveChanges();
ClientLocation existingClientLocation = db.ClientLocations.Where(temp => temp.ClientLocationID == clientLocation.ClientLocationID).FirstOrDefault();
return(clientLocation);
}
/// <summary>
/// 判断一个 ConnectionListItem 是否等价于另一个 ConnectionListItem。
/// </summary>
/// <param name="other">要与之比较的 ConnectionListItem。</param>
/// <returns>一个 <see cref="System.Boolean"/>，指示二者是否等价。</returns>
public bool Equals(ConnectionListItem other)
{
if (other == null)
{
return(this == null);
}
else
{
return(ClientLocation.Equals(other.ClientLocation));
}
}
public async Task <IActionResult> GetAsync([FromQuery] ClientLocation clientLocation)
{
var service = serviceFunc();
const double lat = -34.809964, longi = 138.680274;
var data = await service.GetLocationsAsync(clientLocation.Latitude,
clientLocation.Longitude, distance : 1);
return(EitherResponse(data));
}
public override int GetHashCode()
{
unchecked
{
var hashCode = (_telephones != null ? _telephones.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (_comments != null ? _comments.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (ClientLocation != null ? ClientLocation.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Person != null ? Person.GetHashCode() : 0);
return(hashCode);
}
}
public IActionResult GetByClientLocationID(int ClientLocationID)
{
ClientLocation clientLocation = db.ClientLocations.Where(temp => temp.ClientLocationID == ClientLocationID).FirstOrDefault();
if (clientLocation != null)
{
return(Ok(clientLocation));
}
else
{
return(NoContent());
}
}
private void ClientLocListener(object sender, PropertyChangedEventArgs e)
{
ClientLocation c = sender as ClientLocation;
if (c.Modified)
{
EnablePicker = false;
}
else
{
EnablePicker = true;
}
}
public ClientMarker(ClientLocation clientLocation, ClientViewModel client)
{
Client = client;
Country = clientLocation.Country;
CountryName = clientLocation.CountryName;
Region = clientLocation.Region;
City = clientLocation.City;
Latitude = clientLocation.Latitude;
Longitude = clientLocation.Longitude;
ZipCode = clientLocation.ZipCode;
Timezone = clientLocation.Timezone;
IpAddress = clientLocation.IpAddress;
}
public void SwapClientDefItem(ClientLocation item)
{
if (CurrentClientLocation != null)
{
RemoveWeakEventListener(CurrentClientLocation, ClientLocListener);
}
CurrentClientLocation = item;
CurrentClientLocation.Modified = false;
ClearOutPendingAdds();
if (CurrentClientLocation != null)
{
AddWeakEventListener(CurrentClientLocation, ClientLocListener);
}
}
public int Delete(int ClientLocationID)
{
ClientLocation existingClientLocation = db.ClientLocations.Where(temp => temp.ClientLocationID == ClientLocationID).FirstOrDefault();
if (existingClientLocation != null)
{
db.ClientLocations.Remove(existingClientLocation);
db.SaveChanges();
return(ClientLocationID);
}
else
{
return(-1);
}
}
public ClientLocation Put([FromBody] ClientLocation project)
{
ClientLocation existingClientLocation = db.ClientLocations.Where(temp => temp.ClientLocationID == project.ClientLocationID).FirstOrDefault();
if (existingClientLocation != null)
{
existingClientLocation.ClientLocationName = project.ClientLocationName;
db.SaveChanges();
return(existingClientLocation);
}
else
{
return(null);
}
}
/// <summary>
/// COST_CODE VARCHAR
/// DEFAULT_INVOICE_GRP_ID NUMBER
/// DEFAULT_TAT_THRESHOLD NUMBER
/// DESCR VARCHAR
/// EXT_WORK_TYPE_SOURCE_DESCR VARCHAR
/// OVERRIDE_KEY_SOURCE VARCHAR
/// </summary>
/// <param name="loc"></param>
/// <returns></returns>
public override ClientLocation Update(ClientLocation loc)
{
try
{
string sql = String.Format("update {0}.EXT_CLIENT set "
+ " DEFAULT_INVOICE_GRP_ID = :id "
+ " ,DEFAULT_TAT_THRESHOLD = :default_tat_threshold "
+ " ,COST_CODE = :cost_code "
+ " ,DESCR = :descr "
+ " ,EXT_WORK_TYPE_SOURCE_DESCR = :ext_work_type_source_descr "
+ " ,OVERRIDE_KEY_SOURCE = :override_key_source "
+ " where ext_sys = :ext_sys and ext_client_key = :extclientkey"
, SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":id", loc.DefaultInvoiceGrpID, OracleType.Number, ParameterDirection.Input));
object v;
if (loc.DefaultTatThreshold == null)
{
v = DBNull.Value;
}
else
{
v = loc.DefaultTatThreshold;
}
parameters.Add(OracleHelper.CreateParameter(":default_tat_threshold", NullableInput(loc.DefaultTatThreshold), OracleType.Number, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":cost_code", NullableInput(loc.CostCode), OracleType.VarChar, 10, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":descr", NullableInput(loc.Description), OracleType.VarChar, 100, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":ext_work_type_source_descr", NullableInput(loc.ExtWorkTypeSourceDescr), OracleType.VarChar, 100, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":override_key_source", NullableInput(loc.OverrideKeySource), OracleType.VarChar, 30, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":ext_sys", loc.ExtSys, OracleType.VarChar, 20, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":extclientkey", loc.ExtClientKey, OracleType.VarChar, 20, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
return(loc);
}
catch (OracleException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
void GongSolutions.Wpf.DragDrop.IDropTarget.Drop(GongSolutions.Wpf.DragDrop.DropInfo dropInfo)
{
if (dropInfo.Data is List <ClientLocation> )
{
foreach (ClientLocation loc in dropInfo.Data as List <ClientLocation> )
{
loc.DefaultInvoiceGrpID = (dropInfo.TargetItem as InvoiceGroup).InvoiceGrpId;
ExtClientTarget.Update(loc);
}
}
else if (dropInfo.Data is ClientLocation)
{
ClientLocation loc = dropInfo.Data as ClientLocation;
loc.DefaultInvoiceGrpID = (dropInfo.TargetItem as InvoiceGroup).InvoiceGrpId;
ExtClientTarget.Update(loc);
}
DetailVM.SetItemDetails();
}
private static void onJoinEvent(object sender, PlayerJoinEventArgs e)
{
currentMapID = e.mapID;
ClientLocation c = new ClientLocation();
c.clientID = Settings.clientID;
c.location = currentMapID;
string url = Settings.ROA_MAPPER_API + "client/location";
var client = new WebClient();
client.Headers[HttpRequestHeader.ContentType] = "application/json";
Uri uri = new Uri(url);
var servicePoint = ServicePointManager.FindServicePoint(uri);
servicePoint.Expect100Continue = false;
client.UploadStringAsync(uri, Newtonsoft.Json.JsonConvert.SerializeObject(c));
}
private void WorldMap_MouseMove(object sender, MouseEventArgs e)
{
var imageControl = (Image) sender;
var position = e.GetPosition(imageControl);
var lon = position.X/imageControl.ActualWidth*360 - 180;
var lat = (position.Y/imageControl.ActualHeight - 1)*-1*180 - 90;
foreach (var marker in Markers)
{
if (marker.Longitude > lon - 1 && marker.Longitude < lon + 1)
{
if (marker.Latitude > lat - 1 && marker.Latitude < lat + 1)
{
if (marker != _currentMarker)
{
_currentMarker = marker;
_markerToolTip.Placement = PlacementMode.Relative;
_markerToolTip.PlacementTarget = imageControl;
_markerToolTip.DataContext = marker;
_markerToolTip.IsOpen = true;
}
if (_currentMarker != null)
{
_markerToolTip.HorizontalOffset = position.X + 5;
_markerToolTip.VerticalOffset = position.Y + 5;
}
//ZoomViewer.Cursor = Cursors.Hand;
return;
}
}
}
//ZoomViewer.Cursor = Cursors.Arrow;
_markerToolTip.IsOpen = false;
_currentMarker = null;
}
public ActionResult Edit(ClientLocation model)
{
SetSessionVariables();
ClientLocation clientLocation = null;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Common.Instance.ApiClientControllerName);
//HTTP GET
var responseTask = client.PutAsJsonAsync(Common.Instance.ApiClientUpdateClientLocation + model.ClientLocationID, model);
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <ClientLocation>();
readTask.Wait();
clientLocation = readTask.Result;
}
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(int ClientLocationID)
{
SetSessionVariables();
ClientLocation clientLocation = null;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Common.Instance.ApiClientControllerName);
//HTTP GET
var responseTask = client.GetAsync(Common.Instance.ApiClientGetClientLocation + ClientLocationID.ToString());
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <ClientLocation>();
readTask.Wait();
clientLocation = readTask.Result;
}
}
return(View(clientLocation));
}
public override ClientLocation UnassignLocation(ClientLocation loc)
{
try
{
string sql = String.Format("update {0}.EXT_CLIENT set "
+ " DEFAULT_INVOICE_GRP_ID = :id "
+ " where ext_sys = :ext_sys and ext_client_key = :extclientkey"
, SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":id", DBNull.Value, OracleType.Number, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":ext_sys", loc.ExtSys, OracleType.VarChar, 20, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":extclientkey", loc.ExtClientKey, OracleType.VarChar, 20, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
return(loc);
}
catch (OracleException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
protected List <ClientLocation> ConvertToList(IDataReader dr)
{
List <ClientLocation> items = new List <ClientLocation>();
string val;
while (dr.Read())
{
ClientLocation ec = new ClientLocation();
ec.ExtSys = dr["ext_sys"].ToString();
ec.ExtClientKey = dr["ext_client_key"].ToString();
val = dr["default_invoice_grp_id"].ToString();
if (String.IsNullOrEmpty(val))
{
ec.DefaultInvoiceGrpID = null;
}
else
{
ec.DefaultInvoiceGrpID = long.Parse(val);
}
ec.Description = dr["descr"].ToString();
ec.CostCode = dr["cost_code"].ToString();
ec.ExtWorkTypeSourceDescr = dr["ext_work_type_source_descr"].ToString();
ec.OverrideKeySource = dr["override_key_source"].ToString();
val = dr["default_tat_threshold"].ToString();
if (String.IsNullOrEmpty(val))
{
ec.DefaultTatThreshold = 12;
}
else
{
ec.DefaultTatThreshold = int.Parse(val);
}
items.Add(ec);
}
return(items);
}
public override bool Add(ClientLocation client)
{
string sql = String.Format("INSERT INTO {0}.EXT_CLIENT \r\n"
+ " (EXT_SYS ,EXT_CLIENT_KEY ,DEFAULT_INVOICE_GRP_ID \r\n"
+ " ,DESCR ,COST_CODE ,EXT_WORK_TYPE_SOURCE_DESCR \r\n"
+ " ,OVERRIDE_KEY_SOURCE ,DEFAULT_TAT_THRESHOLD) \r\n"
+ "VALUES \r\n"
+ "( :EXT_SYS ,:EXT_CLIENT_KEY ,:DEFAULT_INVOICE_GRP_ID \r\n"
+ " ,:DESCR ,:COST_CODE ,:EXT_WORK_TYPE_SOURCE_DESCR \r\n"
+ " ,:OVERRIDE_KEY_SOURCE ,:DEFAULT_TAT_THRESHOLD)"
, base.SchemaName);
using (IDbConnection cnn = new OracleConnection(ConnectionString.Value))
using (IDbCommand cmd = new OracleCommand(sql, (OracleConnection)cnn))
{
cmd.CommandType = CommandType.Text;
OracleHelper.AddCommandParameter(cmd, ":EXT_SYS", CheckNull(client.ExtSys), OracleType.Char, 20, ParameterDirection.Input);
OracleHelper.AddCommandParameter(cmd, ":EXT_CLIENT_KEY", CheckNull(client.ExtClientKey), OracleType.VarChar, 20, ParameterDirection.Input);
OracleHelper.AddCommandParameter(cmd, ":DEFAULT_INVOICE_GRP_ID", CheckNull(client.DefaultInvoiceGrpID), OracleType.Number, ParameterDirection.Input);
OracleHelper.AddCommandParameter(cmd, ":DESCR", CheckNull(client.Description), OracleType.VarChar, 100, ParameterDirection.Input);
OracleHelper.AddCommandParameter(cmd, ":COST_CODE", CheckNull(client.CostCode), OracleType.VarChar, 10, ParameterDirection.Input);
if (String.IsNullOrEmpty(client.ExtWorkTypeSourceDescr))
{
client.ExtWorkTypeSourceDescr = "<DEFAULT>";
}
OracleHelper.AddCommandParameter(cmd, ":EXT_WORK_TYPE_SOURCE_DESCR", client.ExtWorkTypeSourceDescr, OracleType.VarChar, 30, ParameterDirection.Input);
if (String.IsNullOrEmpty(client.OverrideKeySource))
{
client.OverrideKeySource = "<DEFAULT>";
}
OracleHelper.AddCommandParameter(cmd, ":OVERRIDE_KEY_SOURCE", client.OverrideKeySource, OracleType.VarChar, 30, ParameterDirection.Input);
OracleHelper.AddCommandParameter(cmd, ":DEFAULT_TAT_THRESHOLD", CheckNull(client.DefaultTatThreshold), OracleType.Number, ParameterDirection.Input);
cnn.Open();
return(cmd.ExecuteNonQuery() > 0);
}
}
protected bool Equals(Client other)
{
return(_telephones.SequenceEqual(other._telephones) && _comments.SequenceEqual(other._comments) && ClientLocation.Equals(other.ClientLocation) && Person.Equals(other.Person));
}
