Esempio n. 1
0
        // GET: Companies/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CompanyTO company = cmpRepo.getAllCompanybyId(id);

            List <UserAccess> userAccess = cmpRepo.getAllUserAccess().Where(x => x.CompanyId == id).ToList();
            List <int>        userRoleId = new List <int>();

            foreach (var item in userAccess)
            {
                userRoleId.Add(item.UserRoleId);
            }

            var userRolesIsAdmin = cmpRepo.getAllUserrole().Where(c => userRoleId.Contains(c.UserRoleId)).Select(x => new { x.EmailId, x.IsAdmin }).ToList();

            //string contactEmailId=


            company.Company_Admin    = userRolesIsAdmin.Where(x => x.IsAdmin == true).Select(x => x.EmailId).FirstOrDefault();
            company.Company_Contacts = userRolesIsAdmin.Where(x => x.IsAdmin == false).Select(x => x.EmailId).FirstOrDefault();

            if (company == null)
            {
                return(HttpNotFound());
            }
            return(View(company));
        }
Esempio n. 2
0
        private static CompanyTO MapElement(DataRow row)
        {
            CompanyTO company = new CompanyTO();

            company.ID           = Convert.ToInt32(row["ID"]);
            company.Name         = Convert.ToString(row["Name"]);
            company.Logo         = Convert.ToString(row["LogoPath"]);
            company.ContactName  = Convert.ToString(row["ContactName"]);
            company.ContactEmail = Convert.ToString(row["ContactEmail"]);

            return(company);
        }
Esempio n. 3
0
        // GET: Companies/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CompanyTO company = cmpRepo.getAllCompanybyId(id);

            if (company == null)
            {
                return(HttpNotFound());
            }
            return(View(company));
        }
Esempio n. 4
0
        public void saveCompany(CompanyTO company)
        {
            Company dataTOsave = new Company()
            {
                Company_Name     = company.Company_Name,
                CompanyColor     = company.CompanyColor,
                Company_Admin    = company.Company_Admin,
                Company_Contacts = company.Company_Contacts,
                IsActive         = true
            };


            db.Companies.Add(dataTOsave);
            db.SaveChanges();
            int companyId = db.Companies.Where(x => x.Company_Name == company.Company_Name).Select(x => x.Company_Id).FirstOrDefault();

            if (company.Company_Admin != "")
            {
                UserRole users = new UserRole();
                users.EmailId = company.Company_Admin;
                users.IsAdmin = true;
                saveUserrole(users);

                UserAccess Role = new UserAccess()
                {
                    CompanyId  = companyId,
                    UserRoleId = getAllUserrole().Where(x => x.EmailId == company.Company_Contacts).Select(x => x.UserRoleId).FirstOrDefault()
                };
                saveUserAccess(Role);
            }

            if (company.Company_Contacts != "")
            {
                UserRole users = new UserRole();
                users.EmailId = company.Company_Admin;
                users.IsAdmin = false;
                saveUserrole(users);

                UserAccess Role = new UserAccess()
                {
                    CompanyId  = companyId,
                    UserRoleId = getAllUserrole().Where(x => x.EmailId == company.Company_Contacts).Select(x => x.UserRoleId).FirstOrDefault()
                };

                saveUserAccess(Role);
            }

            db.SaveChanges();
        }
Esempio n. 5
0
        public static CompanyTO GetById(int id)
        {
            CompanyTO company     = null;
            string    execCommand = String.Format(
                " SELECT ID, Name, LogoPath, ContactName, ContactEmail " +
                " FROM company " +
                " WHERE ID = {0}", id);

            DataTable table = ExecuteCommand(execCommand);

            if (table != null && table.Rows.Count > 0)
            {
                company = MapElement(table.Rows[0]);
            }

            return(company);
        }
Esempio n. 6
0
        public ActionResult Create([Bind(Include = "Company_Id,Company_Name,IsActive,Company_Contacts,Company_Admin,CompanyColor")] CompanyTO company)
        {
            if (company.Company_Name != "" && company.CompanyColor != "")
            {
                var Color_exist = cmpRepo.getAllCompanies().Where(x => x.CompanyColor == company.CompanyColor).FirstOrDefault();
                if (Color_exist != null && Color_exist.Company_Id != company.Company_Id)
                {
                    ModelState.AddModelError(string.Empty, "Please choose different color");
                    return(View(company));
                }
                //logic to enter the users
                else
                {
                    cmpRepo.saveCompany(company);
                }



                return(RedirectToAction("Index"));
            }

            return(View(company));
        }
 public void GetById_CompanyDoesNotExist_CompanyIsNull()
 {
     Company company = new Company();
     CompanyTO info = company.Get(0);
     Assert.IsNull(info);
 }
 public void GetById_DefaultCompanyHasID_IdSentEqualToReceived()
 {
     Company company = new Company();
     CompanyTO info = company.Get(DEFAULT_ID);
     Assert.AreEqual(DEFAULT_ID, info.ID);
 }
 public void GetById_DefaultCompanyHasEmail_EmailHasValue()
 {
     Company company = new Company();
     CompanyTO info = company.Get(DEFAULT_ID);
     Assert.AreEqual(true, !String.IsNullOrEmpty(info.ContactEmail));
 }
 public void GetById_DefaultCompanyHasName_NameHasValue()
 {
     Company company = new Company();
     CompanyTO info = company.Get(DEFAULT_ID);
     Assert.AreEqual(true, !String.IsNullOrEmpty(info.Name));
 }
 public void GetById_DefaultCompanyExists_CompanyIsNotNull()
 {
     Company company = new Company();
     CompanyTO info = company.Get(DEFAULT_ID);
     Assert.IsNotNull(info);
 }
Esempio n. 12
0
 public CompanyTO Get(int id)
 {
     info = CompanyPersistence.GetById(id);
     return(info);
 }
Esempio n. 13
0
 public Company()
 {
     info = null;
 }