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