public int InsertOrUpdate(B2b_com_roomtype model)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalB2b_com_roomtype(sql);
int result = internalData.InsertOrUpdate(model);
return(result);
}
catch
{
throw;
}
}
}
public int InsertOrUpdate(B2b_com_roomtype model)
{
var cmd = sqlHelper.PrepareStoredSqlCommand(SQLInsertOrUpdate);
cmd.AddParam("@Id", model.Id);
cmd.AddParam("@Name", model.Name);
cmd.AddParam("@Bedtype", model.Bedtype);
cmd.AddParam("@Wifi", model.Wifi);
cmd.AddParam("@ReserveType", model.ReserveType);
cmd.AddParam("@Builtuparea", model.Builtuparea);
cmd.AddParam("@Floor", model.Floor);
cmd.AddParam("@Bedwidth", model.Bedwidth);
cmd.AddParam("@Whetherextrabed", model.Whetherextrabed);
cmd.AddParam("@Extrabedprice", model.Extrabedprice);
cmd.AddParam("@Largestguestnum", model.Largestguestnum);
cmd.AddParam("@Whethernonsmoking", model.Whethernonsmoking);
cmd.AddParam("@Amenities", model.Amenities);
cmd.AddParam("@Mediatechnology", model.Mediatechnology);
cmd.AddParam("@Foodanddrink", model.Foodanddrink);
cmd.AddParam("@ShowerRoom", model.ShowerRoom);
cmd.AddParam("@Breakfast", model.Breakfast);
cmd.AddParam("@Sms", model.Sms);
cmd.AddParam("@Sortid", model.Sortid);
cmd.AddParam("@Server_type", model.Server_type);
cmd.AddParam("@Pro_type", model.Pro_type);
cmd.AddParam("@Source_type", model.Source_type);
cmd.AddParam("@Createuserid", model.Createuserid);
cmd.AddParam("@Createtime", model.Createtime);
cmd.AddParam("@Whetheravailabel", model.Whetheravailabel);
cmd.AddParam("@Roomtyperemark", model.Roomtyperemark);
cmd.AddParam("@Comid", model.Comid);
cmd.AddParam("@Roomtypeimg", model.Roomtypeimg);
cmd.AddParam("@RecerceSMSName", model.RecerceSMSName);
cmd.AddParam("@RecerceSMSPhone", model.RecerceSMSPhone);
var parm = cmd.AddReturnValueParameter("ReturnValue");
cmd.ExecuteNonQuery();
return((int)parm.Value);
}
