public ActionResult Edit(PlaceModel place)
{
Logger.Debug("Inside Place Controller- Edit Http Post");
try
{
if (Session["OrganizationGUID"] != null)
{
if (ModelState.IsValid)
{
Place Place = new Place();
Place.PlaceGUID = new Guid(place.PlaceGUID);
Place.PlaceID = place.PlaceID;
Place.UserGUID = new Guid(place.UserGUID);
if (!string.IsNullOrEmpty(place.OrganizationGUID) && place.OrganizationGUID != Guid.Empty.ToString())
{
Place.OrganizationGUID = new Guid(place.OrganizationGUID);
}
else
{
Place.OrganizationGUID = null;
}
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.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();
int placeInsertResult = _IPlaceRepository.UpdatePlace(Place);
//int placeInsertResult = _IPlaceRepository.Save();
if (placeInsertResult > 0)
{
return RedirectToAction("Index");
}
else
{
return View(place);
}
}
return View(place);
}
else
{
return RedirectToAction("SessionTimeOut", "User");
}
}
catch (Exception ex)
{
Logger.Error(ex.Message);
return View(place);
}
}
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 MobilePlace ConvertPlaceforMobile(Place Place)
{
if (Place != null)
{
MobilePlace _place = new MobilePlace();
_place.PlaceGUID = Place.PlaceGUID;
_place.PlaceID = Place.PlaceID;
_place.UserGUID = Place.UserGUID;
_place.OrganizationGUID = Place.OrganizationGUID;
_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.TimeZone = Place.TimeZone;
_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 = Place.CategoryID;
_place.IsDeleted = Place.IsDeleted;
_place.ImageURL = Place.ImageURL;
_place.CreateDate = convertdate(Convert.ToDateTime(Place.CreateDate));// Place.CreateDate;
_place.UpdatedDate = convertdate(Convert.ToDateTime(Place.UpdatedDate));// Place.UpdatedDate;
return _place;
}
else
{
return null;
}
}
public int UpdatePlace(Place place)
{
//context.Entry(place).State = EntityState.Modified;
SqlParameter[] Param = new SqlParameter[23];
Param[0] = new SqlParameter("@pPlaceGUID", SqlDbType.UniqueIdentifier);
Param[0].Value = place.PlaceGUID;
Param[1] = new SqlParameter("@pPlaceID", SqlDbType.NVarChar, 50);
Param[1].Value = (object)place.PlaceID ?? DBNull.Value;
Param[2] = new SqlParameter("@pUserGUID", SqlDbType.UniqueIdentifier);
Param[2].Value = place.UserGUID;
Param[3] = new SqlParameter("@pOrganizationGUID", SqlDbType.UniqueIdentifier);
Param[3].Value = (object)place.OrganizationGUID ?? DBNull.Value;
Param[4] = new SqlParameter("@pPlaceName", SqlDbType.NVarChar, 50);
Param[4].Value = (object)place.PlaceName ?? DBNull.Value;
Param[5] = new SqlParameter("@pFirstName", SqlDbType.NVarChar, 50);
Param[5].Value = (object)place.FirstName ?? DBNull.Value;
Param[6] = new SqlParameter("@pLastName", SqlDbType.NVarChar, 50);
Param[6].Value = (object)place.LastName ?? DBNull.Value;
Param[7] = new SqlParameter("@pMobilePhone", SqlDbType.NVarChar, 20);
Param[7].Value = (object)place.MobilePhone ?? DBNull.Value;
Param[8] = new SqlParameter("@pPlacePhone", SqlDbType.NVarChar, 20);
Param[8].Value = (object)place.PlacePhone ?? DBNull.Value;
Param[9] = new SqlParameter("@pHomePhone", SqlDbType.NVarChar, 20);
Param[9].Value = (object)place.HomePhone ?? DBNull.Value;
Param[10] = new SqlParameter("@pEmails", SqlDbType.NVarChar, -1);
Param[10].Value = (object)place.Emails ?? DBNull.Value;
Param[11] = new SqlParameter("@pTimeZone", SqlDbType.NVarChar, 20);
Param[11].Value = (object)place.TimeZone ?? DBNull.Value;
Param[12] = new SqlParameter("@pAddressLine1", SqlDbType.NVarChar, 256);
Param[12].Value = (object)place.AddressLine1 ?? DBNull.Value;
Param[13] = new SqlParameter("@pAddressLine2", SqlDbType.NVarChar, 256);
Param[13].Value = (object)place.AddressLine2 ?? DBNull.Value;
Param[14] = new SqlParameter("@pCity", SqlDbType.NVarChar, 128);
Param[14].Value = (object)place.City ?? DBNull.Value;
Param[15] = new SqlParameter("@pState", SqlDbType.NVarChar, 128);
Param[15].Value = (object)place.State ?? DBNull.Value;
Param[16] = new SqlParameter("@pCountry", SqlDbType.NVarChar, 128);
Param[16].Value = (object)place.Country ?? DBNull.Value;
Param[17] = new SqlParameter("@pZipCode", SqlDbType.NVarChar, 20);
Param[17].Value = (object)place.ZipCode ?? DBNull.Value;
Param[18] = new SqlParameter("@pCategoryID", SqlDbType.Int);
Param[18].Value = (object)place.CategoryID ?? DBNull.Value;
Param[19] = new SqlParameter("@pIsDeleted", SqlDbType.Bit);
Param[19].Value = (object)place.IsDeleted ?? DBNull.Value;
Param[20] = new SqlParameter("@pImageURL", SqlDbType.NVarChar, -1);
Param[20].Value = (object)place.ImageURL ?? DBNull.Value;
Param[21] = new SqlParameter("@pCreateDate", SqlDbType.DateTime);
Param[21].Value = (object)place.CreateDate ?? DBNull.Value;
Param[22] = new SqlParameter("@pUpdatedDate", SqlDbType.DateTime);
Param[22].Value = (object)place.UpdatedDate ?? DBNull.Value;
return context.Database.ExecuteSqlCommand("update Places set PlaceID=@pPlaceID,UserGUID=@pUserGUID,OrganizationGUID=@pOrganizationGUID,"
+ "PlaceName=@pPlaceName,FirstName=@pFirstName,LastName=@pLastName,MobilePhone=@pMobilePhone,"
+ "PlacePhone=@pPlacePhone,HomePhone=@pHomePhone,Emails=@pEmails,TimeZone=@pTimeZone,"
+ "AddressLine1=@pAddressLine1,AddressLine2=@pAddressLine2,City=@pCity,State=@pState,Country=@pCountry,ZipCode=@pZipCode,"
+ "CategoryID=@pCategoryID,IsDeleted=@pIsDeleted,ImageURL=@pImageURL,CreateDate=@pCreateDate,UpdatedDate=@pUpdatedDate where PlaceGUID=@pPlaceGUID", Param);
}
public ActionResult EditCustomer(customerview pcustomerview)
{
Logger.Debug("Inside Place Controller- Edit Http Post");
try
{
if (Session["OrganizationGUID"] != null)
{
if (ModelState.IsValid)
{
if (pcustomerview.PlaceModel != null)
{
Place Place = new Place();
Place.PlaceGUID = new Guid(pcustomerview.PlaceModel.PlaceGUID);
Place.UserGUID = new Guid(pcustomerview.PlaceModel.UserGUID);
Place.PlaceID = pcustomerview.PlaceModel.PlaceID;
Place.OrganizationGUID = !string.IsNullOrEmpty(pcustomerview.PlaceModel.OrganizationGUID) ? new Guid(pcustomerview.PlaceModel.OrganizationGUID) : Guid.Empty;
Place.PlaceName = pcustomerview.PlaceModel.PlaceName;
Place.FirstName = pcustomerview.PlaceModel.FirstName;
Place.LastName = pcustomerview.PlaceModel.LastName;
Place.MobilePhone = pcustomerview.PlaceModel.MobilePhone;
Place.PlacePhone = pcustomerview.PlaceModel.PlacePhone;
Place.HomePhone = pcustomerview.PlaceModel.HomePhone;
Place.Emails = pcustomerview.PlaceModel.Emails;
Place.AddressLine1 = pcustomerview.PlaceModel.AddressLine1;
Place.AddressLine2 = pcustomerview.PlaceModel.AddressLine2;
Place.City = pcustomerview.PlaceModel.City;
Place.State = pcustomerview.PlaceModel.State;
Place.Country = pcustomerview.PlaceModel.Country;
Place.ZipCode = pcustomerview.PlaceModel.ZipCode;
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();
int placeInsertResult = _IPlaceRepository.UpdatePlace(Place);
// int placeInsertResult = _IPlaceRepository.Save();
if (placeInsertResult > 0)
{
//return RedirectToAction("Index", "CustomerView", new { id = "Details", customerid = Place.PlaceGUID.ToString() });
return RedirectToAction("Index", "Place");
}
else
{
TempData["TabName"] = "Details";
pcustomerview.PeopleViewModel = ContactDetails(pcustomerview.PlaceModel.PlaceGUID);
pcustomerview.MarketViewModel = CustomerStopDetails(pcustomerview.PlaceModel.PlaceGUID);
}
}
}
else
{
TempData["TabName"] = "Details";
pcustomerview.PeopleViewModel = ContactDetails(pcustomerview.PlaceModel.PlaceGUID);
pcustomerview.MarketViewModel = CustomerStopDetails(pcustomerview.PlaceModel.PlaceGUID);
}
return View("Index", pcustomerview);
}
else
{
return RedirectToAction("SessionTimeOut", "User");
}
}
catch (Exception ex)
{
Logger.Error(ex.Message);
return View(pcustomerview);
}
}