public bool AddUser(UserDTO userDetails)
{
userDetails.Password = Encrypt(userDetails.Password);
int rowsAffected = _dapperManager.Execute(@"INSERT INTO User(USER_TYPE_ID,USER_ROLE_ID,FIRSTNAME,LASTNAME,EMAIL,PASSWORD,PASSWORD_UPDATED_ON,ISDELETED,ISLOCKED,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON) VALUES (@USER_TYPE_ID,@USER_ROLE_ID,@FIRSTNAME,@LASTNAME,@EMAIL,@PASSWORD,@PASSWORD_UPDATED_ON,@ISDELETED,@ISLOCKED,@CREATED_BY,@CREATED_ON,@UPDATED_BY,@UPDATED_ON)",
new {
USER_TYPE_ID = userDetails.User_Type_Id,
USER_ROLE_ID = userDetails.User_Role_Id,
FIRSTNAME = userDetails.Firstname,
LASTNAME = userDetails.Lastname,
EMAIL = userDetails.Email,
PASSWORD = userDetails.Password,
PASSWORD_UPDATED_ON = userDetails.Password_Updated_On,
ISDELETED = userDetails.IsDeleted,
ISLOCKED = userDetails.IsLocked,
CREATED_BY = userDetails.Created_By,
CREATED_ON = userDetails.Created_On,
UPDATED_BY = userDetails.Updated_By,
UPDATED_ON = userDetails.Updated_On
});
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
public Task <int> Delete(int id)
{
var deleteArticle = Task.FromResult(_dapperManager.Execute($"Delete [Clients] where ClientId = {id}", null,
commandType: CommandType.Text));
return(deleteArticle);
}
public Task <int> Delete(int id)
{
return(Task.Run(() =>
{
var deleteArticle = _dapperManager.Execute($"Delete [Books] where BookId = {id}", null,
commandType: CommandType.Text);
_dapperManager.Execute($"Delete AuthorBook where BookId = {id}", null,
commandType: CommandType.Text);
_dapperManager.Execute($"Delete BookBookGenres where BookId = {id}", null,
commandType: CommandType.Text);
return deleteArticle;
}));
}
public Task <int> Delete(int id, string id_institucion)
{
var deleteVehiculos = Task.FromResult(_dapperManager.Execute($"Delete [Vehiculos] where ID = {id} AND ID_Institucion = '{id_institucion}'", null,
commandType: CommandType.Text));
return(deleteVehiculos);
}
public Task <int> Delete(int id)
{
var deleteFeatureValue = Task.FromResult(_dapperManager.Execute($"Delete [FeatureValue] where ID = {id}", null,
commandType: CommandType.Text));
return(deleteFeatureValue);
}
public async override Task <IResponseMessage <GeneralSettingsVM> > Remove(GeneralSettingsVM obj)
{
if (obj == null || obj.Id <= 0)
{
return(new ResponseMessageBase <GeneralSettingsVM>()
{
MessageType = MessageTypes.NotFound, ResponseData = null
});
}
var dbParams = new DynamicParameters();
dbParams.Add("@Id", obj.Id, DbType.Int32);
string sql = $"delete from [dbo].[GeneralSettings] WHERE Id = @Id";
var Branch = await Task.FromResult(dapperManager.Execute(sql, dbParams, CommandType.Text));
return(new ResponseMessageBase <GeneralSettingsVM>()
{
MessageType = MessageTypes.Success, ResponseData = new[] { obj }
});
}
public Task<int> Delete(int id)
{
var deleteArticle = Task.FromResult(_dapperManager.Execute($"Delete c_order where ID = {id}", null,
commandType: CommandType.Text));
return deleteArticle;
}
