public async Task <string> SaveHotelAsync(HotelSaveModel model)
{
try
{
ConvertListToDT objDT = new ConvertListToDT();
DataTable typeDt = new DataTable();
var parHotelID = new SqlParameter("@HotelID", model.HotelID);
var parDestID = new SqlParameter("@DestinationID", model.DestinationID);
var parHotelName = new SqlParameter("@HotelName", model.HotelName);
var parHotelAddress = new SqlParameter("@HotelAddress", model.HotelAddress);
var parHotelContact = new SqlParameter("@HotelContact", model.HotelContact);
var parHotelEmail = new SqlParameter("@HotelEmail", model.HotelEmail ?? "");
List <IDModel> tyepList = model.HotelTypes.Select(x => new IDModel()
{
ID = Convert.ToInt64(x)
}).ToList();
typeDt = objDT.ConvertIEnumerableToDataTable(tyepList);
var parSubDT = new SqlParameter("@HotelTypeTable", typeDt);
parSubDT.SqlDbType = SqlDbType.Structured;
parSubDT.TypeName = "dbo.IDType";
return(await db.Database.SqlQuery <string>("udspMstHotelSave @HotelID, @DestinationID, @HotelName, @HotelAddress, @HotelContact, @HotelEmail, @HotelTypeTable",
parHotelID, parDestID, parHotelName, parHotelAddress, parHotelContact, parHotelEmail, parSubDT).FirstOrDefaultAsync());
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public async Task <string> SaveHotel(HotelSaveModel model)
{
if (ModelState.IsValid)
{
return(await objHotel.SaveHotelAsync(model));
}
string messages = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return("Operation Error: " + messages);
}
