コード例 #1
0
        /// <summary>
        /// Updates an item in the database
        /// </summary>
        /// <param name="item">the company that will be updated</param>
        /// <returns>true if it succeds</returns>
        public bool Update(Company item)
        {
            try
            {
                using (var ctx = new Context())
                {
                    Company result = ctx.Entry(item).Entity;
                   
                    if (result == null)
                    {
                        return false;
                    }
                    
                    foreach (var empsToAttach in item.Employees)
                    {
                        ctx.Employees.Attach(empsToAttach);
                    }

                    //sets the information
                    result.Employees = item.Employees;
                    result.Name = item.Name;
                    result.PhoneNr = item.PhoneNr;

                    ctx.Entry(result).State = EntityState.Modified;

                    ctx.SaveChanges();
                    return true;
                }
            }
            catch(Exception e) {
                return false;
            }
        }
コード例 #2
0
        public void Company_With_The_Same_Id_Should_Be_Equal_Test()
        {
            Company comp1 = new Company { Id = 1};
            Company comp2 = new Company {Id =1};

            Assert.AreEqual(comp1.Id,comp2.Id);
        }
コード例 #3
0
        public void Getters_And_Setters_Test()
        {
            List<Employee> employees = new List<Employee>();
            Employee emp1 = new Employee()
            {
                Id = 1,
                FirstName = "First Employee",
                 
            };
            Employee emp2 = new Employee()
            {
                Id = 1,
                FirstName = "First Employee",
                
            };
            employees.Add(emp1);
            employees.Add(emp2); 


            Company comp = new Company() {
                Id = 1,
                Name = "Big Company",
                
                PhoneNr = "12345678",
                Employees = employees,
                Active = true,

            };

            Assert.AreEqual(comp.Id, 1);
            Assert.AreEqual(comp.Name, "Big Company");
            Assert.AreEqual(comp.PhoneNr, "12345678");
            Assert.AreEqual(comp.Employees, employees);
            Assert.AreEqual(comp.Active,true);
        }
コード例 #4
0
        /// <summary>
        /// This will generate a new company from a view company
        /// </summary>
        /// <param name="comp">the company to be generated</param>
        /// <returns>the company that should be added to the database</returns>
        public Company GenerateCompany(ViewCompany comp, int _lenghtOfPassword, int _numberOfAlphabeticCharacters)
        {

            var result = new Company() {Active = true, Name = comp.Name, PhoneNr = comp.PhoneNr};

            //Generates a random password, and makes a new user with the correct email
            var password = System.Web.Security.Membership.GeneratePassword(_lenghtOfPassword, _numberOfAlphabeticCharacters);
            var um = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(new DAL.Context.Context()));
            var user = new ApplicationUser()
            {
                UserName = comp.Email,
                Email = comp.Email
            };

            um.Create(user, password);
            //Generates the access string by encoding the email and the password into an array of bytes.
            var bytes = System.Text.Encoding.UTF8.GetBytes(comp.Email + ":" + password);
            result.AccessString = System.Convert.ToBase64String(bytes);
            result.Active = true;

            //This will be so that the database will make the relation between the two.
            var item = um.FindByEmail(comp.Email);
            result.IdentityId = item.Id;

            return result;
        }
コード例 #5
0
        //Checks wether the recieved employee is already within the company list of employees.
        private bool ContainsEmployee(Company comp, Employee emp)
        {
            bool contains = false;

            contains = comp.Employees.FirstOrDefault(c => c.Address.Equals(emp.Address) && c.BirthDate.Year == emp.BirthDate.Year && c.BirthDate.Month == emp.BirthDate.Month && c.BirthDate.Day == emp.BirthDate.Day && c.FirstName.Equals(emp.FirstName)
            && c.LastName.Equals(emp.LastName) && c.Phone.Equals(emp.Phone)) != null;

            return contains;
        }
コード例 #6
0
        /// <summary>
        /// Add an item, to the database
        /// </summary>
        /// <param name="item">The item to be added</param>
        /// <returns>The same company but now with a primary key.</returns>
        public Company Add(Company item)
        {
            using (var ctx = new Context())
            {
                var result = ctx.Companies.Add(item);
                
                ctx.SaveChanges();

                return result;
            }
        }
