public async Task <string> SavePackageAsync(utblTourPackage model)
{
try
{
var parPackID = new SqlParameter("@PackageID", model.PackageID);
var parPackName = new SqlParameter("@PackageName", model.PackageName);
var parPackType = new SqlParameter("@PackageTypeID", model.PackageTypeID);
var parPackRouting = new SqlParameter("@PackageRouting", model.PackageRouting ?? "");
var parPickup = new SqlParameter("@PickupPoint", model.PickupPoint ?? "");
var parDrop = new SqlParameter("@DropPoint", model.DropPoint ?? "");
var parDays = new SqlParameter("@TotalDays", model.TotalDays);
var parBaseFare = new SqlParameter("@BaseFare", model.BaseFare);
var parPackDesc = new SqlParameter("@PackageDesc", model.PackageDesc ?? "");
var parPackLink = new SqlParameter("@LinkText", model.LinkText);
var parMetaText = new SqlParameter("@MetaText", model.MetaText ?? "");
var parMetaDesc = new SqlParameter("@MetaDesc", model.MetaDesc ?? "");
var parShowPack = new SqlParameter("@ShowPackage", model.ShowPackage);
var parFarePer = new SqlParameter("@FarePer", model.FarePer);
var parShowPrice = new SqlParameter("@ShowPrice", model.IsPriceVisible);
return(await db.Database.SqlQuery <string>("udspTourPackageSave @PackageID, @PackageName, @PackageTypeID, @PackageRouting, @PickupPoint, @DropPoint"
+ ",@TotalDays, @BaseFare, @PackageDesc, @LinkText, @MetaText, @MetaDesc,@ShowPackage, @FarePer,@ShowPrice",
parPackID, parPackName, parPackType, parPackRouting, parPickup, parDrop,
parDays, parBaseFare, parPackDesc, parPackLink, parMetaText, parMetaDesc, parShowPack, parFarePer, parShowPrice).FirstOrDefaultAsync());
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public async Task <string> SavePackage(utblTourPackage model)
{
if (ModelState.IsValid)
{
return(await objPack.SavePackageAsync(model));
}
string messages = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return("Operation Error: " + messages);
}
