public ActionResult Create(PlaceModel place)
{
Logger.Debug("Inside Place Controller- Create Http Post");
try
{
if (Session["OrganizationGUID"] != null)
{
if (ModelState.IsValid)
{
Place _place = _IPlaceRepository.GetPlaceByID(place.PlaceID, new Guid(Session["OrganizationGUID"].ToString()));
if (_place == null)
{
Place Place = new Place();
Place.PlaceGUID = Guid.NewGuid();
Place.UserGUID = new Guid(Session["UserGUID"].ToString());
Place.OrganizationGUID = new Guid(Session["OrganizationGUID"].ToString());
Place.PlaceID = place.PlaceID;
Place.PlaceName = place.PlaceName;
Place.FirstName = place.FirstName;
Place.LastName = place.LastName;
Place.MobilePhone = place.MobilePhone;
Place.PlacePhone = place.PlacePhone;
Place.HomePhone = place.HomePhone;
Place.Emails = place.Emails;
Place.AddressLine1 = place.AddressLine1;
Place.AddressLine2 = place.AddressLine2;
Place.City = place.City;
Place.State = place.State;
Place.Country = place.Country;
Place.ZipCode = place.ZipCode;
Place.CategoryID = 0;
Place.IsDeleted = false;
Place.CreateDate = DateTime.UtcNow;
Place.UpdatedDate = DateTime.UtcNow;
LatLong latLong = new LatLong();
latLong = GetLatLngCode(Place.AddressLine1, Place.AddressLine2, Place.City, Place.State, Place.Country, Place.ZipCode);
Place.TimeZone = getTimeZone(latLong.Latitude, latLong.Longitude).ToString();
Person People = new Person();
People.PeopleGUID = Guid.NewGuid();
People.UserGUID = Place.UserGUID;
People.OrganizationGUID = Place.OrganizationGUID;
People.IsPrimaryContact = true;
People.PlaceGUID = Place.PlaceGUID;
People.FirstName = place.FirstName;
People.LastName = place.LastName;
People.MobilePhone = place.MobilePhone;
People.CompanyName = place.PlaceName;
People.BusinessPhone = place.PlacePhone;
People.HomePhone = place.HomePhone;
People.Emails = place.Emails;
People.AddressLine1 = place.AddressLine1;
People.AddressLine2 = place.AddressLine2;
People.City = place.City;
People.State = place.State;
People.Country = place.Country;
People.ZipCode = place.ZipCode;
People.CategoryID = 0;
People.IsDeleted = false;
People.CreatedDate = DateTime.UtcNow;
People.UpdatedDate = DateTime.UtcNow;
//Market Market = new Market();
//Market.MarketGUID = Guid.NewGuid();
//Market.IsDefault = true;
//Market.UserGUID = Place.UserGUID;
//Market.EntityType = 1;
//Market.OrganizationGUID = Place.OrganizationGUID;
//Market.OwnerGUID = Place.PlaceGUID;
//Market.MarketName = Place.PlaceName;
//Market.PrimaryContactGUID = People.PeopleGUID;
//Market.FirstName = place.FirstName;
//Market.LastName = place.LastName;
//Market.MobilePhone = place.MobilePhone;
//Market.MarketPhone = place.PlacePhone;
//Market.HomePhone = place.HomePhone;
//Market.Emails = place.Emails;
//Market.AddressLine1 = place.AddressLine1;
//Market.AddressLine2 = place.AddressLine2;
//Market.City = place.City;
//Market.State = place.State;
//Market.Country = place.Country;
//Market.ZipCode = place.ZipCode;
//Market.IsDeleted = false;
//Market.CreateDate = DateTime.UtcNow;
//Market.UpdatedDate = DateTime.UtcNow;
int placeInsertResult = _IPlaceRepository.InsertPlace(Place);
//int placeInsertResult = _IPlaceRepository.Save();
if (placeInsertResult > 0)
{
int peopleInsertResult = _IPeopleRepository.InsertPeople(People);
// int peopleInsertResult = _IPeopleRepository.Save();
if (peopleInsertResult > 0)
{
//_IMarketRepository.InsertMarket(Market);
//int marketInsertResult = _IMarketRepository.Save();
//if (marketInsertResult > 0)
//{
return RedirectToAction("Index");
//}
//else
//{
// _IMarketRepository.DeleteMarket(Market.MarketGUID);
// _IMarketRepository.Save();
// _IPeopleRepository.DeletePeople(People.PeopleGUID);
// _IPeopleRepository.Save();
// _IPlaceRepository.DeletePlace(Place.PlaceGUID);
// _IPlaceRepository.Save();
//}
}
else
{
_IPeopleRepository.DeletePeople(People.PeopleGUID);
// _IPeopleRepository.Save();
_IPlaceRepository.DeletePlace(Place.PlaceGUID);
//_IPlaceRepository.Save();
}
}
else
{
_IPlaceRepository.DeletePlace(Place.PlaceGUID);
// _IPlaceRepository.Save();
}
}
else
{
TempData["msg"] = "<script>ModalPopupsAlert('Workers-In-Motion','Client ID already configured');</script>";
return View(place);
}
}
else
{
return View(place);
}
return View();
}
else
{
return RedirectToAction("SessionTimeOut", "User");
}
}
catch (Exception ex)
{
Logger.Error(ex.Message);
return View(place);
}
}
public ActionResult Contact(PeopleViewForCreate peoplecreate)
{
Logger.Debug("Inside Place Controller- Create Http Post");
try
{
if (Session["OrganizationGUID"] != null)
{
if (ModelState.IsValid)
{
PeopleModel people = new PeopleModel();
people = peoplecreate.PeopleModel;
Person People = new Person();
People.PeopleGUID = Guid.NewGuid();
People.UserGUID = new Guid(people.UserGUID.ToString());
if (!string.IsNullOrEmpty(people.OrganizationGUID.ToString()) && people.OrganizationGUID != Guid.Empty.ToString())
{
People.OrganizationGUID = new Guid(people.OrganizationGUID.ToString());
}
else
{
People.OrganizationGUID = null;
}
People.IsPrimaryContact = true;
if (!string.IsNullOrEmpty(people.PlaceGUID.ToString()) && people.PlaceGUID != Guid.Empty.ToString())
{
People.PlaceGUID = new Guid(people.PlaceGUID.ToString());
}
else
{
People.PlaceGUID = null;
}
People.FirstName = people.FirstName;
People.LastName = people.LastName;
People.MobilePhone = people.MobilePhone;
People.CompanyName = people.CompanyName;
People.BusinessPhone = people.BusinessPhone;
People.HomePhone = people.HomePhone;
People.Emails = people.Emails;
People.AddressLine1 = people.AddressLine1;
People.AddressLine2 = people.AddressLine2;
People.City = people.City;
People.State = people.State;
People.Country = people.Country;
People.ZipCode = people.ZipCode;
People.CategoryID = 0;
People.IsDeleted = false;
People.CreatedDate = DateTime.UtcNow;
People.UpdatedDate = DateTime.UtcNow;
int peopleInsertResult = _IPeopleRepository.InsertPeople(People);
//int peopleInsertResult = _IPeopleRepository.Save();
if (peopleInsertResult > 0)
{
ContactValues contactValues = new ContactValues();
contactValues.UserGUID = People.UserGUID;
contactValues.OrganizationGUID = People.OrganizationGUID != null ? new Guid(People.OrganizationGUID.ToString()) : Guid.Empty;
contactValues.OwnerGUID = People.PlaceGUID != null ? new Guid(People.PlaceGUID.ToString()) : Guid.Empty;
contactValues.PrimaryContactGUID = People.PeopleGUID;
contactValues.ContactName = People.FirstName;
TempData["ContactDetails"] = contactValues;
return RedirectToAction("Create");
}
else
{
return View(peoplecreate);
}
}
else
{
var userList = new AspNetUserViewModel();
userList.Users = new List<AspUser>();
var appUser = _IUserProfileRepository.GetUserProfilesbyOrganizationGUID(new Guid(Session["OrganizationGUID"].ToString())).OrderBy(sort => sort.FirstName).ToList();
//if (string.IsNullOrEmpty(id))
{
userList.Users.Add(new AspUser { FirstName = "All", LastName = "", UserGUID = Guid.Empty.ToString(), OrganizationGUID = "" });
foreach (var user in appUser.ToList())
{
userList.Users.Add(new AspUser { FirstName = user.FirstName, LastName = user.LastName, UserGUID = user.UserGUID.ToString() });
}
}
var placeList = new PlaceViewModel();
placeList.PlaceList = new List<PlaceModel>();
var appPlace = new List<Place>();
appPlace = _IPlaceRepository.GetPlaceByOrganizationGUID(new Guid(Session["OrganizationGUID"].ToString())).ToList();
foreach (var place in appPlace.ToList())
{
placeList.PlaceList.Add(new PlaceModel
{
PlaceGUID = place.PlaceGUID.ToString(),
PlaceID = place.PlaceID,
PlaceName = place.PlaceName,
PlacePhone = place.PlacePhone,
FirstName = place.FirstName,
LastName = place.LastName,
UserGUID = place.UserGUID.ToString(),
OrganizationGUID = place.OrganizationGUID != null ? place.OrganizationGUID.ToString() : Guid.Empty.ToString(),
MobilePhone = place.MobilePhone,
HomePhone = place.HomePhone,
Emails = place.Emails,
TimeZone = place.TimeZone,
AddressLine1 = place.AddressLine1,
AddressLine2 = place.AddressLine2,
City = place.City,
State = place.State,
Country = place.Country,
ZipCode = place.ZipCode
});
}
var placeviewModel = new PlaceViewModel();
placeviewModel.Place = placeList.PlaceList.AsEnumerable();
placeviewModel.User = userList.Users.AsEnumerable();
var PeopleViewForCreate = new PeopleViewForCreate();
PeopleViewForCreate.PlaceViewModel = placeviewModel;
return View(PeopleViewForCreate);
}
}
else
{
return RedirectToAction("SessionTimeOut", "User");
}
}
catch (Exception ex)
{
Logger.Error(ex.Message);
return View(peoplecreate);
}
}
public MobilePeople ConvertPeopleForMobile(Person Person)
{
if (Person != null)
{
MobilePeople _person = new MobilePeople();
_person.PeopleGUID = Person.PeopleGUID;
_person.RecordStatus = Person.RecordStatus;
_person.UserGUID = Person.UserGUID;
_person.OrganizationGUID = Person.OrganizationGUID;
_person.IsPrimaryContact = Person.IsPrimaryContact;
_person.PlaceGUID = Person.PlaceGUID;
_person.MarketGUID = Person.MarketGUID;
_person.FirstName = Person.FirstName;
_person.LastName = Person.LastName;
_person.CompanyName = Person.CompanyName;
_person.MobilePhone = Person.MobilePhone;
_person.BusinessPhone = Person.BusinessPhone;
_person.HomePhone = Person.HomePhone;
_person.Emails = Person.Emails;
_person.AddressLine1 = Person.AddressLine1;
_person.AddressLine2 = Person.AddressLine2;
_person.City = Person.City;
_person.State = Person.State;
_person.Country = Person.Country;
_person.ZipCode = Person.ZipCode;
_person.CategoryID = Person.CategoryID;
_person.IsDeleted = Person.IsDeleted;
_person.ImageURL = Person.ImageURL;
_person.CreatedDate = convertdate(Convert.ToDateTime(Person.CreatedDate));// Person.CreatedDate;
_person.UpdatedDate = convertdate(Convert.ToDateTime(Person.UpdatedDate));// Person.UpdatedDate;
return _person;
}
else
{
return null;
}
}
public int InsertPeople(Person Person)
{
// context.People.Add(Person);
SqlParameter[] Param = new SqlParameter[25];
Param[0] = new SqlParameter("@pPeopleGUID", SqlDbType.UniqueIdentifier);
Param[0].Value = Person.PeopleGUID;
Param[1] = new SqlParameter("@pRecordStatus", SqlDbType.Int);
Param[1].Value = (object)Person.RecordStatus ?? DBNull.Value;
Param[2] = new SqlParameter("@pUserGUID", SqlDbType.UniqueIdentifier);
Param[2].Value = Person.UserGUID;
Param[3] = new SqlParameter("@pOrganizationGUID", SqlDbType.UniqueIdentifier);
Param[3].Value = (object)Person.OrganizationGUID ?? DBNull.Value;
Param[4] = new SqlParameter("@pIsPrimaryContact", SqlDbType.Bit);
Param[4].Value = (object)Person.IsPrimaryContact ?? DBNull.Value;
Param[5] = new SqlParameter("@pPlaceGUID", SqlDbType.UniqueIdentifier);
Param[5].Value = (object)Person.PlaceGUID ?? DBNull.Value;
Param[6] = new SqlParameter("@pMarketGUID", SqlDbType.UniqueIdentifier);
Param[6].Value = (object)Person.MarketGUID ?? DBNull.Value;
Param[7] = new SqlParameter("@pFirstName", SqlDbType.NVarChar, 50);
Param[7].Value = (object)Person.FirstName ?? DBNull.Value;
Param[8] = new SqlParameter("@pLastName", SqlDbType.NVarChar, 50);
Param[8].Value = (object)Person.LastName ?? DBNull.Value;
Param[9] = new SqlParameter("@pCompanyName", SqlDbType.NVarChar, 50);
Param[9].Value = (object)Person.CompanyName ?? DBNull.Value;
Param[10] = new SqlParameter("@pMobilePhone", SqlDbType.NVarChar, 20);
Param[10].Value = (object)Person.MobilePhone ?? DBNull.Value;
Param[11] = new SqlParameter("@pBusinessPhone", SqlDbType.NVarChar, 20);
Param[11].Value = (object)Person.BusinessPhone ?? DBNull.Value;
Param[12] = new SqlParameter("@pHomePhone", SqlDbType.NVarChar, 20);
Param[12].Value = (object)Person.HomePhone ?? DBNull.Value;
Param[13] = new SqlParameter("@pEmails", SqlDbType.NVarChar, -1);
Param[13].Value = (object)Person.Emails ?? DBNull.Value;
Param[14] = new SqlParameter("@pAddressLine1", SqlDbType.NVarChar, 256);
Param[14].Value = (object)Person.AddressLine1 ?? DBNull.Value;
Param[15] = new SqlParameter("@pAddressLine2", SqlDbType.NVarChar, 256);
Param[15].Value = (object)Person.AddressLine2 ?? DBNull.Value;
Param[16] = new SqlParameter("@pCity", SqlDbType.NVarChar, 128);
Param[16].Value = (object)Person.City ?? DBNull.Value;
Param[17] = new SqlParameter("@pState", SqlDbType.NVarChar, 128);
Param[17].Value = (object)Person.State ?? DBNull.Value;
Param[18] = new SqlParameter("@pCountry", SqlDbType.NVarChar, 128);
Param[18].Value = (object)Person.Country ?? DBNull.Value;
Param[19] = new SqlParameter("@pZipCode", SqlDbType.NVarChar, 20);
Param[19].Value = (object)Person.ZipCode ?? DBNull.Value;
Param[20] = new SqlParameter("@pCategoryID", SqlDbType.Int);
Param[20].Value = (object)Person.CategoryID ?? DBNull.Value;
Param[21] = new SqlParameter("@pIsDeleted", SqlDbType.Bit);
Param[21].Value = (object)Person.IsDeleted ?? DBNull.Value;
Param[22] = new SqlParameter("@pImageURL", SqlDbType.NVarChar, -1);
Param[22].Value = (object)Person.ImageURL ?? DBNull.Value;
Param[23] = new SqlParameter("@pCreatedDate", SqlDbType.DateTime);
Param[23].Value = (object)Person.CreatedDate ?? DBNull.Value;
Param[24] = new SqlParameter("@pUpdatedDate", SqlDbType.DateTime);
Param[24].Value = (object)Person.UpdatedDate ?? DBNull.Value;
return context.Database.ExecuteSqlCommand("insert into People(PeopleGUID,RecordStatus,UserGUID,OrganizationGUID,IsPrimaryContact,PlaceGUID,MarketGUID,FirstName,LastName,CompanyName,"
+ "MobilePhone,BusinessPhone,HomePhone,Emails,AddressLine1,AddressLine2,City,State,Country,ZipCode,CategoryID,IsDeleted,ImageURL,CreatedDate,UpdatedDate)values"
+ "(@pPeopleGUID,@pRecordStatus,@pUserGUID,@pOrganizationGUID,@pIsPrimaryContact,@pPlaceGUID,@pMarketGUID,@pFirstName,@pLastName,@pCompanyName,"
+ "@pMobilePhone,@pBusinessPhone,@pHomePhone,@pEmails,@pAddressLine1,@pAddressLine2,@pCity,@pState,@pCountry,@pZipCode,@pCategoryID,@pIsDeleted,@pImageURL,@pCreatedDate,@pUpdatedDate)", Param);
}