コード例 #7
0
        /// <summary>
        /// This will parse a company to a view company
        /// </summary>
        /// <param name="company">The company to be converted</param>
        /// <returns>A view company corresponding to the given company</returns>
        public ViewCompany ParseCompany(Company company)
        {
            var um = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(new DAL.Context.Context()));
            var user = um.FindById(company.IdentityId);

            //We are working with seeded data, which we cannot give an Identity, therefore we add in this small hack.
            if (user == null)
                return new ViewCompany() { AccessString = company.AccessString, Active = company.Active, Email = "*****@*****.**", Employees = company.Employees, PhoneNr = company.PhoneNr, Id = company.Id, Name = company.Name };
            else
                return new ViewCompany() {AccessString = company.AccessString, Active = company.Active, Email = user.Email, Employees = company.Employees, PhoneNr = company.PhoneNr, Id = company.Id, Name = company.Name};
        }
コード例 #8
0
        public void Getters_And_Setters_Test()
        {    

            Company comp = new Company()
            {
                Id = 1,
                Name = "Big Company",
                PhoneNr = "12345678",
                Active = true,

            };

            List<Employee> employees = new List<Employee>();
            Employee emp1 = new Employee()
            {
                Id = 1,
                FirstName = "First Employee",

            };
            Employee emp2 = new Employee()
            {
                Id = 1,
                FirstName = "First Employee",

            };
            employees.Add(emp1);
            employees.Add(emp2);



            Log log = new Log()
            {
                Id = 1,
                Company = comp,
                Date = DateTime.Now.Date,
                Import = true,
                Employees = employees,
                Active=true


            };
            Assert.AreEqual(log.Id, 1);
            Assert.AreEqual(log.Company, comp);
            Assert.AreEqual(log.Date, DateTime.Now.Date);
            Assert.AreEqual(log.Import, true);
            Assert.AreEqual(log.Employees, employees);
            Assert.AreEqual(log.Active, true);

        }
コード例 #9
0
        public void Getters_And_Setters_Test()
        {
            
            Company comp = new Company()
            {
                Id = 1,
                Name = "Big Company",
                PhoneNr = "12345678",
                Active = true,

            };

            List<Log> logs = new List<Log>();
            Log log = new Log()
            {
                Id = 1,
                Company = comp,
                Date = DateTime.Now.Date,
                Import = true,

            };
            Log log2 = new Log()
            {
                Id = 1,
                Company = comp,
                Date = DateTime.Now.Date,
                Import = false,

            };
            logs.Add(log);
            logs.Add(log2);
            Employee emp = new Employee()
            {
                Id = 1,
                FirstName = "First ",
                LastName = "Employee",
                Country = "Denmark",
                ZipCode = 6700,
                City = "Esbjerg",
                Address = "This Vej 7",
                BirthDate = DateTime.Now.Date,
                Rank = "Captain",
                Phone = "1111111",
                Company = comp,
                Active =true,
                Logs = logs
                
            };


            Assert.AreEqual(emp.Id, 1);
            Assert.AreEqual(emp.FirstName, "First ");
            Assert.AreEqual(emp.LastName, "Employee");
            Assert.AreEqual(emp.Country, "Denmark");
            Assert.AreEqual(emp.Address, "This Vej 7");
            Assert.AreEqual(emp.ZipCode, 6700);
            Assert.AreEqual(emp.City, "Esbjerg");
            Assert.AreEqual(emp.BirthDate, DateTime.Now.Date);
            Assert.AreEqual(emp.Rank, "Captain");
            Assert.AreEqual(emp.Phone,"1111111");
            Assert.AreEqual(emp.Company, comp);
            Assert.IsTrue(emp.Active);
            Assert.AreEqual(emp.Logs, logs);

        }
