public async Task <string> SaveActivityInclusion(PackageActIncSaveModel model)
{
if (ModelState.IsValid)
{
return(await objPack.SavePackageActIncAsync(model));
}
string messages = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return("Operation Error: " + messages);
}
public async Task <string> SavePackageActIncAsync(PackageActIncSaveModel model)
{
try
{
var parPackID = new SqlParameter("@PackageID", model.PackageID);
ConvertListToDT objList = new ConvertListToDT();
DataTable actdt = new DataTable();
DataTable incdt = new DataTable();
//Converting subject list to datatable if record is present else send empty datatable
if (model.Activities != null)
{
actdt = objList.ConvertIEnumerableToDataTable(model.Activities);
}
else
{
if (actdt.Columns.Count == 0)
{
DataColumn col = new DataColumn();
col.ColumnName = "PackageActivityID";
actdt.Columns.Add(col);
DataColumn col1 = new DataColumn();
col1.ColumnName = "PackageID";
actdt.Columns.Add(col1);
DataColumn col2 = new DataColumn();
col2.ColumnName = "ActivityID";
actdt.Columns.Add(col2);
DataColumn col3 = new DataColumn();
col3.ColumnName = "ActivityFare";
actdt.Columns.Add(col3);
}
}
var parActDT = new SqlParameter("@ActivityTable", actdt);
parActDT.SqlDbType = SqlDbType.Structured;
parActDT.TypeName = "dbo.ActivityType";
if (model.Inclusions != null)
{
incdt = objList.ConvertIEnumerableToDataTable(model.Inclusions);
}
else
{
if (incdt.Columns.Count == 0)
{
DataColumn col = new DataColumn();
col.ColumnName = "PackageInclusionID";
incdt.Columns.Add(col);
DataColumn col1 = new DataColumn();
col1.ColumnName = "PackageID";
incdt.Columns.Add(col1);
DataColumn col2 = new DataColumn();
col2.ColumnName = "InclusionID";
incdt.Columns.Add(col2);
DataColumn col3 = new DataColumn();
col3.ColumnName = "InclusionFare";
incdt.Columns.Add(col3);
}
}
var parIncDT = new SqlParameter("@InclusionTable", incdt);
parIncDT.SqlDbType = SqlDbType.Structured;
parIncDT.TypeName = "dbo.InclusionType";
return(await db.Database.SqlQuery <string>("udspTourPackageActivityInclusionSave @PackageID, @ActivityTable, @InclusionTable",
parPackID, parActDT, parIncDT).FirstOrDefaultAsync());
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
