public Task <int> Create(Books article)
{
return(Task.Run(() =>
{
var dbPara = new DynamicParameters();
dbPara.Add("BookName", article.BookName, DbType.String);
dbPara.Add("BookSize", article.BookSize, DbType.Int32);
var articleId = _dapperManager.Insert <int>("[dbo].[SP_Add_Books]",
dbPara,
commandType: CommandType.StoredProcedure);
foreach (var author in article.AuthorList)
{
dbPara = new DynamicParameters();
dbPara.Add("AuthorId", author.AuthorId, DbType.Int32);
dbPara.Add("BookId", articleId, DbType.Int32);
_dapperManager.Insert <int>("[dbo].[SP_Add_AuthorBook]",
dbPara,
commandType: CommandType.StoredProcedure);
}
foreach (var author in article.BookGenreList)
{
dbPara = new DynamicParameters();
dbPara.Add("BookGenreId", author.BookGenreId, DbType.Int32);
dbPara.Add("BookId", articleId, DbType.Int32);
_dapperManager.Insert <int>("[dbo].[SP_Add_BookBookGenrese]",
dbPara,
commandType: CommandType.StoredProcedure);
}
return articleId;
}));
}
//ESTE ES EL DEL LOGIN
public Task <int> Createlogin(login log)
{
var dbPara = new DynamicParameters();
dbPara.Add("UserID", log.UserID, DbType.String);
dbPara.Add("passID", log.passID, DbType.String);
var articleId = Task.FromResult(_dapperManager.Insert <int>("[dbo].[Add_login]",
dbPara,
commandType: CommandType.StoredProcedure));
return(articleId);
}
public Task <int> Create(Clients article)
{
var dbPara = new DynamicParameters();
dbPara.Add("ClientFullName", article.ClientFullName, DbType.String);
dbPara.Add("ClientCategoryId", article.ClientCategoryId, DbType.Int32);
var articleId = Task.FromResult(_dapperManager.Insert <int>("[dbo].[SP_Add_Client]",
dbPara,
commandType: CommandType.StoredProcedure));
return(articleId);
}
//
//
public Task <int> Agregar(Reservas reservas)
{
var dbPara = new DynamicParameters();
dbPara.Add("ID_Cliente", reservas.ID_Cliente, DbType.String);
dbPara.Add("ID_Institucion", reservas.ID_Institucion, DbType.String);
dbPara.Add("ID_Vehiculo", reservas.ID_Vehiculo, DbType.String);
dbPara.Add("Fecha_Inc", reservas.Fecha_Inc, DbType.String);
dbPara.Add("Fecha_Fin", reservas.Fecha_Fin, DbType.String);
var ReservaID = Task.FromResult(_dapperManager.Insert <int>("[dbo].[Add_Reserva]",
dbPara,
commandType: CommandType.StoredProcedure));
return(ReservaID);
}
public Task <dtInvVoucher> CreateVoucher(dtInvVoucher InvVoucher)
{
var dbPara = new DynamicParameters();
dbPara.Add("VNo", InvVoucher.VNo, DbType.String);
dbPara.Add("EffectiveDate", InvVoucher.EffectiveDate, DbType.String);
dbPara.Add("VDate", InvVoucher.VDate, DbType.String);
dbPara.Add("DueDate", InvVoucher.DueDate, DbType.String);
dbPara.Add("CreatedDate", InvVoucher.CreatedDate, DbType.String);
dbPara.Add("ModifiedDate", InvVoucher.ModifiedDate, DbType.String);
dbPara.Add("StaffName", InvVoucher.StaffName, DbType.String);
dbPara.Add("VType", InvVoucher.VType, DbType.String);
dbPara.Add("BranchID", InvVoucher.BranchID, DbType.String);
dbPara.Add("VATAmt", InvVoucher.VATAmt, DbType.String);
dbPara.Add("VATPaid", InvVoucher.VATPaid, DbType.String);
dbPara.Add("VRound", InvVoucher.VRound, DbType.String);
dbPara.Add("SubTotal", InvVoucher.SubTotal, DbType.String);
dbPara.Add("IsCanceled", InvVoucher.IsCanceled, DbType.String);
dbPara.Add("CreatedUserID", InvVoucher.CreatedUserID, DbType.String);
dbPara.Add("ModifiedUserID", InvVoucher.ModifiedUserID, DbType.String);
dbPara.Add("ExchangeRate", InvVoucher.ExchangeRate, DbType.String);
dbPara.Add("Currency", InvVoucher.Currency, DbType.String);
var VId = Task.FromResult(_dapperManager.Insert <dtInvVoucher>("[VoucherSP]",
dbPara,
commandType: CommandType.StoredProcedure));
return(VId);
}
public Task <int> Create(Vehiculos vehiculo)
{
var dbPara = new DynamicParameters();
dbPara.Add("Marca", vehiculo.Marca, DbType.String);
dbPara.Add("ID_Institucion", vehiculo.ID_Institucion, DbType.String);
dbPara.Add("Modelo", vehiculo.Modelo, DbType.String);
dbPara.Add("Año", vehiculo.Año, DbType.String);
dbPara.Add("Color", vehiculo.Color, DbType.String);
dbPara.Add("Precio_Dia", vehiculo.Precio_Dia, DbType.Double);
dbPara.Add("Tipo", vehiculo.Tipo, DbType.String);
dbPara.Add("Capacidad_Carga", vehiculo.Capacidad_Carga, DbType.Double);
dbPara.Add("Pasajeros", vehiculo.Pasajeros, DbType.Int32);
dbPara.Add("Matricula", vehiculo.Matricula, DbType.String);
dbPara.Add("NO_Seguro", vehiculo.No_Seguro, DbType.String);
dbPara.Add("Foto", vehiculo.Foto, DbType.String);
dbPara.Add("Generado", vehiculo.Generado, DbType.Double);
dbPara.Add("Veces_Reservados", vehiculo.Veces_Reservados, DbType.Int32);
dbPara.Add("Latitud", vehiculo.Latitud, DbType.Double);
dbPara.Add("Longitud", vehiculo.Longitud, DbType.Double);
dbPara.Add("Estado", vehiculo.Estado, DbType.String);
var VehiculoID = Task.FromResult(_dapperManager.Insert <int>("[dbo].[SP_Add_Vehiculos]",
dbPara,
commandType: CommandType.StoredProcedure));
return(VehiculoID);
}
public Task <int> Create(User user)
{
var dbPara = new DynamicParameters();
//dbPara.Add("UserName", user.UserName, DbType.String);
//dbPara.Add("PasswordHash", user.PasswordHash, DbType.String);
//dbPara.Add("DELETED", false, DbType.Boolean);
//dbPara.Add("UpdatedDateTime", user.UpdatedDateTime, DbType.DateTime);
//dbPara.Add("UpdatedBy", user.UpdatedBy, DbType.String);
dbPara.Add("@UserName", user.UserName, DbType.String);
dbPara.Add("@PasswordHash", user.PasswordHash, DbType.String);
dbPara.Add("@DELETED", false, DbType.Boolean);
dbPara.Add("@UpdatedDateTime", user.UpdatedDateTime, DbType.DateTime);
dbPara.Add("@UpdatedBy", user.UpdatedBy, DbType.String);
//{ "@UpdatedDateTime", 1 }
var userId = Task.FromResult(_dapperManager.Insert <int>(
$"INSERT INTO [User](UserName,Password,DELETED,UpdatedDateTime,UpdatedBy) OUTPUT Inserted.ID VALUES(@UserName,@PasswordHash,@DELETED,@UpdatedDateTime,@UpdatedBy)",
dbPara,
commandType: CommandType.Text));
return(userId);
}
public Task<int> Create(c_order article)
{
var dbPara = new DynamicParameters();
dbPara.Add("Name", article.name, DbType.String);
dbPara.Add("Note", article.note, DbType.String);
var articleId = Task.FromResult(_dapperManager.Insert<int>(@"INSERT INTO c_order (name,note) VALUES (@Name,@Note);SELECT LAST_INSERT_ID();",
dbPara,
commandType: CommandType.Text));
return articleId;
}
public Task <int> Create(Article article)
{
var dbPara = new DynamicParameters();
dbPara.Add("Title", article.Title, DbType.String);
var articleId = Task.FromResult(_dapperManager.Insert <int>("[dbo].[SP_Add_Article]",
dbPara,
commandType: CommandType.StoredProcedure));
return(articleId);
}
public Task <int> Create(BookGenres article)
{
var dbPara = new DynamicParameters();
dbPara.Add("BookGenreName", article.BookGenreName, DbType.String);
dbPara.Add("MoreLikeBookGenreId", null, DbType.Int32);
var articleId = Task.FromResult(_dapperManager.Insert <int>("[dbo].[SP_Add_BookGenres]",
dbPara,
commandType: CommandType.StoredProcedure));
return(articleId);
}
public Task <int> Create(FeatureValue featureValue)
{
var dbPara = new DynamicParameters();
dbPara.Add("Name", featureValue.Name, DbType.String);
dbPara.Add("Value", featureValue.Value, DbType.String);
var featureValueId = Task.FromResult(_dapperManager.Insert <int>("[dbo].[SP_Add_FeatureValue]",
dbPara,
commandType: CommandType.StoredProcedure));
return(featureValueId);
}
//Metodo para agregar cada uno de los campos en la tabla de CLientes de la base de datos
public Task <int> Create(Clientes cliente)
{
var dbPara = new DynamicParameters();
dbPara.Add("Cedula", cliente.Cedula, DbType.String);
dbPara.Add("ID_Institucion", cliente.ID_Institucion, DbType.String);
dbPara.Add("Nombre", cliente.Nombre, DbType.String);
dbPara.Add("Apellido", cliente.Apellido, DbType.String);
dbPara.Add("Correo", cliente.Correo, DbType.String);
dbPara.Add("Licencia", cliente.Licencia, DbType.String);
dbPara.Add("Nacionalidad", cliente.Nacionalidad, DbType.String);
dbPara.Add("Tipo_Sangre", cliente.Tipo_Sangre, DbType.String);
dbPara.Add("Foto_Persona", cliente.Foto_Persona, DbType.String);
dbPara.Add("Foto_Licencia", cliente.Foto_Licencia, DbType.String);
dbPara.Add("Estado", cliente.Estado, DbType.String);
var ClienteID = Task.FromResult(_dapperManager.Insert <int>("[dbo].[SP_Add_Clientes]",
dbPara,
commandType: CommandType.StoredProcedure));
return(ClienteID);
}
public async Task <IActionResult> Post([FromBody] Class Class)
{
return(Json(await manager.Insert(Class, x => x.Id)));
}
public async override Task <IResponseMessage <GeneralSettingsVM> > Add(GeneralSettingsVM obj)
{
var dbPara = new DynamicParameters();
dbPara.Add("TitleEN", obj.TitleEN ?? "", DbType.String);
dbPara.Add("TitleAR", obj.TitleAR ?? "", DbType.String);
dbPara.Add("WelWordsEN", obj.WelWordsEN ?? "", DbType.String);
dbPara.Add("WelWordsAR", obj.WelWordsAR ?? "", DbType.String);
dbPara.Add("MetaDesc", obj.MetaDesc ?? "", DbType.String);
dbPara.Add("MetaKW", obj.MetaKW ?? "", DbType.String);
dbPara.Add("Facebook", obj.Facebook ?? "", DbType.String);
dbPara.Add("Twitter", obj.Twitter, DbType.Int32);
dbPara.Add("Instagram", obj.Instagram ?? "", DbType.String);
dbPara.Add("Youtube", obj.Youtube ?? "", DbType.String);
dbPara.Add("Linkedin", obj.Linkedin ?? "", DbType.String);
dbPara.Add("AppStore", obj.AppStore ?? "", DbType.String);
dbPara.Add("GooglePlay", obj.GooglePlay ?? "", DbType.String);
dbPara.Add("Address", obj.Address ?? "", DbType.String);
dbPara.Add("Email", obj.Email ?? "", DbType.String);
dbPara.Add("Phone", obj.Phone, DbType.Int32);
dbPara.Add("Fax", obj.Fax ?? "", DbType.String);
dbPara.Add("DefaultCountryId", obj.DefaultCountryId, DbType.Int32);
dbPara.Add("Latitude", obj.Latitude ?? "", DbType.String);
dbPara.Add("Longitude", obj.Longitude ?? "", DbType.String);
dbPara.Add("PageSize", obj.PageSize, DbType.Int32);
dbPara.Add("PageSizeMob", obj.PageSizeMob, DbType.Int32);
dbPara.Add("AutoActiveUser", obj.AutoActiveUser, DbType.Int32);
dbPara.Add("AutoActiveArticle", obj.AutoActiveArticle, DbType.Int32);
dbPara.Add("AddedOn", obj.AddedOn, DbType.DateTime);
dbPara.Add("ModifiedOn", obj.ModifiedOn, DbType.DateTime);
dbPara.Add("AdminUserId", obj.AdminUserId, DbType.Int32);
string SQL = $"INSERT INTO dbo.GeneralSettings ";
SQL += " (TitleEN, TitleAR, WelWordsEN, WelWordsAR, MetaDesc, MetaKW, Facebook, Twitter, Instagram, Youtube, Linkedin, AppStore, GooglePlay, Address, Email, Phone, Fax, DefaultCountryId, Latitude, Longitude, PageSize, ";
SQL += " PageSizeMob, AutoActiveUser, AutoActiveArticle, AddedOn, ModifiedOn, AdminUserId) ";
SQL += " VALUES (@TitleEN,@TitleAR,@WelWordsEN,@WelWordsAR,@MetaDesc,@MetaKW,@Facebook,@Twitter,@Instagram,@Youtube,@Linkedin,@AppStore,@GooglePlay,@Address,@Email,@Phone,@Fax,@DefaultCountryId,@Latitude,@Longitude,@PageSize,@PageSizeMob,@AutoActiveUser,@AutoActiveArticle,@AddedOn,@ModifiedOn,@AdminUserId) select @@identity; ";
try
{
var newID = await Task.FromResult(dapperManager.Insert <int>(SQL, dbPara, CommandType.Text));
if (newID > 0)
{
obj.Id = newID;
return(new ResponseMessageBase <GeneralSettingsVM>()
{
MessageType = MessageTypes.Success, ResponseData = new[] { obj }
});
}
return(new ResponseMessageBase <GeneralSettingsVM>()
{
MessageType = MessageTypes.Error, ResponseData = null
});
}
catch (Exception ex)
{ return(new ResponseMessageBase <GeneralSettingsVM>()
{
MessageType = MessageTypes.Error, ResponseData = null, exception = ex
}); }
}
public async Task <IActionResult> Post([FromBody] Branch Branch)
{
return(Json(await manager.Insert(Branch, x => x.Id)));
}
public async Task <IActionResult> Post([FromBody] City city)
{
return(Json(await manager.Insert(city, x => x.Id)));
}
