public IHttpActionResult AssignPassengers([FromBody] ListDetails details)
{
List <DateTime> dates = details.flights.Select(a => a.date).ToList();
List <string> nums = details.flights.Select(a => a.num).ToList();
Expression <Func <Client, bool> > whereSelectedFlights = a => dates.Contains(a.date_arr) && nums.Contains(a.num_arr);
if (details.direction == "out")
{
whereSelectedFlights = a => dates.Contains(a.date_dep) && nums.Contains(a.num_dep);
}
var soldActivies = from a in db.SoldActivities
join b in db.Sales on a.sale_fk equals b.ID
join c in db.Clients.Where(whereSelectedFlights) on new { b.PNR, b.agency_fk } equals new { c.PNR, c.agency_fk }
where a.activity_fk == details.activity_fk && a.canceled == false
select a;
foreach (SoldActivity se in soldActivies)
{
se.event_fk = details.event_fk;
}
db.SaveChanges();
EventsController eventCtrl = new EventsController();
return(Ok(eventCtrl.getEvents(details.date, details.activity_fk)));
}
public virtual ListDetails UpdateTermListDetails(string listId, ListDetails details)
{
return(PolicyService.ExecuteRetryAndCapture400Errors(
"ContentModeratorService.UpdateTermListDetails",
ApiKeys.ContentModeratorRetryInSeconds,
() =>
{
var result = ContentModeratorRepository.UpdateTermListDetails(listId, details);
return result;
},
null));
}
public virtual ListDetails CreateTermList(ListDetails details)
{
return(PolicyService.ExecuteRetryAndCapture400Errors(
"ContentModeratorService.CreateTermList",
ApiKeys.ContentModeratorRetryInSeconds,
() =>
{
var result = ContentModeratorRepository.CreateTermList(details);
return result;
},
null));
}
public virtual ListDetails UpdateTermListDetails(string listId, ListDetails details)
{
try
{
var result = Task.Run(async() => await ContentModeratorRepository.UpdateTermListDetailsAsync(listId, details)).Result;
return(result);
}
catch (Exception ex)
{
Logger.Error("ContentModeratorService.UpdateTermListDetails failed", this, ex);
}
return(null);
}
public virtual ListDetails CreateTermList(ListDetails details)
{
try
{
var result = Task.Run(async() => await ContentModeratorRepository.CreateTermListAsync(details)).Result;
return(result);
}
catch (Exception ex)
{
Logger.Error("ContentModeratorService.CreateTextList failed", this, ex);
}
return(null);
}
public virtual ListDetails UpdateImageListDetails(string listId, ListDetails details)
{
try
{
var result = ContentModeratorRepository.UpdateImageListDetails(listId, details);
return(result);
}
catch (Exception ex)
{
Logger.Error("ContentModeratorService.UpdateImageListDetails failed", this, ex);
}
return(null);
}
public virtual ListDetails CreateList(ListDetails details)
{
try
{
var result = ContentModeratorRepository.CreateList(details);
return(result);
}
catch (Exception ex)
{
Logger.Error("ContentModeratorService.CreateList failed", this, ex);
}
return(null);
}
public static ListDetails[] GetFilterData(string CtlID, string FilterId, string ReportId)
{
DataSet dt = new DataSet();
List <ListDetails> details = new List <ListDetails>();
dt = BrilliantWMS.CommonControlReport.UC_RptFilter.GetFilterData(CtlID, FilterId, ReportId, "", "");
foreach (DataRow dtrow in dt.Tables[0].Rows)
{
ListDetails ListDtls = new ListDetails();
ListDtls.Id = Convert.ToInt32(dtrow["Id"].ToString());
ListDtls.Name = dtrow["Name"].ToString();
details.Add(ListDtls);
}
return(details.ToArray());
}
public IHttpActionResult GetCreatePlan([FromBody] ListDetails details)
{
try
{
DateTime dateStart = details.date;
List <Flight> selected_flights = details.flights;
List <DateTime> dates = selected_flights.Select(a => a.date).ToList();
List <string> nums = selected_flights.Select(a => a.num).ToList();
var unAssignPassengers = GetPotentialPassengers(dateStart, details.activity_fk, "out");
var selectedInFlights = unAssignPassengers.Where(a => dates.Contains(a.flight.date) && nums.Contains(a.flight.num));
var departPlan = from a in selectedInFlights
group a by new { a.hotel_fk, a.hotel_name } into g
select new DepartPlan
{
hotel_fk = g.Key.hotel_fk,
// hotel_name = g.Key.hotel_name,
PAX = g.Sum(a => a.persons),
event_fk = details.event_fk
};
//Clear past lists:
db.DepartPlans.RemoveRange(db.DepartPlans.Where(a => a.event_fk == details.event_fk));
db.DepartPlans.AddRange(departPlan.ToList());
db.SaveChanges();
return(Ok(getDepartPlan(details.event_fk)));
}
catch (Exception ex)
{
Exception rootEx = ex.GetBaseException();
return(Content(HttpStatusCode.InternalServerError, rootEx.Message));
}
}
/// <summary>
/// LUA结构支持
/// </summary>
/// <returns></returns>
public override void GetLuaStruct(StringBuilder code)
{
base.GetLuaStruct(code);
int idx;
code.AppendLine($@"['ColumnIndexStart'] ={ColumnIndexStart},");
code.AppendLine($@"['IsUniqueUnion'] ={(IsUniqueUnion.ToString().ToLower())},");
if (PrimaryColumn != null)
{
code.AppendLine($@"['PrimaryColumn'] = {PrimaryColumn.GetLuaStruct()},");
}
if (!string.IsNullOrWhiteSpace(PrimaryField))
{
code.AppendLine($@"['PrimaryField'] = '{PrimaryField.ToLuaString()}',");
}
else
{
code.AppendLine($@"['PrimaryField'] = nil,");
}
if (!string.IsNullOrWhiteSpace(RedisKey))
{
code.AppendLine($@"['RedisKey'] = '{RedisKey.ToLuaString()}',");
}
else
{
code.AppendLine($@"['RedisKey'] = nil,");
}
if (!string.IsNullOrWhiteSpace(ModelInclude))
{
code.AppendLine($@"['ModelInclude'] = '{ModelInclude.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ModelInclude'] = nil,");
}
if (!string.IsNullOrWhiteSpace(ModelBase))
{
code.AppendLine($@"['ModelBase'] = '{ModelBase.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ModelBase'] = nil,");
}
code.AppendLine($@"['DataVersion'] ={DataVersion},");
code.AppendLine($@"['IsInternal'] ={(IsInternal.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(Name))
{
code.AppendLine($@"['Name'] = '{Name.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Name'] = nil,");
}
code.AppendLine($@"['IsClass'] ={(IsClass.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(Interfaces))
{
code.AppendLine($@"['Interfaces'] = '{Interfaces.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Interfaces'] = nil,");
}
if (!string.IsNullOrWhiteSpace(Project))
{
code.AppendLine($@"['Project'] = '{Project.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Project'] = nil,");
}
code.AppendLine($@"['MaxIdentity'] ={MaxIdentity},");
idx = 0;
code.AppendLine("['Properties'] ={");
foreach (var val in Properties)
{
if (idx++ > 0)
{
code.Append(',');
}
code.AppendLine($@"{val.GetLuaStruct()}");
}
code.AppendLine("},");
//idx = 0;
//code.AppendLine("['LastProperties'] ={");
//foreach (var val in LastProperties)
//{
// if (idx++ > 0)
// code.Append(',');
// code.AppendLine($@"{val.GetLuaStruct()}");
//}
//code.AppendLine("},");
idx = 0;
code.AppendLine("['Commands'] ={");
foreach (var val in Commands)
{
if (idx++ > 0)
{
code.Append(',');
}
code.AppendLine($@"{val.GetLuaStruct()}");
}
code.AppendLine("},");
idx = 0;
code.AppendLine("['Releations'] ={");
foreach (var val in Releations)
{
if (idx++ > 0)
{
code.Append(',');
}
code.AppendLine($@"{val.GetLuaStruct()}");
}
code.AppendLine("},");
code.AppendLine($@"['MaxForm'] ={(MaxForm.ToString().ToLower())},");
code.AppendLine($@"['ListDetails'] ={(ListDetails.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(ReadTableName))
{
code.AppendLine($@"['TableName'] = '{ReadTableName.ToLuaString()}',");
}
else
{
code.AppendLine($@"['TableName'] = nil,");
}
if (!string.IsNullOrWhiteSpace(SaveTableName))
{
code.AppendLine($@"['SaveTableName'] = '{SaveTableName.ToLuaString()}',");
}
else
{
code.AppendLine($@"['SaveTableName'] = nil,");
}
if (!string.IsNullOrWhiteSpace(SaveTable))
{
code.AppendLine($@"['SaveTable'] = '{SaveTable.ToLuaString()}',");
}
else
{
code.AppendLine($@"['SaveTable'] = nil,");
}
code.AppendLine($@"['DbIndex'] ={DbIndex},");
code.AppendLine($@"['UpdateByModified'] ={(UpdateByModified.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(CppName))
{
code.AppendLine($@"['CppName'] = '{CppName.ToLuaString()}',");
}
else
{
code.AppendLine($@"['CppName'] = nil,");
}
if (!string.IsNullOrWhiteSpace(DisplayName))
{
code.AppendLine($@"['DisplayName'] = '{DisplayName.ToLuaString()}',");
}
else
{
code.AppendLine($@"['DisplayName'] = nil,");
}
//idx = 0;
//code.AppendLine("['PublishProperty'] ={");
//foreach (var val in PublishProperty)
//{
// if (idx++ > 0)
// code.Append(',');
// code.AppendLine($@"{val.GetLuaStruct()}");
//}
//code.AppendLine("},");
//idx = 0;
//code.AppendLine("['CppProperty'] ={");
//foreach (var val in CppProperty)
//{
// if (idx++ > 0)
// code.Append(',');
// code.AppendLine($@"{val.GetLuaStruct()}");
//}
//code.AppendLine("},");
//idx = 0;
//code.AppendLine("['ClientProperty'] ={");
//foreach (var val in ClientProperty)
//{
// if (idx++ > 0)
// code.Append(',');
// code.AppendLine($@"{val.GetLuaStruct()}");
//}
//code.AppendLine("},");
//idx = 0;
//code.AppendLine("['UserProperty'] ={");
//foreach (var val in UserProperty)
//{
// if (idx++ > 0)
// code.Append(',');
// code.AppendLine($@"{val.GetLuaStruct()}");
//}
//code.AppendLine("},");
//idx = 0;
//code.AppendLine("['PublishDbFields'] ={");
//foreach (var val in PublishDbFields)
//{
// if (idx++ > 0)
// code.Append(',');
// code.AppendLine($@"{val.GetLuaStruct()}");
//}
//code.AppendLine("},");
//idx = 0;
//code.AppendLine("['DbFields'] ={");
//foreach (var val in DbFields)
//{
// if (idx++ > 0)
// code.Append(',');
// code.AppendLine($@"{val.GetLuaStruct()}");
//}
//code.AppendLine("},");
//idx = 0;
//code.AppendLine("['ReadCoreCodes'] ={");
//foreach (var val in ReadCoreCodes.Values)
//{
// if (idx++ > 0)
// code.Append(',');
// code.AppendLine($@"{val.GetLuaStruct()}");
//}
//code.AppendLine("},");
}
public virtual async Task <ListDetails> UpdateTermListDetailsAsync(string listId, ListDetails details)
{
var response = await RepositoryClient.SendJsonPutAsync(ApiKeys.ContentModerator, $"{ApiKeys.ContentModeratorEndpoint}{termListUrl}{listId}", JsonConvert.SerializeObject(details));
return(JsonConvert.DeserializeObject <ListDetails>(response));
}
public virtual async Task <ListDetails> CreateTermListAsync(ListDetails details)
{
var response = await RepositoryClient.SendJsonPostAsync(ApiKeys.ContentModerator, termListUrl, JsonConvert.SerializeObject(details));
return(JsonConvert.DeserializeObject <ListDetails>(response));
}
public virtual ListDetails UpdateImageListDetails(string listId, ListDetails details)
{
var response = RepositoryClient.SendJsonPut(ApiKeys.ContentModerator, $"{ApiKeys.ContentModeratorEndpoint}{listUrl}{listId}", JsonConvert.SerializeObject(details));
return(JsonConvert.DeserializeObject <ListDetails>(response));
}
public virtual ListDetails CreateList(ListDetails details)
{
var response = RepositoryClient.SendJsonPost(ApiKeys.ContentModerator, $"{ApiKeys.ContentModeratorEndpoint}{listUrl}", JsonConvert.SerializeObject(details));
return(JsonConvert.DeserializeObject <ListDetails>(response));
}
public ReadOnlyListDetails(string urlName, SPListTemplateType templateType, string title, string description, bool enforceUniqueValues)
{
_listDetails = new ListDetails(urlName, templateType, title, description, enforceUniqueValues);
}
/// <summary>
/// Checks if a list exists in a site using its "internal name" and creates it if it doesn't exist.
/// </summary>
/// <param name="site">The site to check.</param>
/// <param name="listDetail">The details of the list.</param>
/// <param name="isNewList">A boolean that is set to true, if a new list is created; otherwise, it is set to false.</param>
/// <returns>A SPList object that references an existing or newly created list.</returns>
public static SPList EnsureList(this SPWeb site, ListDetails listDetail, ref bool isNewList)
{
return EnsureList(site, listDetail.UrlName, listDetail.TemplateType, listDetail.Title, listDetail.Description, ref isNewList);
}
