public ActionResult CreateLogger(zone zo)
{
if (ModelState.IsValid)
{
using (var northwind = new hercules_dbEntities())
{
// Create a new Product entity and set its properties from the posted ProductViewModel
var entity = new zone
{
ZoneName = zo.ZoneName,
Status = true,
CreationDate = DateTime.Now
};
// Add the entity
northwind.zones2.Add(entity);
// Insert the entity in the database
northwind.SaveChanges();
// Get the ProductID generated by the database
}
}
return Redirect("List");
}
public ActionResult Create(loggers d)
{
if (ModelState.IsValid)
{
using (var northwind = new hercules_dbEntities())
{
//Get max ID table loggers
var crum = northwind.loggers.Max(sd => sd.ID);
int current_id = Convert.ToInt32(crum.ToString());
// Create a new Product entity and set its properties from the posted ProductViewModel
var entity = new loggers
{
ID = current_id + 1,
LoggerSMSNumber = d.LoggerSMSNumber,
LoggerSerialNumber = d.LoggerSerialNumber,
Notes = d.Notes,
CreationDate = DateTime.Now,
Adress = d.Adress,
LatEast = d.LatEast,
LongNorth = d.LongNorth,
HeightAOD = d.HeightAOD,
LoggerTypeClass = d.LoggerTypeClass,
SiteID = d.SiteID,
OwnerAccount = Convert.ToInt16(Session["LogedUserID"].ToString()),
CompanyID = Convert.ToInt16(Session["CompanyID"].ToString()),
LoggerStatus = true
};
// Add the entity
northwind.loggers.Add(entity);
// Insert the entity in the database
northwind.SaveChanges();
// Get the ProductID generated by the database
}
return RedirectToAction("ListLogger");
// return View();
}
else
{
return View();
}
}
public ActionResult Delete([DataSourceRequest] DataSourceRequest request,loggers log)
{
using (var db = new hercules_dbEntities())
{
var result = from u in db.loggers where (u.ID == log.ID) select u;
if (result.Count() != 0)
{
var dbuser = result.First();
dbuser.LoggerStatus = false;
db.SaveChanges();
}
}
return Json(new[] { log }.ToDataSourceResult(request, ModelState));
}
public ActionResult Create(users us)
{
if (ModelState.IsValid)
{
using (var northwind = new hercules_dbEntities())
{
//Get max ID table loggers
var crum = northwind.users.Max(sd => sd.Id);
int current_id = Convert.ToInt32(crum.ToString());
var entity = new users
{
Id = current_id+1,
FirstName = us.FirstName,
LastName = us.LastName,
Username = us.Username,
Password = us.Password,
Email = us.Email,
Mobile = us.Mobile,
DateCreated = DateTime.Now,
Role = us.Role,
RecieveNotifications = us.RecieveNotifications,
Status = true,
CompanyID = Convert.ToInt16(Session["CompanyID"].ToString())
};
// Add the entity
northwind.users.Add(entity);
// Insert the entity in the database
northwind.SaveChanges();
return RedirectToAction("List");
}
}
else{
return View(us);
}
}
public ActionResult Edit([DataSourceRequest] DataSourceRequest request, zone product)
{
// DataClasses1DataContext dt = new DataClasses1DataContext();
if (product != null)
// && ModelState.IsValid
{
using (var db = new hercules_dbEntities())
{
var result = from u in db.zones2 where (u.ID == product.ID) select u;
if (result.Count() != 0)
{
var dbuser = result.First();
dbuser.ZoneName = product.ZoneName;
dbuser.Status = product.Status.Value;
db.SaveChanges();
}
}
}
return Json(new[] { product }.ToDataSourceResult(request, ModelState));
}
public ActionResult Login(user u)
{
// this action is for handle post (login)
if (ModelState.IsValid) // this is check validity
{
using (var mc = new hercules_dbEntities())
{
var vc = mc.company.Where(c => c.CompanyName.Equals(u.Email)).FirstOrDefault();
if (vc != null)
{
Session["CompanyID"] = vc.ID.ToString();
Session["CompanyName"] = vc.CompanyName.ToString();
}
else
{
Session["CompanyID"] = null;
Session["CompanyName"] = null;
}
}
using (hercules_dbEntities dc = new hercules_dbEntities())
{
if (Session["CompanyID"] != null) {
Int32 value_company_id = Convert.ToInt32(Session["CompanyID"].ToString());
var v = dc.users.Where(a => a.Username.Equals(u.Username) && a.Password.Equals(u.Password) && a.CompanyID.Equals(value_company_id)).FirstOrDefault();
if (v != null)
{
//Update the last connection by user
var update = from fu in dc.users where (fu.Id == v.Id) select fu;
if (update.Count() != 0) {
var dbuser = update.First();
dbuser.LastLogin = DateTime.Now;
dc.SaveChanges();
}
Session["LogedUserID"] = v.Id.ToString();
Session["LogedUserFullname"] = v.Username.ToString();
FormsAuthentication.SetAuthCookie(v.Username.ToString(), true);
return RedirectToAction("List","Dashboard");
}else
ModelState.AddModelError("", Resources.ResourceLanguage.UserInvalid);
}else
ModelState.AddModelError("", Resources.ResourceLanguage.UserInvalid);
}
}
return View(u);
}
public ActionResult Create(sites d)
{
if (ModelState.IsValid)
{
using (var db = new hercules_dbEntities())
{
//Get max ID table loggers
var crum = db.loggers.Max(sd => sd.ID);
int current_id = Convert.ToInt32(crum.ToString());
//list logger
string[] temporale;
ArrayList id_logger = new ArrayList();
ArrayList type_logger = new ArrayList();
int limit_pcp = 0 ;
int limit_erp =0;
IEnumerable source = d.SelectedLogger;
if (source != null)
{
foreach (var element in source)
{
temporale = element.ToString().Split(' ');
type_logger.Add(temporale[0].ToString());
id_logger.Add(temporale[1].ToString());
if (temporale[0].ToString() == "PCP")
limit_pcp = limit_pcp + 1;
if (temporale[0].ToString() == "ERP")
limit_erp = limit_erp + 1;
}
if (limit_erp > 1){
ViewBag.DataExists = true;
//ViewBag.Javascript = "<script language='javascript' type='text/javascript'>alert('Max 1 ERP by Site');</script>";
return RedirectToAction("Create");
}
else if (limit_pcp > 3)
{
ViewBag.DataExists = true;
//ViewBag.Javascript = "<script language='javascript' type='text/javascript'>alert('Max 3 PCP by Site');</script>";
return RedirectToAction("Create");
}
else
{
for (int i = 0; i < id_logger.Count; i++)
{
int id =Convert.ToInt16(id_logger[i]);
var result = from u in db.loggers where (u.ID == id ) select u;
if (result.Count() != 0)
{
var dblogger = result.First();
dblogger.SiteID = current_id;
db.SaveChanges();
}
}
}
}
var entity = new sites
{
ID = current_id + 1,
Address = d.Address,
ZoneID = d.ZoneID,
Notes = d.Notes,
CompanyID = Convert.ToInt16(Session["CompanyID"].ToString()),
CreateDate = DateTime.Now,
OwnerAccount = Convert.ToInt16(Session["LogedUserID"].ToString()),
};
// Add the entity
db.sites.Add(entity);
// Insert the entity in the database
db.SaveChanges();
}
RedirectToAction("List");
return View();
}
else
return View();
}
public ActionResult Edit([DataSourceRequest] DataSourceRequest request, users us)
{
if (ModelState.IsValid)
{
using (var db = new hercules_dbEntities())
{
var result = from u in db.users where (u.Id == us.Id) select u;
if (result.Count() != 0)
{
var dbuser = result.First();
dbuser.FirstName = us.FirstName;
dbuser.LastName = us.LastName;
dbuser.Username = us.Username;
dbuser.Password = us.Password;
dbuser.Email = us.Email;
dbuser.Mobile = us.Mobile;
dbuser.Role = us.Role;
dbuser.RecieveNotifications = us.RecieveNotifications;
dbuser.Status = us.Status;
db.SaveChanges();
}
}
}
return RedirectToAction("List");
}
public ActionResult Edit([DataSourceRequest] DataSourceRequest request, loggers us)
{
if (ModelState.IsValid)
{
using (var db = new hercules_dbEntities())
{
var result = from u in db.loggers where (u.ID == us.ID) select u;
if (result.Count() != 0)
{
var dblogger = result.First();
dblogger.LoggerSMSNumber = us.LoggerSMSNumber;
dblogger.LoggerSerialNumber = us.LoggerSerialNumber;
dblogger.Notes = us.Notes;
dblogger.Adress = us.Adress;
dblogger.LatEast = us.LatEast;
dblogger.LongNorth = us.LongNorth;
dblogger.HeightAOD = us.HeightAOD;
dblogger.LoggerTypeClass = us.LoggerTypeClass;
if(us.SiteID != null)
dblogger.SiteID = us.SiteID;
db.SaveChanges();
}
}
}
return RedirectToAction("ListLogger");
}
