public static ProjKeyValueViewModel ToViewModel(this ProjKeyValue entity) { return(new ProjKeyValueViewModel { VarId = entity.VarId, EntityId = entity.EntityId, ProjectId = entity.ProjectId, EnvironmentId = entity.EnvironmentId, VarName = entity.VarName, VarValue = entity.VarValue, CreatedBy = entity.CreatedBy, CreatedDate = entity.CreatedDate, UpdatedBy = entity.UpdatedBy, UpdatedDate = entity.UpdatedDate }); }
public async Task <bool> UpdateProjKeyValuePair(ProjKeyValue ProjKeyValue, int varId) { IDbConnection dbConnection = _connectionFactory.GetConnection(); try { dbConnection.Open(); // var users = await dbConnection.QueryAsync<User>("Update tblUsers set email = '" + user.Email + "' where userid = " + user.UserId); string updateQuery = @"update tblprojkeyvalues set entityid = @entityid, projectid = @projectid, environmentid = @environmentid, varname = @varname,varvalue = @varvalue, createdby = @createdby, createddate = @createddate, updatedby = @updatedby, updateddate = @updateddate where varid = @varid"; var result = await dbConnection.ExecuteAsync(updateQuery, new { ProjKeyValue.EntityId, ProjKeyValue.ProjectId, ProjKeyValue.EnvironmentId, ProjKeyValue.VarName, ProjKeyValue.VarValue, ProjKeyValue.CreatedBy, ProjKeyValue.CreatedDate, ProjKeyValue.UpdatedBy, ProjKeyValue.UpdatedDate, varid = varId }); return(Convert.ToBoolean(result)); } catch (Exception ex) { throw ex; } finally { dbConnection.Close(); dbConnection.Dispose(); } //return true; //} }
public async Task <bool> CreateKeyValuePair(ProjKeyValue ProjKeyValue) { IDbConnection dbConnection = _connectionFactory.GetConnection(); try { dbConnection.Open(); // var users = await dbConnection.QueryAsync<User>("Update tblUsers set email = '" + user.Email + "' where userid = " + user.UserId); // string updateQuery = @"Update tblUsers set email = @email where userid =@userid"; string createQuery = @"insert into tblprojkeyvalues(varid, entityid, projectid, environmentid, varname, varvalue, createdby, createddate,updatedby, updateddate) values(@varid, @entityid, @projectid, @environmentid,@varname, @varvalue, @createdby, @createddate, @updatedby, @updateddate)"; var result = await dbConnection.ExecuteAsync(createQuery, new { ProjKeyValue.VarId, ProjKeyValue.EntityId, ProjKeyValue.ProjectId, ProjKeyValue.EnvironmentId, ProjKeyValue.VarName, ProjKeyValue.VarValue, ProjKeyValue.CreatedBy, ProjKeyValue.CreatedDate, ProjKeyValue.UpdatedBy, ProjKeyValue.UpdatedDate }); return(Convert.ToBoolean(result)); } catch (Exception ex) { throw ex; } finally { dbConnection.Close(); } }