public static bool checkForExists(DapperService db, int id)
{
RegionsModel ret = null;
ret = db.QueryFirst(ret, "SELECT * FROM Regions where Id=@Id", new { Id = id });
return(ret != null);
}
public bool Update(RegionsModel model, int Id)
{
string query = "UPDATE Regions SET Name=@Name,ParentId=@ParentId,Status=@Status WHERE Id=@Id";
int affectedRows = db.Execute(query, model);
return(affectedRows > 0);
}
public static string GetRegionFullAreaName(DapperService db, int id)
{
RegionsModel ret2 = null;
string ret = db.QueryFirst(ret2, "GetRegionFullAreaName", new { Id = id }, commandType: CommandType.StoredProcedure)?.Name.Trim();
return(ret);
}
public RegionsModel GetProcedure(int id)
{
RegionsModel ret2 = null;
RegionsModel ret = db.QueryFirst(ret2, "GetRegionFullArea", new { Id = id }, commandType: CommandType.StoredProcedure);
return(ret);
}
public bool Save(RegionsModel model)
{
string query = "INSERT INTO Regions(Name,ParentId) VALUES(@Name,@ParentId)";
int affectedRows = db.Execute(query, model);
return(affectedRows > 0);
}
public void CompactStackingRegionsReturnsCorrectStack()
{
var actual = new RegionsModel(GetCompactTestRegions(), StackingMethod.CompactStacking).Rows;
var expected = GetCompactStackingRegionsResult();
actual.Should().BeEquivalentTo(expected);
}
private void AddRegion(DistributionRegionViewModel parent)
{
if (parent != null)
{
if (!parent.IsExpanded)
{
parent.IsExpanded = true;
}
var newRegion = new DistributionRegion {
DistRegionName = "<New Distribution Region>", DistRegionParentID = parent.DistRegionID, DistRegionID = -1
};
var newVm = new DistributionRegionViewModel(newRegion);
newVm.Parent = parent;
parent.Children.Add(newVm);
newVm.IsSelected = true;
newVm.IsRenaming = true;
RegisterPendingChange(new InsertDistributionRegionCommand(newRegion, parent.Model));
}
else
{
var newRegion = new DistributionRegion {
DistRegionName = "<New Distribution Region>", DistRegionParentID = 0, DistRegionID = -1
};
var newVm = new DistributionRegionViewModel(newRegion);
RegionsModel.Add(newVm);
newVm.IsSelected = true;
newVm.IsRenaming = true;
RegisterPendingChange(new InsertDistributionRegionCommand(newRegion, null));
}
}
public async Task <int> SaveNewRegion(RegionsModel model)
{
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { model.Region, model.IsActive };
return(await _dbContext.ExecuteNonQueryAsync("sp_SaveNewRegion", parameters));
}
}
private void button1_Click(object sender, EventArgs e)
{
RegionsModel region = (RegionsModel)cboRegions.SelectedItem;
currentRegion = region.ToString();
currentFEs = GlobalConfig.Connection.GetItemByColumn <FE_Model>("tblFE", "Region",
currentRegion);
List <AssignmentTableModel> assignments = getAssignments(cboMonth.SelectedItem.ToString(),
cboYear.SelectedItem.ToString());
}
public JsonResult Post([FromBody] RegionsViewModel model)
{
if (!ModelState.IsValid)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json(new { message = Validation.getValidationErrors(model) }));
}
RegionsModel items = new RegionsModel(model);
bool isSaved = regionsService.Save(items);
return(Json(new { message = isSaved ? "Сохранено" : "Не cохранено" }));
}
public JsonResult Put(int id, [FromBody] RegionsViewModel model)
{
if (id < 1 || model == null)
{
return(Json(new { message = "Не cохранено" }));
}
if (!ModelState.IsValid)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json(new { message = Validation.getValidationErrors(model) }));
}
RegionsModel item = new RegionsModel(model)
{
Id = id
};
bool isSaved = regionsService.Update(item, id);
return(Json(new { message = isSaved ? "Сохранено" : "Не cохранено" }));
}
private void ExpandAll(DistributionRegionViewModel selected)
{
using (new OverrideCursor(Cursors.Wait)) {
if (selected != null)
{
selected.Traverse((child) => {
child.IsExpanded = true;
});
}
else
{
RegionsModel.ForEach((vm) => {
vm.Traverse((child) => {
child.IsExpanded = true;
});
});
}
}
}
private void ShowContextMenu(TreeView tvw)
{
var selected = tvw.SelectedItem as SiteExplorerNodeViewModel;
var builder = new ContextMenuBuilder(null);
if (selected != null)
{
tvw.ContextMenu = SiteExplorerMenuBuilder.Build(selected, this);
}
else if (tvw.SelectedItem == this.regionsNode)
{
builder.New("Add _Region").Handler(() => {
var newNode = AddRegion(null);
RegionsModel.Insert(0, newNode);
}).End();
builder.Separator();
builder.AddMenuItem(SiteExplorerMenuBuilder.CreateTemplateItems(this));
builder.Separator();
builder.New("Refresh").Handler(() => { Refresh(); }).End();
tvw.ContextMenu = builder.ContextMenu;
}
else if (tvw.SelectedItem == unplacedNode)
{
builder.New("Add Site _Group").Handler(() => {
var newNode = AddSiteGroup(null);
UnplacedModel.Insert(0, newNode);
}).End();
MenuItemBuilder b = new MenuItemBuilder();
MenuItem addSite = b.New("Add Site").MenuItem;
addSite.Items.Add(b.New("Blank").Handler(() => {
var newNode = AddSite(null);
UnplacedModel.Insert(0, newNode);
}).MenuItem);
addSite.Items.Add(b.New("From _Template").Handler(() => {
int?templateId = ChooseTemplate(SiteExplorerNodeType.Site);
if (templateId != null && templateId.HasValue)
{
var newNode = AddSite(null, templateId.Value);
UnplacedModel.Insert(0, newNode);
}
}).MenuItem);
builder.AddMenuItem(addSite);
builder.Separator();
builder.AddMenuItem(SiteExplorerMenuBuilder.CreateTemplateItems(this));
builder.Separator();
builder.New("Refresh").Handler(() => { Refresh(); }).End();
tvw.ContextMenu = builder.ContextMenu;
}
else if (tvw.SelectedItem is ViewModelPlaceholder)
{
var ph = tvw.SelectedItem as ViewModelPlaceholder;
switch (ph.DisplayLabel.ToLower())
{
case "site templates":
builder.New("Add new _Site Template").Handler(() => { AddSiteTemplate(); }).End();
break;
case "site visit templates":
builder.New("Add new Site _Visit Template").Handler(() => { AddSiteVisitTemplate(); }).End();
break;
case "material templates":
builder.New("Add new _Material Template").Handler(() => { AddMaterialTemplate(); }).End();
break;
}
tvw.ContextMenu = builder.ContextMenu;
}
else if (tvw.SelectedItem == templatesNode)
{
builder.AddMenuItem(SiteExplorerMenuBuilder.CreateTemplateItems(this));
tvw.ContextMenu = builder.ContextMenu;
}
else
{
tvw.ContextMenu = null;
}
}
public RegionsModel Get(int id)
{
RegionsModel ret = db.QueryFirst(modelType, "SELECT * FROM Regions where Id=@Id", new { Id = id });
return(ret);
}
public async Task <IHttpActionResult> SaveNewQuestion(RegionsModel model)
{
var result = await services.SaveNewRegion(model);
return(Ok(result));
}