コード例 #10
0
        /// <summary>
        /// will deactivate an item
        /// </summary>
        /// <param name="item">the item to be deactivated</param>
        /// <returns>true if the item was successfully deactivated</returns>
        public bool ChangeState(Company item)
        {
            using (var ctx = new Context())
            {
                var result = ctx.Entry(item).Entity;
                if (result == null)
                {
                    return false;
                }
                if (result.Active) { 
                result.Active = false;
                }
                else {
                    result.Active = true;
                }

                ctx.Entry(result).State = EntityState.Modified;
                
                ctx.SaveChanges();
              
                return true;
            }
        }
コード例 #11
0
ファイル: Company.cs プロジェクト: haifuge/cr16gd
        public void AppendCompanyInfo(Company company)
        {
            string sql = "update Company set CorporateRepresentative=N'" + company.CorporateRepresentive + "', RepPhone='" + company.RepPhone + "', Contact=N'" + company.Contact + "', ContactPhone='" + company.ContactPhone + "',ContactAddress='" + company.ContactAddress + "',ConstructionContent=N'" + company.ConstructionContent + "',Note=N'" + company.Note + "' where Id=" + company.Id;

            DBHelper.ExecuteNonQuery(sql);
        }
コード例 #12
0
ファイル: Company.cs プロジェクト: haifuge/cr16gd
        public void UpdateCompanyPics(Company company)
        {
            string sql = @"declare @refpath nvarchar(400);
                           declare @blpath nvarchar(400);
                           declare @scpath nvarchar(400);
                           declare @ripath nvarchar(400);
                           declare @cipath nvarchar(400);";

            if (company.ReferreIDPic == "")
            {
                sql += " set @refpath=''; ";
            }
            else
            {
                sql += " select @refpath = FilePath from BidDocument where FilePath like '%" + company.ReferreIDPic + "%'; ";
            }

            if (company.BusinessLicensePic == "")
            {
                sql += " set @blpath=''; ";
            }
            else
            {
                sql += " select @blpath = FilePath from BidDocument where FilePath like '%" + company.BusinessLicensePic + "%'; ";
            }

            if (company.SecurityCertificatePic == "")
            {
                sql += " set @scpath=''; ";
            }
            else
            {
                sql += " select @scpath = FilePath from BidDocument where FilePath like '%" + company.SecurityCertificatePic + "%'; ";
            }

            if (company.RepIDPic == "")
            {
                sql += " set @ripath=''; ";
            }
            else
            {
                sql += " select @ripath = FilePath from BidDocument where FilePath like '%" + company.RepIDPic + "%'; ";
            }

            if (company.ContactIDPic == "")
            {
                sql += " set @cipath=''; ";
            }
            else
            {
                sql += " select @cipath = FilePath from BidDocument where FilePath like '%" + company.ContactIDPic + "%'; ";
            }

            sql += "update company set BusinessLicensePic=@blpath,ContactIDPic=@cipath,ReferreIDPic=@refpath, RepIDPic=@ripath, SecurityCertificatePic=@scpath where id=" + company.Id + "; ";

            if (company.ReferreIDPic != "")
            {
                sql += "update BidDocument set ProjId=" + company.Id + " where FilePath like '%" + company.ReferreIDPic + "%'; ";
            }
            if (company.BusinessLicensePic != "")
            {
                sql += "update BidDocument set ProjId=" + company.Id + " where FilePath like '%" + company.BusinessLicensePic + "%'; ";
            }
            if (company.SecurityCertificatePic != "")
            {
                sql += "update BidDocument set ProjId=" + company.Id + " where FilePath like '%" + company.SecurityCertificatePic + "%'; ";
            }
            if (company.RepIDPic != "")
            {
                sql += "update BidDocument set ProjId=" + company.Id + " where FilePath like '%" + company.RepIDPic + "%'; ";
            }
            if (company.ContactIDPic != "")
            {
                sql += "update BidDocument set ProjId=" + company.Id + " where FilePath like '%" + company.ContactIDPic + "%'; ";
            }
            DBHelper.ExecuteNonQuery(sql);
        }
