public IQueryable<Organization> UpdateOrganization(Organization updatedOrganization, Organization currentOrganization)
{
if (updatedOrganization.Name != currentOrganization.Name)
{
currentOrganization.Name = updatedOrganization.Name;
}
if (updatedOrganization.Description != currentOrganization.Description)
{
currentOrganization.Description = updatedOrganization.Description;
}
if (updatedOrganization.Email != currentOrganization.Email)
{
currentOrganization.Email = updatedOrganization.Email;
}
if (updatedOrganization.ImageURL != currentOrganization.ImageURL)
{
currentOrganization.ImageURL = updatedOrganization.ImageURL;
}
this.organization.SaveChanges();
return this.organization
.All()
.Where(r => r.Id == updatedOrganization.Id);
}
public OrganizationViewModel(String name)
{
organization = new Organization(name);
_SelectedIndex = -1;
// Load the database
foreach (var person in organization.People)
{
var np = new PersonViewModel(person);
np.PropertyChanged += Person_OnNotifyPropertyChanged;
_People.Add(np);
}
}
public ActionResult ProcessNewOrganization(NewOrganizationViewModel newOrganization)
{
if (!this.ModelState.IsValid)
{
return View("RegisterNewOrganization", newOrganization);
}
// If execution gets here, we have valid details. The first thing we will do is to create the organisation.
// Let's build an organisation...
Organization newOrg = new Organization();
newOrg.Verified = false;
newOrg.OrganizationName = newOrganization.OrganizationName;
newOrg.Location = newOrganization.Address;
newOrg.Type = newOrganization.Type;
// TODO POint of contact?
// Get registering person to make them the organization admin
Person person = GetCurrentVolunteer();
if (person == null)
throw new ArgumentException("Logged-in person not found or is an administrator.");
// Now pass the new organization out through the Organisation service so it can be persisted in the database.
newOrg = OrganizationService.AddOrganization(newOrg, person.Id);
Task.Run(() =>
{
var routeValues = new RouteValueDictionary();
routeValues.Add("organizationId", newOrg.OrganizationId);
var organizationVerificationLink = Url.Action("VerifyOrganization", "Organization", routeValues,
Request.Url.Scheme);
var body =
string.Format(
@"<p>Click on the following link to verify the new organization : <a href='{0}'>{0}</a> </p>",
organizationVerificationLink);
var message = new Message("CrisisCheckin - Verify your organization", body);
MessageService.SendMessage(message, person, "CrisisCheckin");
});
// Send the verification email out to the user.
return View();
}
/// <summary>
/// 增加
/// </summary>
/// <param name="Organization">Organization实体对象</param>
/// <returns>int值,返回自增ID</returns>
public int addReturnId(Organization model)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@Organization_Name",model.Organization_Name),
new SqlParameter ("@Organization_User_Name",model.Organization_User_Name),
new SqlParameter ("@Organization_Tel",model.Organization_Tel),
new SqlParameter ("@Organization_Telphone",model.Organization_Telphone),
new SqlParameter ("@Organization_Fax",model.Organization_Fax),
new SqlParameter ("@Organization_Code",model.Organization_Code),
new SqlParameter ("@Organization_Address",model.Organization_Address),
new SqlParameter ("@Organization_PanelID",model.Organization_PanelID),
new SqlParameter ("@Organization_Order",model.Organization_Order),
new SqlParameter ("@Organization_CreatedTime",model.Organization_CreatedTime),
new SqlParameter ("@Organization_Remark",model.Organization_Remark),
new SqlParameter ("@Organization_Status",model.Organization_Status)
};
return Convert.ToInt32(Helper.ExecuteScalar ("Organization_AddReturnId",param));
}
/// <summary>
/// 增加
/// </summary>
/// <param name="Organization">Organization实体对象</param>
/// <returns>bool值,判断是否操作成功</returns>
public bool add(Organization model)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@Organization_Name",model.Organization_Name),
new SqlParameter ("@Organization_User_Name",model.Organization_User_Name),
new SqlParameter ("@Organization_Tel",model.Organization_Tel),
new SqlParameter ("@Organization_Telphone",model.Organization_Telphone),
new SqlParameter ("@Organization_Fax",model.Organization_Fax),
new SqlParameter ("@Organization_Code",model.Organization_Code),
new SqlParameter ("@Organization_Address",model.Organization_Address),
new SqlParameter ("@Organization_PanelID",model.Organization_PanelID),
new SqlParameter ("@Organization_Order",model.Organization_Order),
new SqlParameter ("@Organization_CreatedTime",model.Organization_CreatedTime),
new SqlParameter ("@Organization_Remark",model.Organization_Remark),
new SqlParameter ("@Organization_Status",model.Organization_Status)
};
return Helper.ExecuteNonQuery("Organization_Add",param);
}
public void Setup()
{
_principal = new Mock<IPrincipal>();
_httpContext = new Mock<HttpContextBase>();
_httpContext.Setup(x => x.User).Returns(_principal.Object);
_volunteerService = new Mock<IVolunteerService>();
_cluster = new Mock<ICluster>();
_webSecurity = new Mock<IWebSecurityWrapper>();
_webSecurity.SetupGet(x => x.CurrentUserId).Returns(42);
_messageService = new Mock<IMessageService>();
var request = new Mock<HttpRequestBase>();
request.SetupGet(x => x.Url).Returns(new Uri("http://localhost/"));
_httpContext.Setup(ctx => ctx.Request).Returns(request.Object);
_httpContext.SetupGet(x => x.Request).Returns(request.Object);
var response = new Mock<HttpResponseBase>();
response.Setup(x => x.ApplyAppPathModifier(It.IsAny<string>())).Returns<string>(x => x);
_httpContext.Setup(ctx => ctx.Response).Returns(response.Object);
_httpContext.SetupGet(x => x.Response).Returns(response.Object);
var reqContext = new RequestContext(_httpContext.Object, new RouteData());
var organization = new Organization()
{
OrganizationName = "Test",
OrganizationId = 1
};
var organizationList = new List<Organization>();
organizationList.Add(organization);
_organisationService = new Mock<IOrganizationService>();
_organisationService.Setup(x => x.GetActiveList()).Returns(organizationList);
_controllerUnderTest = new AccountController(_volunteerService.Object, _cluster.Object, _webSecurity.Object, _messageService.Object, _organisationService.Object);
_controllerUnderTest.ControllerContext = new ControllerContext(reqContext, _controllerUnderTest);
_routeCollection = new RouteCollection();
RouteConfig.RegisterRoutes(_routeCollection);
_controllerUnderTest.Url = new UrlHelper(reqContext, _routeCollection);
}
public void AddResourceCheckIn(Organization organization, Person person, int disasterId, string description, int qty, int resourceTypeId, DateTime startDate, DateTime endDate, string location)
{
if (DateTime.Compare(endDate, startDate) < 0)
{
throw new ArgumentException("Please enter an end date that is greater than or equal to the start date.");
}
if (DateTime.Compare(DateTime.Today, startDate) > 0)
{
throw new ArgumentException("Please enter a start date that is greater than or equal to today's date.");
}
_dataService.AddResourceAsync(new Resource
{
Allocator = organization,
Person = person,
DisasterId = disasterId,
Description = description,
Qty = qty,
ResourceTypeId = resourceTypeId,
StartOfAvailability = startDate,
EndOfAvailability = endDate,
Location = new Address { AddressLine1 = location }
});
}
public void SeedData(EmployerEmployeeHuntDbContext context)
{
var allUsers = context.Users.ToList();
for (int i = 0; i < allUsers.Count; i++)
{
if (i % 2 == 0)
{
continue;
}
var user = allUsers[i];
var organization = new Organization
{
Name = string.Format("Organization of {0}", user.UserName),
FoundedOn = DateTime.Now,
Founder = user
};
context.Organizations.Add(organization);
}
context.SaveChanges();
}
/// <summary>
/// 通过条件查询
/// </summary>
/// <param name="WhereString">查询条件</param>
/// <returns>Organization实体类对象</returns>
public List<Organization> selectByWhere(string WhereString)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@where",WhereString)
};
List<Organization> list = new List<Organization>();
Organization model = null;
using (SqlDataReader dr = Helper.ExecuteReader("Organization_SelectByWhere", param))
{
while (dr.Read())
{
model = new Organization();
model.Organization_ID = dr["Organization_ID"].ToString();
if (DBNull.Value!=dr["Organization_Name"])
model.Organization_Name = dr["Organization_Name"].ToString();
if (DBNull.Value!=dr["Organization_User_Name"])
model.Organization_User_Name = dr["Organization_User_Name"].ToString();
if (DBNull.Value!=dr["Organization_Tel"])
model.Organization_Tel = dr["Organization_Tel"].ToString();
if (DBNull.Value!=dr["Organization_Telphone"])
model.Organization_Telphone = dr["Organization_Telphone"].ToString();
if (DBNull.Value!=dr["Organization_Fax"])
model.Organization_Fax = dr["Organization_Fax"].ToString();
if (DBNull.Value!=dr["Organization_Code"])
model.Organization_Code = dr["Organization_Code"].ToString();
if (DBNull.Value!=dr["Organization_Address"])
model.Organization_Address = dr["Organization_Address"].ToString();
if (DBNull.Value!=dr["Organization_PanelID"])
model.Organization_PanelID = dr["Organization_PanelID"].ToString();
if (DBNull.Value!=dr["Organization_Order"])
model.Organization_Order = dr["Organization_Order"].ToString();
if (DBNull.Value!=dr["Organization_CreatedTime"])
model.Organization_CreatedTime = dr["Organization_CreatedTime"].ToString();
if (DBNull.Value!=dr["Organization_Remark"])
model.Organization_Remark = dr["Organization_Remark"].ToString();
if (DBNull.Value!=dr["Organization_Status"])
model.Organization_Status = dr["Organization_Status"].ToString();
list.Add(model);
}
}
return list;
}
/// <summary>
/// 通过Id查询
/// </summary>
/// <param name="Id">主键Id</param>
/// <returns>Organization实体类对象</returns>
public Organization selectById(int Id)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@Organization_ID",Id)
};
Organization model = new Organization();
using (SqlDataReader dr = Helper.ExecuteReader("Organization_SelectById", param))
{
if (dr.Read())
{
model.Organization_ID = dr["Organization_ID"].ToString();
if (DBNull.Value!=dr["Organization_Name"])
model.Organization_Name = dr["Organization_Name"].ToString();
if (DBNull.Value!=dr["Organization_User_Name"])
model.Organization_User_Name = dr["Organization_User_Name"].ToString();
if (DBNull.Value!=dr["Organization_Tel"])
model.Organization_Tel = dr["Organization_Tel"].ToString();
if (DBNull.Value!=dr["Organization_Telphone"])
model.Organization_Telphone = dr["Organization_Telphone"].ToString();
if (DBNull.Value!=dr["Organization_Fax"])
model.Organization_Fax = dr["Organization_Fax"].ToString();
if (DBNull.Value!=dr["Organization_Code"])
model.Organization_Code = dr["Organization_Code"].ToString();
if (DBNull.Value!=dr["Organization_Address"])
model.Organization_Address = dr["Organization_Address"].ToString();
if (DBNull.Value!=dr["Organization_PanelID"])
model.Organization_PanelID = dr["Organization_PanelID"].ToString();
if (DBNull.Value!=dr["Organization_Order"])
model.Organization_Order = dr["Organization_Order"].ToString();
if (DBNull.Value!=dr["Organization_CreatedTime"])
model.Organization_CreatedTime = dr["Organization_CreatedTime"].ToString();
if (DBNull.Value!=dr["Organization_Remark"])
model.Organization_Remark = dr["Organization_Remark"].ToString();
if (DBNull.Value!=dr["Organization_Status"])
model.Organization_Status = dr["Organization_Status"].ToString();
}
}
return model;
}
public Organization AddOrganization(Organization newOrganization, int registeringPersonId)
{
return _dataService.AddOrganization(newOrganization, registeringPersonId);
}
public Organization AddOrganization(Organization newOrganization, int registeringPersonId)
{
var person = context.Persons.Find(registeringPersonId);
if (person.OrganizationId.HasValue)
throw new InvalidOperationException("A person cannot belong to more than one organization.");
var result = context.Organizations.Add(newOrganization);
person.OrganizationId = result.OrganizationId;
person.IsOrganizationAdmin = true;
context.SaveChanges();
return result;
}
