public ActionResult Index(string name = "", int pageIndex = 1, int pageSize = 10)
{
ViewBag.name = name;
ViewBag.pageIndex = pageIndex;
ConditionExpression ce = null;
QueryCondition qc = new QueryCondition();
if (!string.IsNullOrEmpty(name))
{
ce = new ConditionExpression();
ce.ExpName = "Fullname";
ce.ExpValue = "%" + name + "%";
ce.ExpOperater = eConditionOperator.Like;
ce.ExpLogical = eLogicalOperator.And;
qc.ConditionList.Add(ce);
}
//SortExpression sort = new SortExpression("RegionCode", eSortType.Asc);
//qc.SortList.Add(sort);
qc.PageInfo = GetPageInfo(pageIndex, pageSize);
qc.PageInfo.OrderAndSortList = "RegionCode:ASC";
Result <List <Base_Region> > result = new Result <List <Base_Region> >();
List <RegionView> list = new List <RegionView>();
using (AdminClientProxy proxy = new AdminClientProxy(ProxyEx(Request)))
{
result = proxy.GetRegionList(qc);
if (result.AllRowsCount > 0)
{
var regionAll = proxy.LoadRegionList().Data;
foreach (var item in result.Data)
{
RegionView view = new RegionView();
view.Area = GetProvince(regionAll, item).AreaName;
view.Province = GetProvince(regionAll, item).RegionName;
view.City = GetCity(regionAll, item);
view.Code = item.RegionCode;
view.FullName = item.Fullname;
view.Region = GetRegion(regionAll, item);
list.Add(view);
}
}
ViewBag.Total = result.AllRowsCount;
}
return(View(list));
}
public JsonResult GetTerritoryDataTable(System.Int32 id)
{
DataTableViewModel data;
GetRegionRequest request = new GetRegionRequest();
request.RegionID = id;
RegionView region = _regionService.GetRegion(request).Region;
data = new DataTableViewModel();
data.draw = "1";
data.recordsTotal = region.Territories.ToList().Count.ToString();
data.recordsFiltered = region.Territories.ToList().Count.ToString();
data.data = region.Territories.ConvertToDetailRegionTerritoryDetailViews().ToList <object>();
return(Json(data, JsonRequestBehavior.AllowGet));
}
void SetStar(CaptureView capture, RegionView region)
{
var xSize = region.VisibleWidth;
var ySize = region.VisibleHeight;
var sub = Photometry.GetSubImage(2,
capture.ImageArray,
capture.YSize,
capture.XSize,
region.VisibleY,
region.VisibleX,
region.VisibleY + ySize,
region.VisibleX + xSize);
var unclipped = Photometry.KappaSigmaClip(sub[0], 1.0, 3);
var signal = new ushort[sub[0].Length - unclipped.Count];
var signals = 0;
var background = new ushort[unclipped.Count];
var backgrounds = 0;
for (var i = 0; i < sub[0].Length; i++)
{
if (unclipped.Contains(i))
{
background[backgrounds++] = sub[0][i];
}
else
{
signal[signals++] = sub[0][i];
}
}
var regionMean = Photometry.FindMean(sub[0]);
var backgroundSigma = Photometry.FindStandardDeviation(background);
var backgroundMean = Photometry.FindMean(background);
Focus.Star.SetStats(signals, backgrounds, regionMean, backgroundSigma, backgroundMean);
var snr = regionMean / backgroundSigma;
var bg = Focus.UsePhdBackgroundFormula ? regionMean + backgroundSigma * 2.0 : regionMean;
Photometry.Subtract(sub[0], (ushort)bg);
if (Focus.UseMedianFilter)
{
sub[0] = Photometry.MedianBoxFilter(sub[0], xSize, ySize);
}
Focus.Region.Capture = new CaptureView
{
XSize = xSize,
YSize = ySize,
ImageArray = sub[0],
Image = new Mat(ySize, xSize, MatType.CV_16UC1, sub[0])
};
Focus.RegionChanged();
if (signals < 5)
{
Focus.Star.SetStarNotFound();
}
else
{
var brightestX = 0;
var brightestY = 0;
var br = 0;
for (var y = 0; y < ySize; y++)
{
for (var x = 0; x < xSize; x++)
{
var brightest = brightestY * xSize + brightestX;
if (sub[0][brightest] < sub[0][y * xSize + x])
{
brightestX = x;
brightestY = y;
br = sub[0][brightest];
}
}
}
var center = Photometry.FindCenterOfMass(sub[0], xSize, ySize);
ushort peak = 0;
for (var i = 0; i < sub[0].Length; i++)
{
if (sub[0][i] > peak)
{
peak = sub[0][i];
}
}
var weightedCenterX = (center.X / (double)xSize) * 100.0;
var weightedCenterY = (center.Y / (double)ySize) * 100.0;
var brightestPixelX = (brightestX / (double)xSize) * 100.0;
var brightestPixelY = (brightestY / (double)ySize) * 100.0;
Focus.Star.SetMeasurements(
snr,
peak,
weightedCenterX,
weightedCenterY,
brightestPixelX,
brightestPixelY);
var samples = new ushort[40];
var max = 0.0;
for (var x = 0; x < 40; x++)
{
samples[x] = sub[0][(int)center.Y * 40 + x];
max = samples[x] > max ? samples[x] : max;
}
Focus.SetProfileSamples(samples);
}
}
private RegionUnhandledUserRequestHandler(RegionView _) : base("")
{
}
public static UserRequestHandler RegionUnhandledUserRequestHandlerFactory(RegionView region)
{
return(new RegionUnhandledUserRequestHandler(region));
}
public static void SaveRegion(RegionView region)
{
db.Regions.Add(region);
db.SaveChanges();
}
public static Region ConvertToRegion(
this RegionView regionView)
{
return(Mapper.Map <RegionView,
Region>(regionView));
}
public static UserRequestHandler RegionHelpUserRequestHandlerFactory(RegionView regionView)
{
return(new RegionHelpUserRequestHandler(regionView));
}
private RegionHelpUserRequestHandler(RegionView regionView) : base("help")
{
_regionView = regionView;
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ISeedData seedData)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseSignalR((cfg) => {
cfg.MapHub <NotificationHub>("/notifications");
});
app.UseMvc(routes =>
routes.MapRoute(
name: "WebAPI",
template: "api/{controller}/{action}/{id?}"
)
//.MapRoute(
// name: "WebAPIForYear",
// template: "api/foryear/{year:int}/{controller}/{action}/{id?}"
//)
);
seedData.SeedCompanyData();
seedData.SeedUserData();
//var tmp1 = UnitOfWork.ContoShemeOptions;
//seedData.PopulateData();
// Create views
BankView.CreateView();
BusinessPartnerBankView.CreateView();
BusinessPartnerByConstructionSiteView.CreateView();
BusinessPartnerInstitutionView.CreateView();
BusinessPartnerLocationView.CreateView();
BusinessPartnerDocumentView.CreateView();
BusinessPartnerNoteView.CreateView();
BusinessPartnerOrganizationUnitView.CreateView();
BusinessPartnerPhoneView.CreateView();
BusinessPartnerView.CreateView();
BusinessPartnerTypeView.CreateView();
//CompanyView.CreateView(); //???
//UserView.CreateView();
InputInvoiceView.CreateView();
InputInvoiceNoteView.CreateView();
InputInvoiceDocumentView.CreateView();
OutputInvoiceDocumentView.CreateView();
OutputInvoiceView.CreateView();
OutputInvoiceNoteView.CreateView();
CountryView.CreateView();
RegionView.CreateView();
MunicipalityView.CreateView();
CityView.CreateView();
ProfessionView.CreateView();
SectorView.CreateView();
AgencyView.CreateView();
TaxAdministrationView.CreateView();
ToDoView.CreateView();
EmployeeByBusinessPartnerView.CreateView();
EmployeeByConstructionSiteView.CreateView();
EmployeeCardView.CreateView();
EmployeeView.CreateView();
EmployeeDocumentView.CreateView();
EmployeeItemView.CreateView();
EmployeeLicenceView.CreateView();
EmployeeNoteView.CreateView();
EmployeeProfessionView.CreateView();
FamilyMemberView.CreateView();
LicenceTypeView.CreateView();
PhysicalPersonView.CreateView();
PhysicalPersonItemView.CreateView();
PhysicalPersonNoteView.CreateView();
PhysicalPersonLicenceView.CreateView();
PhysicalPersonDocumentView.CreateView();
PhysicalPersonCardView.CreateView();
PhysicalPersonProfessionView.CreateView();
ConstructionSiteCalculationView.CreateView();
ConstructionSiteDocumentView.CreateView();
ConstructionSiteNoteView.CreateView();
ConstructionSiteView.CreateView();
VatView.CreateView();
ServiceDeliveryView.CreateView();
DiscountView.CreateView();
StatusView.CreateView();
ShipmentView.CreateView();
ShipmentDocumentView.CreateView();
PhonebookView.CreateView();
PhonebookDocumentView.CreateView();
PhonebookNoteView.CreateView();
PhonebookPhoneView.CreateView();
InvoiceView.CreateView();
InvoiceItemView.CreateView();
CallCentarView.CreateView();
CalendarAssignmentView.CreateView();
EmployeeAttachmentView.CreateView();
PhysicalPersonAttachmentView.CreateView();
ToDoStatusView.CreateView();
var mailingTime = new Config().GetConfiguration()["MailTime"];
Console.WriteLine("Sending mails scheduled at: {0}\nCurrent time: {1}", mailingTime, DateTime.Now.ToString("HH:mm:ss"));
Thread mailThread = new Thread(() => MailTask.SendMailTime(mailingTime));
mailThread.IsBackground = true;
mailThread.Start();
}
private void SaveToDb(dynamic country)
{
InfoTxblc.Text = "Сохраняем данные...";
CityView capital = null;
RegionView region = null;
//Проверка наличия столицы в таблице Города
if (Querries.FindCities(country.Capital).Count == 0)
{
capital = new CityView()
{
Name = country.Capital
};
Querries.SaveCity(capital);
}
//Если запись есть - ищем ее
else
{
capital = Querries.FindCity(country.Capital);
}
//Проверка наличия региона в таблице Регионов
if (Querries.FindRegions(country.Region).Count == 0)
{
region = new RegionView()
{
Name = country.Region
};
Querries.SaveRegion(region);
}
//Если запись есть - ищем ее
else
{
region = Querries.FindRegion(country.Region);
}
//Проверка наличия страны в таблице Стран
if (Querries.FindCountries(country.CountryName).Count == 0)
{
//Capital_Id нужен по ТЗ. В ином случае, не стал бы добавлять это поле
Querries.SaveCountry(new CountryView()
{
Name = country.CountryName, Capital = capital, Capital_Id = capital.Id, Code = country.Code,
PeopleAmount = country.People, Region = region, Square = country.Square
}
);
}
//Если запись есть - обновляем ее
else
{
CountryView selectedCountry = Querries.FindCountries(country.CountryName as string).First();
selectedCountry.Name = country.CountryName;
selectedCountry.Capital = capital;
selectedCountry.Capital_Id = capital.Id;
selectedCountry.Code = country.Code;
selectedCountry.PeopleAmount = country.People;
selectedCountry.Region = region;
selectedCountry.Square = country.Square;
Querries.db.SaveChanges();
}
InfoTxblc.Text = "Сохранение прошло успешно!";
}
public static DetailRegion_RegionDetailView ConvertToDetailRegion_RegionDetailView(
this RegionView regions)
{
return(Mapper.Map <RegionView,
DetailRegion_RegionDetailView>(regions));
}
public static ModifyRegionRequest ConvertToModifyRegionRequest(
this RegionView regions)
{
return(Mapper.Map <RegionView,
ModifyRegionRequest>(regions));
}
public static RegionDetailView ConvertToRegionDetailView(
this RegionView region)
{
return(Mapper.Map <RegionView,
RegionDetailView>(region));
}
public static RegionFlatViewModel ConvertToRegionFlatViewModel(
this RegionView region)
{
return(Mapper.Map <RegionView,
RegionFlatViewModel>(region));
}