コード例 #13
0
ファイル: Company.cs プロジェクト: haifuge/cr16gd
        public string CreateCompany(Company company, string uid)
        {
            string sql = "";

            sql += @"insert into Company(Name, CreditNo, RegisteredCapital, BusinessType, BusinessScope, QualificationLevel,  
                                               SecurityCertificateNo, CorporateRepresentative, RepPhone, 
                                               Contact, ContactPhone, ContactAddress, ConstructionContent, Note, 
                                               Status, Type, Referre,AuditDate, AuditStatus, SubmitUserId, CreateDate, OutCompanyProjId, AddYear)" +
                   "values(N'" + company.Name + "', N'" + company.CreditNo + "', " + company.RegisteredCapital + ", " +
                   "N'" + company.BusinessType + "', N'" + company.BusinessScope + "', N'" + company.QualificationLevel + "', " +
                   "'" + company.SecurityCertificateNo + "', N'" + company.CorporateRepresentive + "', '" + company.RepPhone + "', " +
                   "N'" + company.Contact + "', '" + company.ContactPhone + "', N'" + company.ContactAddress + "', " +
                   "N'" + company.ConstructionContent + "', N'" + company.Note + "', " + company.Status + ", " +
                   company.Type + ", N'" + company.Referrer + "', getdate(), " + company.AuditStatus + ", " + uid + @", getdate()," + company.OutCompanyProjId + ", " + company.AddYear + ");";
            sql += "select max(id) from Company;";
            string i = DBHelper.ExecuteScalar(CommandType.Text, sql);

            sql = @"declare @did int
                    select @did=ID from Department where ProjectDp=1 and ID in (
                        select PID from Department where ID in (select du.departmentid from DepartmentUser du where du.UserId=" + uid + @"))
                    update Company set DepartmentID = @did where ID=" + i;
            DBHelper.ExecuteNonQuery(sql);

            if (company.AuditStatus == 1)
            {
                DataTable dt = null;
                if (company.Type == 1)
                {
                    // 名录内企业
                    dt = CreateApproveProcess(i, uid, "5");
                }
                else
                {
                    // 名录外企业
                    dt = CreateApproveProcess(i, uid, "1");
                }
                string puser = DBHelper.ExecuteScalar("select UserName from userinfo where id=" + uid);
                try {
                    string reurl  = "";
                    string aptype = "";
                    switch (company.Type == 0 ? "1" : "5")
                    {
                    case "1":
                        aptype = "名录外企业审批";
                        reurl  = "http://cr16gd.saibo.net.cn/MobileCompany?id=" + i + "&approved=1&userid=";
                        break;

                    case "5":
                        aptype = "名录内企业审批";
                        reurl  = "http://cr16gd.saibo.net.cn/MobileCompany?id=" + i + "&approved=1&userid=";
                        break;
                    }
                    WXMessage.WXMessage message = new WXMessage.WXMessage();
                    for (int j = 0; j < dt.Rows.Count; j++)
                    {
                        uid = dt.Rows[j][1].ToString();
                        string guid = Guid.NewGuid().ToString().Replace("-", "");
                        reurl += uid + "&lcode=" + guid;
                        message.SendTempletMessge(dt.Rows[j][0].ToString(), reurl, aptype, company.Name, puser);
                        DBHelper.ExecuteNonQuery("insert into WXLoginSession(code, dtime, userid) values('" + guid + "',getdate()," + uid + ", 0)");
                    }
                }
                catch (Exception e)
                {
                    Log ll = new Log();
                    ll.OperType    = OperateType.SendWXInfo;
                    ll.UserId      = uid;
                    ll.Description = "发送短信失败:" + e.ToString();
                    LogContext.WriteLog(ll);
                }
                Log l = new Log();
                l.OperType    = OperateType.Create;
                l.UserId      = uid;
                l.Description = "创建公司" + company.Type == "1"?"名录内":"名录外" + " - " + company.Name;
                LogContext.WriteLog(l);
            }
            return(i);
        }
コード例 #14
0
 public void Company_With_Different_Id_Should_Be_Unequal_And_Have_Different_HashCode_Test()
 {
     Company comp1 = new Company { Id = 1 };
     Company comp2 = new Company { Id = 2 };
     Assert.AreNotEqual(comp1,comp2);
 }