// Business Update
/// <summary>
///
/// </summary>
/// <param name="BusinessObject"></param>
/// <returns></returns>
public string UpdateLocationProfile(BusinessObject BusinessObject)
{
tblBusiness business = bringlyEntities.tblBusinesses
.Where(x => x.BusinessGuid == BusinessObject.BusinessGuid)
.FirstOrDefault();
business.BusinessName = BusinessObject.BusinessName;
business.CityGuid = BusinessObject.CityGuid;
business.PNumber = BusinessObject.PNumber;
business.Phone = BusinessObject.Phone;
business.PinCode = BusinessObject.PinCode;
business.ModifiedBy = UserVariables.LoggedInUserGuid;
business.ModifiedDate = DateTime.Now;
business.Address = BusinessObject.Address;
business.Email = BusinessObject.Email;
business.OrderTiming = BusinessObject.OrderTiming;
business.PickUpTiming = BusinessObject.PickUpTiming;
business.ServiceCharge = BusinessObject.ServiceCharge;
business.ServiceTax = BusinessObject.ServiceTax;
business.FlatRate = BusinessObject.FlatRate;
business.RateAfterKm = BusinessObject.RateAfterKm;
business.Description = BusinessObject.Description;
bringlyEntities.SaveChanges();
string cityname = bringlyEntities.tblCities.Where(x => x.CityGuid == BusinessObject.CityGuid).FirstOrDefault().CityName;
return(cityname);
}
// POST: api/business
public IHttpActionResult Post([FromBody] BusinessViewModel model)
{
try
{
if (model != null)
{
var business = new tblBusiness()
{
Name = model.Name,
ShortName = model.ShortName,
IsInternational = model.IsInternational,
FaxNumbers = model.FaxNumbers,
PhoneNumbers = model.PhoneNumbers,
Logo = model.Logo,
Add1 = model.Add1,
Add2 = model.Add2,
City = model.City,
State = model.State,
CountryId = model.CountryId,
Email = model.Email,
Website = model.Website,
Created = DateTime.Now.ToUniversalTime(),
IsActive = model.IsActive,
Zip = model.Zip,
MembershipId = model.MembershipId,
BusinessCategoryId = model.BusinessCategoryId,
TimezoneId = model.TimezoneId
};
_db.tblBusinesses.Add(business);
var response = _db.SaveChanges();
if (response > 0)
{
return(Ok(new { status = true, data = business }));
}
else
{
return(Ok(new { status = false, data = "There was a problem." }));
}
}
else
{
return(Ok(new { status = false, data = "There was a problem." }));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message.ToString()));
}
}
public ActionResult AdminRegInfo(tblBusiness collection)
{
try
{
//Registrar información del formulario
SqlParameter param1 = new SqlParameter("@name", collection.bsName);
SqlParameter param2 = new SqlParameter("@ubicacion", collection.bsLocation);
SqlParameter param3 = new SqlParameter("@email", collection.bsEmail);
SqlParameter param4 = new SqlParameter("@rama", collection.bsBranch);
SqlParameter param5 = new SqlParameter("@telefono", collection.bsPhone);
var db = new DBPawnshopEntitiesConection();
var data = db.Database.ExecuteSqlCommand("setInfoBs @name, @ubicacion, @email, @rama,@telefono", param1, param2, param3, param4, param5);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
catch (Exception e)
{
return(View(e.Message));
}
}
public ActionResult AdminEditInfo2(tblBusiness collection)
{
try
{
//Edición de datos de la información
string idBuss = System.Web.HttpContext.Current.Session["idBus"].ToString();
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idBuss);
SqlParameter param2 = new SqlParameter("@name", collection.bsName);
SqlParameter param3 = new SqlParameter("@ubicacion", collection.bsLocation);
SqlParameter param4 = new SqlParameter("@email", collection.bsEmail);
SqlParameter param5 = new SqlParameter("@rama", collection.bsBranch);
SqlParameter param6 = new SqlParameter("@telefono", collection.bsPhone);
var data = db.Database.ExecuteSqlCommand("updateInfoData @id, @name,@ubicacion,@email,@rama,@telefono", param1, param2, param3, param4, param5, param6);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
catch (Exception e)
{
return(View(e.Message));
}
}
// Add Location
/// <summary>
///
/// </summary>
/// <param name="BusinessObject"></param>
/// <returns></returns>
public Guid AddLocation(BusinessObject BusinessObject)
{
tblBusiness business = bringlyEntities.tblBusinesses
.Where(x => x.FK_CreatedByGuid == UserVariables.LoggedInUserGuid)
.FirstOrDefault();
tblBranch tblBranch = new tblBranch();
tblBranch.BranchGuid = Guid.NewGuid();
tblBranch.FK_BusinessTypeGuid = business.FK_BusinessTypeGuid;
tblBranch.BranchName = BusinessObject.BusinessName;
tblBranch.FK_CityGuid = BusinessObject.CityGuid;
tblBranch.PNumber = BusinessObject.PNumber;
tblBranch.Phone = BusinessObject.Phone;
tblBranch.PinCode = BusinessObject.PinCode;
tblBranch.FK_CreatedByGuid = UserVariables.LoggedInUserGuid;
tblBranch.DateCreated = DateTime.Now;
tblBranch.Address = BusinessObject.Address;
tblBranch.Email = BusinessObject.Email;
tblBranch.ManagerUserGuid = (BusinessObject.ManagerGuid == null || (!BusinessObject.ManagerGuid.HasValue || BusinessObject.ManagerGuid.Value == Guid.Empty)) ? UserVariables.LoggedInUserGuid : BusinessObject.ManagerGuid.Value;
tblBranch.OrderTiming = BusinessObject.OrderTiming;
tblBranch.PickUpTiming = BusinessObject.PickUpTiming;
tblBranch.ServiceCharge = BusinessObject.ServiceCharge;
tblBranch.ServiceTax = BusinessObject.ServiceTax;
tblBranch.FlatRate = BusinessObject.FlatRate;
tblBranch.RateAfterKm = BusinessObject.RateAfterKm;
tblBranch.Description = BusinessObject.Description;
tblBranch.IsDeleted = false;
tblBranch.Latitude = BusinessObject.Latitude;
tblBranch.Longitude = BusinessObject.Longitude;
tblBranch.PlaceId = BusinessObject.PlaceId;
tblBranch.Country = BusinessObject.CountryName;
bringlyEntities.tblBranches.Add(tblBranch);
bringlyEntities.SaveChanges();
return(tblBranch.BranchGuid);
}
public ResponseViewModel <RegisterViewModel> Register(RegisterViewModel model)
{
var data = new ResponseViewModel <RegisterViewModel>();
var hasName = _db.tblBusinesses.Any(d => d.Name.ToLower() == model.Business.Name.ToLower());
var hasEmail = _db.tblBusinessEmployees.Any(d => d.Email.ToLower() == model.Business.Email.ToLower());
if (hasName)
{
data.Status = false;
data.Message = "This business name has been taken. Please try another name.";
}
else if (hasEmail)
{
data.Status = false;
data.Message = "This business email has been taken. Please try another email id.";
}
else
{
using (var dbTran = _db.Database.BeginTransaction())
{
try
{
var business = new tblBusiness()
{
Name = model.Business.Name,
ShortName = model.Business.ShortName,
IsInternational = model.Business.IsInternational,
FaxNumbers = model.Business.FaxNumbers,
PhoneNumbers = model.Business.PhoneNumbers,
Logo = model.Business.Logo,
Add1 = model.Business.Add1,
Add2 = model.Business.Add2,
City = model.Business.City,
State = model.Business.State,
CountryId = model.Business.CountryId,
Email = model.Business.Email,
Website = model.Business.Website,
Created = DateTime.Now.ToUniversalTime(),
IsActive = model.Business.IsActive,
Zip = model.Business.Zip,
MembershipId = model.Business.MembershipId,
BusinessCategoryId = model.Business.BusinessCategoryId,
TimezoneId = model.Business.TimezoneId
};
_db.tblBusinesses.Add(business);
var responseBusiness = _db.SaveChanges();
var serviceLocation = new tblServiceLocation()
{
Name = "Main Address",
Add1 = model.Business.Add1,
Add2 = model.Business.Add2,
City = model.Business.City,
State = model.Business.State,
CountryId = model.Business.CountryId.Value,
Created = DateTime.Now.ToUniversalTime(),
IsActive = model.Business.IsActive,
Zip = model.Business.Zip,
BusinessId = business.Id,
TimezoneId = business.TimezoneId,
Description = ""
};
_db.tblServiceLocations.Add(serviceLocation);
var responseServiceLocation = _db.SaveChanges();
//Setup default business hours
//var businessHourController = new BusinessHourController();
//var responseBusinessHour = businessHourController.SetupBusinessHours(serviceLocation.Id);
var today = DateTime.Now;
var date = new DateTime(today.Year, today.Month, today.Day, 8, 00, 00, DateTimeKind.Utc);
for (int i = 0; i < 7; i++)
{
var businessHour = new tblBusinessHour()
{
WeekDayId = i,
IsStartDay = i == 0 ? true : false,
IsHoliday = false,
From = date,
To = date.AddHours(10),
IsSplit1 = false,
FromSplit1 = null,
ToSplit1 = null,
IsSplit2 = false,
FromSplit2 = null,
ToSplit2 = null,
ServiceLocationId = serviceLocation.Id
};
_db.tblBusinessHours.Add(businessHour);
}
var responseBusinessHour = _db.SaveChanges();
//End
var businessEmployee = new tblBusinessEmployee()
{
FirstName = model.Employee.FirstName,
LastName = model.Employee.LastName,
Password = Security.Encrypt(model.Employee.Password, true),
Email = model.Employee.Email,
STD = model.Employee.STD,
PhoneNumber = model.Employee.PhoneNumber,
ServiceLocationId = serviceLocation.Id,
IsAdmin = true,
Created = DateTime.Now.ToUniversalTime(),
IsActive = true
};
_db.tblBusinessEmployees.Add(businessEmployee);
var responseBusinessEmployee = _db.SaveChanges();
var businessViewModel = new BusinessViewModel()
{
Add1 = business.Add1,
Add2 = business.Add2,
BusinessCategoryId = business.BusinessCategoryId,
City = business.City,
CountryId = business.CountryId,
Created = business.Created,
Email = business.Email,
FaxNumbers = business.FaxNumbers,
Id = business.Id,
IsActive = business.IsActive,
IsInternational = business.IsInternational,
Logo = business.Logo,
MembershipId = business.MembershipId,
Name = business.Name,
PhoneNumbers = business.PhoneNumbers,
ShortName = business.ShortName,
State = business.State,
TimezoneId = business.TimezoneId,
Website = business.Website,
Zip = business.Zip
};
var businessEmployeeViewModel = new BusinessEmployeeViewModel()
{
Created = businessEmployee.Created,
Email = businessEmployee.Email,
FirstName = businessEmployee.FirstName,
Id = businessEmployee.Id,
IsActive = businessEmployee.IsActive,
IsAdmin = businessEmployee.IsAdmin,
LastName = businessEmployee.LastName,
PhoneNumber = businessEmployee.PhoneNumber,
ServiceLocationId = businessEmployee.ServiceLocationId,
STD = businessEmployee.STD
};
if (responseBusiness > 0 && responseServiceLocation > 0 && responseBusinessEmployee > 0 && responseBusinessHour > 0)
{
data.Status = true;
data.Message = "Transaction successed.";
data.Data = new RegisterViewModel();
data.Data.Business = new BusinessViewModel();
data.Data.Employee = new BusinessEmployeeViewModel();
data.Data.Business = businessViewModel;
data.Data.Employee = businessEmployeeViewModel;
dbTran.Commit();
}
else
{
data.Status = false;
var reason = "";
if (responseBusiness <= 0)
{
reason += "Business setup issue. ";
}
if (responseServiceLocation <= 0)
{
reason += " Service location issue.";
}
if (responseBusinessEmployee <= 0)
{
reason += " Business employee issue.";
}
if (responseBusinessHour <= 0)
{
reason += " Business hour issue.";
}
data.Message = "Registration failed. reason: " + reason;
data.Data.Business = new BusinessViewModel();
data.Data.Employee = new BusinessEmployeeViewModel();
dbTran.Rollback();
}
}
catch (Exception ex)
{
data.Status = false;
data.Message = "Registration failed. ex: " + ex.Message.ToString();
data.Data.Business = new BusinessViewModel();
data.Data.Employee = new BusinessEmployeeViewModel();
dbTran.Rollback();
}
}
}
return(data);
}
