public async Task <IActionResult> PriceEdit(int _SeasonId, [Bind("TypeLine,GroupLevelNAME,GroupLevelItemNAME,GroupLevelItemID,SeasonNAME,SeasonID,SeasonItemID,SeasonItemTAX")] Class_SeasonREL _SeasonREL)
{
if (ModelState.IsValid)
{
try
{
var _SeasonItem = new Class_SeasonItem()
{
Id = _SeasonREL.SeasonItemID,
SeasonId = _SeasonREL.SeasonID,
GroupLevelItemId = _SeasonREL.GroupLevelItemID,
Tax = _SeasonREL.SeasonItemTAX
};
//
if (_SeasonItem.Id == 0)
{
_context.Add(_SeasonItem);
}
else
{
_context.Update(_SeasonItem);
}
await _context.SaveChangesAsync();
}
catch (ApplicationException e)
{
return(RedirectToAction(nameof(Error), new { _Message = e.Message }));
}
return(RedirectToAction(nameof(PriceList), new { _SeasonId = _SeasonREL.SeasonID }));
}
//
return(View(_SeasonREL));
}
public async Task <IActionResult> CreateGL([Bind("Id,StatusId,CompanyId,GroupId,Name")] Class_GroupLevel _GroupLevel)
{
if (ModelState.IsValid)
{
_GroupLevel.Name = _GroupLevel.Name.ToUpper();
var _Find = _context.Class_GroupLevel.FirstOrDefaultAsync(m => m.Name == _GroupLevel.Name && m.CompanyId == _GroupLevel.CompanyId && m.Id != _GroupLevel.Id);
if (_Find.Result != null)
{
return(RedirectToAction(nameof(Error), new { _Message = "Nome já esta cadastrado!", _GroupId = _GroupLevel.GroupId }));
}
_context.Add(_GroupLevel);
await _context.SaveChangesAsync();
//retorno Listagem
return(RedirectToAction(nameof(Index), new { _GroupId = _GroupLevel.GroupId }));
}
ViewBag.GroupName = _GroupLevel.GroupId.ToString();
return(View(_GroupLevel));
}
public async Task <IActionResult> Create([Bind("Id,StatusId,Name,CNPJ,Site,ContactName,Phone1,Phone2,Email,PostalCode,Address,Complement,City,State,Country")] Class_Company _Company)
{
if (ModelState.IsValid)
{
var _Find = _context.Class_Company.FirstOrDefaultAsync(m => m.Name == _Company.Name && m.Id != _Company.Id);
if (_Find.Result != null)
{
return(RedirectToAction(nameof(Error), new { _Message = "Nome já esta cadastrado!" }));
}
_context.Add(_Company);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(_Company));
}
public async Task <IActionResult> Create([Bind("Id,StatusId,CompanyId,TypeId,Name,Tax,Percent")] Class_Channel _Channel)
{
if (ModelState.IsValid)
{
var _Find = _context.Class_Channel.FirstOrDefaultAsync(m => m.Name == _Channel.Name && m.CompanyId == _Channel.CompanyId && m.Id != _Channel.Id);
if (_Find.Result != null)
{
return(RedirectToAction(nameof(Error), new { _Message = "Nome já esta cadastrado!" }));
}
_context.Add(_Channel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewBag.ChannelType_LIST = new SelectList(Enum.GetValues(typeof(ChannelType)).Cast <ChannelType>().ToList());
return(View(_Channel));
}
public async Task <IActionResult> Create([Bind("Id,StatusId,CompanyId,TypeAccessId,Name,Email,Phone,UserName,Password")] Class_User _User)
{
if (ModelState.IsValid)
{
_User.Email = _User.Email.ToLower();
_User.UserName = _User.UserName.ToUpper();
if (_User.CompanyId != -1 && _User.TypeAccessId == UserTypeAccess.Master)
{
_User.TypeAccessId = UserTypeAccess.Admin;
}
else if (_User.CompanyId == -1 && _User.TypeAccessId != UserTypeAccess.Master)
{
_User.TypeAccessId = UserTypeAccess.Master;
}
var _Find = await _context.Class_User.FirstOrDefaultAsync(m => m.UserName == _User.UserName && m.Id != _User.Id);
if (_Find != null)
{
return(RedirectToAction(nameof(Error), new { _Message = "(UserName) já está cadastrado para " + _Find.Name }));
}
_context.Add(_User);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
var _CompanyLIST = from s in _context.Class_Company
where s.StatusId == CompanyStatus.Ativo
orderby s.Name
select new { s.Id, s.Name };
ViewBag.UserCompany_LIST = new SelectList(_CompanyLIST, "Id", "Name");
ViewBag.UserTypeAcess_LIST = new SelectList(Enum.GetValues(typeof(UserTypeAccess)).Cast <UserTypeAccess>().ToList());
return(View(_User));
}
public ActionResult CHECKin(Class_Checkin _Checkin)
{
if (ModelState.IsValid)
{
// Guest
var _Find = _context.Class_Guest.Where(m => m.CPF == _Checkin.Guest_CPF).FirstOrDefault();
if (_Find == null)
{
_Find = new Class_Guest()
{
CPF = _Checkin.Guest_CPF,
Name = _Checkin.Guest_Name,
Phone1 = _Checkin.Guest_Phone1,
Phone2 = _Checkin.Guest_Phone2,
Email = _Checkin.Guest_Email,
PostalCode = _Checkin.Guest_PostalCode,
Address = _Checkin.Guest_Address,
Complement = _Checkin.Guest_Complement,
City = _Checkin.Guest_City,
State = _Checkin.Guest_State,
Country = _Checkin.Guest_Country
};
_context.Add(_Find);
}
else
{
_Find.CPF = _Checkin.Guest_CPF;
_Find.Name = _Checkin.Guest_Name;
_Find.Phone1 = _Checkin.Guest_Phone1;
_Find.Phone2 = _Checkin.Guest_Phone2;
_Find.Email = _Checkin.Guest_Email;
_Find.PostalCode = _Checkin.Guest_PostalCode;
_Find.Address = _Checkin.Guest_Address;
_Find.Complement = _Checkin.Guest_Complement;
_Find.City = _Checkin.Guest_City;
_Find.State = _Checkin.Guest_State;
_Find.Country = _Checkin.Guest_Country;
_context.Update(_Find);
}
_context.SaveChanges();
// Book
var _Book = _context.Class_Book.Where(m => m.GroupLevelItemId == _Checkin.GroupLevelItem_Id && m.StatusId == BookStatus.EmUso).FirstOrDefault();
if (_Book == null)
{
_Book = new Class_Book
{
Id = 0
};
}
_Book.StatusId = BookStatus.EmUso;
_Book.GroupLevelItemId = _Checkin.GroupLevelItem_Id;
_Book.SeasonId = _Checkin.Season_Id;
_Book.ChannelId = _Checkin.Channel_Id;
_Book.Channel_Code = _Checkin.Channel_Code;
_Book.Channel_Tax = _Checkin.Channel_Tax;
_Book.Channel_Percent = _Checkin.Channel_Percent;
_Book.Book_DateIn = DateTime.ParseExact(_Checkin.Book_DateIn, "dd/MM/yyyy", null);
_Book.Book_DateOut = DateTime.ParseExact(_Checkin.Book_DateOut, "dd/MM/yyyy", null);
_Book.Book_AdultsNum = _Checkin.Book_AdultsNum;
_Book.Book_KidsNum = _Checkin.Book_KidsNum;
_Book.Book_PCD = _Checkin.Book_PCD;
_Book.Book_PET = _Checkin.Book_PET;
_Book.GuestCPF = _Checkin.Guest_CPF;
if (_Book.Id == 0)
{
_context.Add(_Book);
}
else
{
_context.Update(_Book);
}
_context.SaveChanges();
_Book = _context.Class_Book.Where(m => m.GroupLevelItemId == _Checkin.GroupLevelItem_Id && m.StatusId == BookStatus.EmUso).FirstOrDefault();
//Services
var _VlTotal = _Checkin.Book_PayTax * _Checkin.Book_Days;
var _VlDiscount = _VlTotal * ((double)_Checkin.Book_PayDiscount / 100);
var _VlFinal = _VlTotal - _VlDiscount - _Checkin.Book_PayCash;
var _BookItem = new Class_BookItem()
{
Id = 0,
StatusId = BookItemStatus.Consumido,
BookId = _Book.Id,
DateConsume = _Book.Book_DateIn,
GroupLevelItemId = _Book.GroupLevelItemId,
SeasonDesciption = "Diárias de Hospedagem",
SeasonUnit = _Checkin.Book_Days,
SeasonValue = _Checkin.Book_PayTax,
SeasonDiscountValue = _VlDiscount,
SeasonDiscountPercent = _Checkin.Book_PayDiscount,
SeasonAdvance = _Checkin.Book_PayCash,
OBS = string.Format("Check-in ({0}-{1}) {2}d, {3}, {4}% desc.",
_Book.Book_DateIn.ToString("dd/MM"),
_Book.Book_DateOut.ToString("dd/MM"),
_Checkin.Book_Days,
_VlTotal.ToString("C2"),
_Checkin.Book_PayDiscount)
};
_context.Add(_BookItem);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
//
int _CompanyId;
try { _CompanyId = int.Parse(User.FindFirst("CompanyId").Value); }
catch (Exception) { return(RedirectToAction(nameof(Error), new { _Message = "Login Necessário!" })); }
//
ViewBag.Season_LIST = from s in _context.Class_Season
where s.StatusId == SeasonStatus.Ativo && s.CompanyId == _CompanyId
orderby s.Name
select new { s.Id, s.Name };
//
ViewBag.Channel_LIST = from s in _context.Class_Channel
where s.CompanyId == _CompanyId && s.StatusId == ChannelStatus.Ativo
orderby s.TypeId, s.Name
select new { s.Id, s.Name };
//
ViewBag.yn_LIST = new SelectList(Enum.GetValues(typeof(GroupLevelItem_YN)));
//
return(View(_Checkin));
}
