private void LoadDefaultView()
{
using (AppDataContext db = new AppDataContext())
{
var _data =
from _d in db.HostGroupInfos.AsEnumerable()
where _d.ParentGroupId == 0
select new
{
HostGroupId = _d.HostGroupId,
HostGroupName = _d.HostGroupName,
Count = db.HostTagGroupStatus.Count(x => x.HostGroupId == _d.HostGroupId),
ActiveCount = GetActiveCount(_d.HostGroupId, db)
};
RepGroup.DataSource = _data;
RepGroup.DataBind();
apCount.Value = db.APs.Count();
//apFailedCount.Value = db.APStatus.Count(x => x.APLocatorStatus == 1);
apFailedCount.Value = GetActiveAPTotalCount();
newEventCount.Value = db.DBViewTagAlerts.Count(x => x.AlertStatus == (byte)AlertStatusType.New);
//logCount.Value = db.MarshalTagLogs.Count();
DateTime weekAgo = DateTime.Now.Subtract(new TimeSpan(7, 0, 0, 0));
logCount.Value = db.DBViewTagAlerts.Count(x => x.WriteTime > weekAgo);
logFromDate.DisplayValue = weekAgo;
DateTime TwoDays = DateTime.Now.Subtract(new TimeSpan(2, 0, 0, 0));
lowBatteryCount.Value = db.GenericEventLogs.Count(x => x.WriteTime > TwoDays && x.GenericEventType == (int)SupportEvent.BatteryInsufficient && x.HostId > 0);
lowBatteryFromDate.DisplayValue = TwoDays;
}
}
public DataResponse <bool> Delete(int repgroupid)
{
var response = new DataResponse <bool>();
try
{
base.DBInit();
RepGroup repGroup = DBEntity.RepGroups.Find(repgroupid);
try
{
DBEntity.RepGroups.Remove(repGroup);
if (DBEntity.SaveChanges() > 0)
{
response.Status = DataResponseStatus.OK;
response.Message = "Successfully Deleted.";
response.Model = true;
}
}
catch (DbUpdateException ex)
{
response.Status = DataResponseStatus.InternalServerError;
response.Message = "There are some releted item in database, please delete those first.";
response.Model = false;
}
}
catch (Exception ex)
{
ex.Log();
}
finally
{
base.DBClose();
}
return(response);
}
// GET: Business/RepGroups/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RepGroup repGroup = db.RepGroups.Find(id);
if (repGroup == null)
{
return(HttpNotFound());
}
return(View(repGroup));
}
public ActionResult DeleteConfirmed(int id)
{
RepGroup repGroup = db.RepGroups.Find(id);
try
{
db.RepGroups.Remove(repGroup);
db.SaveChanges();
}
catch (DbUpdateException ex)
{
ModelState.AddModelError("Error", "There are some releted item in database, please delete those first");
return(View("Delete", repGroup));
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RepGroup repGroup = db.RepGroups.Find(id);
if (repGroup == null)
{
return(HttpNotFound());
}
var managers = db.RepgroupManagerMappers.Where(t => t.RepGroupId == repGroup.Id).Select(a => (int?)a.ManagerId).ToList();
return(View(new RepGroupModel {
Id = repGroup.Id, RepGroupName = repGroup.RepGroupName, Description = repGroup.Description, IsActive = repGroup.IsActive, SalesDirectorId = repGroup.SalesDirectorId, ManagerIds = managers
}));
}
protected void ddlrole_SelectedIndexChanged(object sender, EventArgs e)
{
RepGroup.DataSource = Mappings.Get_MenudisplayAndRole(Convert.ToInt32(ddlrole.SelectedValue)).Tables[1];
RepGroup.DataBind();
}
