public ActionResult GetAdminsByJson()
{
AdminDal dal = new AdminDal();
List <Admin> objAdmins = dal.Admins.ToList <Admin>();
return(Json(objAdmins, JsonRequestBehavior.AllowGet));
}
public List <Admin> HentAlleAdmins()
{
var AdminDAL = new AdminDal();
List <Admin> alleAdmin = AdminDAL.HentAdmins();
return(alleAdmin);
}
protected void DelAdminServer()
{
string ips = (Request.Form["id"] ?? "");
if (ips.Length == 0)
{
Response.Write("未提交数据");
return;
}
string sqlIps = String.Empty;
foreach (var ip in ips.Split(','))
{
string item = ip.Trim().Replace("'", "");
if (item.Length > 0)
{
if (sqlIps.Length > 0)
{
sqlIps += ",";
}
sqlIps += "'" + item + "'";
}
}
string ret = AdminDal.DelAdminServer(sqlIps);
Response.Write(ret);
}
public string GetShippingMethodListFromService()
{
var adminDal = new AdminDal();
string theXml = adminDal.GetShippingMethodFromDBXml();
return(theXml);
}
public ActionResult SlettFilm(int id)
{
AdminDal slett = new AdminDal();
slett.SlettFilm(id);
return(RedirectToAction("FilmListe"));
}
public JsonResult viewPunchList()
{
var role = Convert.ToString(Session["Role"]);
var user = Convert.ToString(Session["UserId"]);
return(Json(AdminDal.ViewPunchlist(role, user)));
}
public ActionResult saveMaintenance(Contract modelContract)
{
try
{
if (!string.IsNullOrWhiteSpace(Convert.ToString(modelContract.PRJID)) && Convert.ToInt32(modelContract.PRJID) > 0)
{
var ResultId = AdminDal.saveMaintenance(modelContract);
if (ResultId > 0)
{
return(RedirectToAction("billing", "admin"));
}
else
{
ModelState.AddModelError("", BusinessConstants.ValidateEntries);
return(View("billing/projmaintenance", modelContract));
}
}
else
{
ModelState.AddModelError("", "Project cannot be saved! Please try again");
return(View("billing/projmaintenance", modelContract));
}
}
catch (Exception e)
{
Logger.SaveErr(e);
ModelState.AddModelError("Error", BusinessConstants.contactAdmin);
return(View("billing/projmaintenance", modelContract));
}
}
public ActionResult Login(string username, string password)
{
if (ModelState.IsValid)
{
UserDal dal = new UserDal();
AdminDal addal = new AdminDal();
if (dal.Users.Where(s => s.USERNAME.Equals(username) && s.PASSWORD.Equals(password)).Count() > 0)
{
//add session
Session["USERNAME"] = dal.Users.Where(s => s.USERNAME.Equals(username) && s.PASSWORD.Equals(password)).FirstOrDefault().USERNAME;
Session["PASSWORD"] = dal.Users.Where(s => s.USERNAME.Equals(username) && s.PASSWORD.Equals(password)).FirstOrDefault().PASSWORD;
return(RedirectToAction("Home", "Home"));
}
else if (addal.Admin.Where(s => s.USERNAME.Equals(username) && s.PASSWORD.Equals(password)).Count() > 0)
{
Session["USERNAME"] = addal.Admin.Where(s => s.USERNAME.Equals(username) && s.PASSWORD.Equals(password)).FirstOrDefault().USERNAME;
Session["PASSWORD"] = addal.Admin.Where(s => s.USERNAME.Equals(username) && s.PASSWORD.Equals(password)).FirstOrDefault().PASSWORD;
return(RedirectToAction("SlideMenu", "Admin"));
}
}
return(View());
}
public ActionResult Verify()//action result for logging in
{
string rcvUserName = Request.Form["user.UserName"];
string rcvPassword = Request.Form["user.UserPassword"];
UsersDal dal = new UsersDal();
List <Users> usrobj =
(from y in dal.users
where y.UserName.Equals(rcvUserName)
select y).ToList <Users>();
if (usrobj.Count > 0 && usrobj[0].UserPassword == rcvPassword) //checks for password equality in db
{
AdminDal adal = new AdminDal();
List <Admin> adminlist = (from x in adal.admin where x.AUserName.Equals(rcvUserName) select x).ToList <Admin>();//checking if loged user is admin
if (adminlist.Count > 0)
{
Session["isadmin"] = true;
}
else
{
Session["isadmin"] = false;
}
Session["signedin"] = usrobj[0];
return(View("../Home/ShowHomePage", (new ProductsVM()
{
products_list = (new ProductsDal().products.ToList())
}))); //returns to home page and loading products
}
ViewBag.message = "Wrong user name or password pls try again"; // the login form will check for that message if called
return(View("Login"));
}
public ActionResult Leggfilm(Film innFilm)
{
AdminDal legg = new AdminDal();
legg.LeggFilm(innFilm);
return(RedirectToAction("FilmListe"));
}
// Register a user to system
public ActionResult Register(RegularUser user)
{
if (ModelState.IsValid)
{
ViewBag.Message = "";
ViewData["userNameError"] = "";
ViewData["emailError"] = "";
ViewData["missingInputError"] = "";
AdminDal adDal = new AdminDal();
Admin admin = new Admin(user.userName, user.password);
UserDal dal = new UserDal();
if (dal.locate(user) || adDal.locate(admin))
{
ViewData["userNameError"] = "User name is already exist!";
return(View("Register", user));
}
if (dal.locateEmail(user.email))
{
ViewData["emailError"] = "E-mail is already exist!";
return(View("Register", user));
}
if (!checkRegisterForm(user))
{
ViewData["missingInputError"] = "One of the inputs is missing!";
return(View("Register", user));
}
if (user.password != Request.Form["passwordRetype"])
{
ViewBag.Message = "The passwords don't match";
user.password = null;
return(View("Register", user));
}
MailAddress mail = new MailAddress(user.email);
if (mail == null)
{
user.password = null;
return(View("Register", user));
}
Session["tempUser"] = user;
Session["tempUserType"] = "regularUser";
UserDal dalAdding = new UserDal();
dalAdding.addUser(user);
return(RedirectToAction("index", "Home"));
}
else
{
user.password = null;
return(View("Register", user));
}
}
protected void AddAdminServer()
{
string[] servers = (Request.Form["sip"] ?? "").Split(new char[] { ';', ',' }, StringSplitOptions.RemoveEmptyEntries);
string desc = (Request.Form["desc"] ?? "").Trim();
string ret = AdminDal.AddAdminServer(servers, desc, m_remoteIpLst);
Response.Write(ret);
}
public JsonResult searchList(string projectName, string City)
{
List <SearchPunchListModel> PunchList = new List <SearchPunchListModel>();
if (!string.IsNullOrWhiteSpace(projectName) && !string.IsNullOrWhiteSpace(City))
{
PunchList = AdminDal.searchPunchList(projectName, City);
}
return(Json(PunchList));
}
public JsonResult getAiaBilling(string PRJID, string BIDID)
{
AIABilling modelBilling = null;
if (!string.IsNullOrWhiteSpace(PRJID) && !string.IsNullOrWhiteSpace(BIDID))
{
modelBilling = AdminDal.getAIABilling(PRJID, BIDID);
}
return(Json(modelBilling));
}
public JsonResult UpdatePunchListStatus(int punchId, string status)
{
int result = -2;
if (punchId > 0)
{
result = AdminDal.UpdatePunchListStatus(punchId, status);
}
return(Json(result));
}
void AddAdminIp()
{
string[] clients = (Request.Form["cip"] ?? "").Split(new char[] { ';', ',' }, StringSplitOptions.RemoveEmptyEntries);
string[] server = (Request.Form["sip"] ?? "").Split(new char[] { ';', ',' }, StringSplitOptions.RemoveEmptyEntries);
string desc = (Request.Form["desc"] ?? "").Trim();
string ret = AdminDal.AddAdminIp(clients, server, desc, m_remoteIpLst);
Response.Write(ret);
}
public ActionResult saveAiabilling(AIABilling modelBilling)
{
int id = modelBilling.PRJID;
try
{
modelBilling.NetChangeByCO = Convert.ToDecimal(modelBilling.NetChangeByCO);
modelBilling.OriginalContractSum = Convert.ToDecimal(modelBilling.OriginalContractSum);
modelBilling.UnitPrice = Convert.ToDecimal(modelBilling.UnitPrice).ToString();
if (ModelState.IsValid)
{
if (!string.IsNullOrWhiteSpace(Convert.ToString(modelBilling.PRJID)) && Convert.ToInt32(modelBilling.PRJID) > 0)
{
var ResultId = AdminDal.saveAiaBilling(modelBilling);
if (ResultId > 0)
{
return(RedirectToAction("billing", "admin"));
}
else
{
ViewBag.UOMTypes = new SelectList(Atlas.DataAccess.Entity.Common.getUnitofMeasure(), "UnitOfMeasure", "UomDescription");
//ar BidItems = ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)).Select(i=>i.BidItemId);
ViewBag.BidItems = new SelectList(ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)), "BidItemId", "BidItemId");
ModelState.AddModelError("", BusinessConstants.ValidateEntries);
return(View("billing/aiabilling", modelBilling));
}
}
else
{
ViewBag.UOMTypes = new SelectList(Atlas.DataAccess.Entity.Common.getUnitofMeasure(), "UnitOfMeasure", "UomDescription");
//ar BidItems = ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)).Select(i=>i.BidItemId);
ViewBag.BidItems = new SelectList(ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)), "BidItemId", "BidItemId");
ModelState.AddModelError("", "Project cannot be saved! Please try again");
return(View("billing/aiabilling", modelBilling));
}
}
else
{
ViewBag.UOMTypes = new SelectList(Atlas.DataAccess.Entity.Common.getUnitofMeasure(), "UnitOfMeasure", "UomDescription");
//ar BidItems = ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)).Select(i=>i.BidItemId);
ViewBag.BidItems = new SelectList(ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)), "BidItemId", "BidItemId");
ModelState.AddModelError("", BusinessConstants.ValidateEntries);
return(View("billing/aiabilling", modelBilling));
}
}
catch (Exception e)
{
ViewBag.UOMTypes = new SelectList(Atlas.DataAccess.Entity.Common.getUnitofMeasure(), "UnitOfMeasure", "UomDescription");
//ar BidItems = ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)).Select(i=>i.BidItemId);
ViewBag.BidItems = new SelectList(ProjectDAL.GetBidItemsByProject(Convert.ToInt32(id)), "BidItemId", "BidItemId");
Logger.SaveErr(e);
ModelState.AddModelError("", BusinessConstants.contactAdmin);
return(View("billing/aiabilling", modelBilling));
}
}
/// <summary>
/// 获取一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnResult <Admin> GetOne(Admin model)
{
var rst = new ReturnResult <Admin>();
using (var dal = new AdminDal())
{
rst = dal.GetOne(model);
}
return(rst);
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnResult <bool> Delete(Admin model)
{
var rst = new ReturnResult <bool>();
using (var dal = new AdminDal())
{
rst = dal.Delete(model);
}
return(rst);
}
/// <summary>
/// 新增多条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnResult <bool> AddList(List <Admin> list)
{
var rst = new ReturnResult <bool>();
using (var dal = new AdminDal())
{
rst = dal.AddList(list);
}
return(rst);
}
public DataTable fetchBal(AdminProp pr)
{
try
{
AdminDal dal = new AdminDal();
return(dal.fetch(pr));
}
catch (Exception e)
{
return(null);
}
}
public ActionResult Admin(Admin obj)
{
if (ModelState.IsValid)
{
AdminDal AD = new AdminDal();
AD.Admin.Add(obj);
AD.SaveChanges();
return(RedirectToAction("SlideMenu", "Admin"));
}
return(View("Admin", obj));
}
public int AddBal(AdminProp pr)
{
try
{
AdminDal dal = new AdminDal();
return(dal.Add(pr));
}
catch (Exception e)
{
return(0);
}
}
public ActionResult Edit([Bind(Include = "Id,Title,Pris,Catrgory,Discription")] Film film)
{
AdminDal admin = new AdminDal();
if (ModelState.IsValid)
{
admin.EditFilm(film);
return(RedirectToAction("FilmListe"));
}
return(View());
}
public JsonResult UpdateProjectBid(int id, string action, string title)
{
int result = -2;
if (title == "job")
{
result = AdminDal.UpdateProject(id, action);
}
else if (title == "bid")
{
result = AdminDal.UpdateBid(id, action);
}
return(Json(result));
}
public ActionResult SubLoginAdmin(Admin obj)
{
AdminDal dal = new AdminDal();
string email = obj.email.ToString();
string password = obj.password.ToString();
List <Admin> exist = (from x in dal.Admins where x.email.Equals(email) && x.password.Equals(password) select x).ToList <Admin>();
if (exist.Count != 0)
{
return(RedirectToAction("AddMovie", "Admin"));
}
TempData["testmsg"] = "Some information is wrong please check again!!!";
return(View("LoginAdmin", obj));
}
public ActionResult Delete(int id)
{
SystemAdmin user = adminUsers.First(s => s.Id.Equals(id));
if (user != null)
{
AdminDal.DeleteAdmin(user.Id);
TempData["success"] = string.Format("{0} raderades", user.Username);
}
else
{
TempData["error"] = "Kunde inte radera adminstratören";
}
return(RedirectToAction("Index"));
}
public ActionResult saveComplaint(Complaints modelComplaint)
{
try
{
if (!string.IsNullOrWhiteSpace(Convert.ToString(Session["LoggedInUser"])))
{
if (String.IsNullOrWhiteSpace(modelComplaint.JobNotes))
{
return(View(modelComplaint));
}
var ComplaintId = AdminDal.saveComplaint(modelComplaint, Session["LoggedInUser"].ToString());
if (ComplaintId > 0)
{
string Subject = modelComplaint.JobNumber + " " + modelComplaint.JobName + " -- PUNCHLIST ITEM ID " + ComplaintId;
string body = string.Empty;
using (StreamReader reader = new StreamReader(Server.MapPath("~/content/template/PunchListTemplate.html")))
{
body = reader.ReadToEnd();
}
body = body.Replace("{punchlistid}", ComplaintId.ToString());
body = body.Replace("{jobnumber}", modelComplaint.JobNumber);
body = body.Replace("{jobname}", modelComplaint.JobName);
body = body.Replace("{jobphone}", modelComplaint.JobPhone);
body = body.Replace("{contact}", modelComplaint.JobContact);
body = body.Replace("{salesman}", modelComplaint.Salesman);
body = body.Replace("{complaint}", modelComplaint.JobNotes);
MailUtil mailUtil = new MailUtil(Subject, body.ToString());
mailUtil.Send();
return(RedirectToAction("search", "admin"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
catch (Exception e)
{
Logger.SaveErr(e);
ModelState.AddModelError("Error", BusinessConstants.ValidateEntries);
return(View());
}
return(RedirectToAction("search", "admin"));
}
void RunSql()
{
string sql = (Request.Form["sql"] ?? "").Trim();
string db = (Request.Form["db"] ?? "").Trim();
if (db == string.Empty || sql == string.Empty)
{
Response.Write("db或sql不能为空");
return;
}
if (!File.Exists(db))
{
Response.Write("db不存在:" + db);
return;
}
Response.Write(AdminDal.RunSql(db, sql));
}
public ActionResult Register(SystemAdmin user)
{
if (ModelState.IsValid)
{
try
{
AdminDal.CreateAdmin(user);
TempData["success"] = string.Format("Användaren {0} har skapats", user.Username);
}
catch (Exception ex)
{
TempData["error"] = string.Format("Felmeddelande: {0}", ex.Message);
}
}
return(View(user));
}
