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); }